coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: anita* on November 09, 2004, 12:56:11 AM

Title: There was an error while processing a database query
Post by: anita* on November 09, 2004, 12:56:11 AM
hello everybody!

i think that i killed my gallery  :\'(

i know that there are lots of similar messages, but i can't find the answer to what i need... i had nuke on my website that was not connected to anything, so i decided to remove it... hmmm... that wasn't smart, because somehow now my gallery doesn't work. here is the error message:


Notice: Undefined index: debug_mode in /home/rupagesc/.panel/web/bulletin/bb/cpg1.2.0rc2/include/functions.inc.php on line 96
Fatal error :
There was an error while processing a database query


any ideas???

i've tried to restore database, but i have no idea what i am doing anymore...
here is link: http://www.rupages.com/gallery/index.htm
Title: Re: There was an error while processing a database query
Post by: Tranz on November 09, 2004, 01:06:08 AM
So you removed the database that contained your nuke and gallery?

Did you backup before removing it?
Title: Re: There was an error while processing a database query
Post by: anita* on November 09, 2004, 01:24:53 AM
TranzNDance,
yes, i think that i removed it... but i am not sure because when i go to the website structure, i can still see all the files. ??? as far as i understand, the gallery had nothing to do with nuke... and yes, i do have a backup. any suggestions?
Title: Re: There was an error while processing a database query
Post by: Nibbler on November 09, 2004, 12:28:44 PM
Verify the database exists with a tool such as phpmyadmin, if it does then set debug_mode to 1 in the config table and try the gallery again. If it does not exist then restore it from backup.
Title: Re: There was an error while processing a database query
Post by: anita* on November 11, 2004, 05:22:46 AM
Quote from: Nibbler on November 09, 2004, 12:28:44 PM
Verify the database exists with a tool such as phpmyadmin, if it does then set debug_mode to 1 in the config table and try the gallery again. If it does not exist then restore it from backup.

yes, the database exists and myphpadmin checked it, the status is ok. i cannot find where to set the debug mode though... :((((
Title: Re: There was an error while processing a database query
Post by: anita* on November 11, 2004, 05:57:26 AM
sorry for my lack of knowledge, but could anyone also tell me how to restore database????  ::)
Title: Re: There was an error while processing a database query
Post by: Joachim Müller on November 11, 2004, 06:53:59 AM
if you actually have a backup of your database (a so-called dump), read the documentation of phpMyAdmin to find out how to restore it - you just upload (or copy'n paste the content) in the sql window. My blind guess is that you only have a backup of your files though, but not a database dump. In this case, all your data is lost and can't be recovered. Fiddling with database tools and deleteing stuff there without knowing what you do is always a bad idea, you just found out the hard way... ;)

Joachim
Title: Re: There was an error while processing a database query
Post by: anita* on November 15, 2004, 07:24:52 AM
guys, thank you very much for your answers!

the strange thing is that when i go to the "backdoor" of my website, i see all the files. is it possible that it doesn't go to the right place any more? where can i find a line that actually points to the gallerys' path?
Title: Re: There was an error while processing a database query
Post by: Joachim Müller on November 15, 2004, 07:50:09 AM
I think you don't get the concept: we're talking about database entries, not files here. I strongly recommend asking your webhost for support, and do so asap: the longer you wait, the less likely it is your webhost has got a backup of your database (ask them nicely, they don't have to back up the db for you. You're asking for a favor).

You will have to use the proper words in your support requests, I don't know what a "backdoor" is in this context.

Joachim
Title: Re: There was an error while processing a database query
Post by: anita* on November 15, 2004, 08:06:25 AM
Joachim,
thanks! I wish I knew what I mean :)))) I'll try to call them, for some reason I didn't think they might have a copy. thanks again!!