forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: jplatinu on October 30, 2006, 09:46:27 am

Title: Fatal error : There was an error while processing a database query
Post by: jplatinu on October 30, 2006, 09:46:27 am: When we click on the "EVENT PICS" Section of our website
http://www.platinumworld.ca/index-site.htm (flash site)

we usually are redirected to the url: http://www.platinumworld.ca/gallery
or http://www.platinumworld.ca/gallery/albums/index.htm

which draws from the gallery/index.php

however now we are getting the following msg when we click on the link on the site:

Fatal error :
There was an error while processing a database query

please help us get our photogallery up online asap bc our clientelle are waiting for their pics from this wknd halloween events
Title: Re: Fatal error : There was an error while processing a database query
Post by: Joachim Müller on October 30, 2006, 10:17:22 am: Enable debug_mode and post the actual error message (the query that fails). Do not post debug_output. Check the tutorials section to find out how to enable debug_mode if you can't access coppermine's config panel.
Not an install issue, moving.
Title: Re: Fatal error : There was an error while processing a database query
Post by: jplatinu on October 30, 2006, 10:22:33 am: sorry if i sound really silly here
but what do u mean "enable Debug mode"??
Title: Re: Fatal error : There was an error while processing a database query
Post by: Joachim Müller on October 30, 2006, 10:32:32 am: http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#debug_mode
http://coppermine-gallery.net/tutorial/debug_mode.php
Title: Re: Fatal error : There was an error while processing a database query
Post by: jplatinu on October 30, 2006, 10:35:01 am: k so i did exactly that
and changed the 0 in debug mode to a 1
and saved and went back to previous screen

whats the next step?
i appreciate ur patience w me on this
Title: Re: Fatal error : There was an error while processing a database query
Post by: Joachim Müller on October 30, 2006, 10:41:22 am: You're running cpg1.3.x, which goes unsupported. You shouldn't have posted on the cpg1.4.x support board. Moving accordingly. Upgrade!
Title: Re: Fatal error : There was an error while processing a database query
Post by: jplatinu on October 30, 2006, 11:14:15 am: k so i debugged
now what do i do?
also does this mean that all the pics and everything we have up so far is now lost??
how would i go about upgrading? and how would this effect the gallery??
Title: Re: Fatal error : There was an error while processing a database query
Post by: Sami on October 30, 2006, 11:20:46 am: No you didn't lost anything Yet (your 1.3.x version has security issues)
Do as suggested and upgrade to most recent veresion (currently 1.4.10)
after upgrading if problem did exist we can go for it ;)
Title: Re: Fatal error : There was an error while processing a database query
Post by: jplatinu on October 30, 2006, 11:36:11 am: k then i will do the upgrade
do u have another one of those tutorials on how to upgrade tot he newest version??
Title: Re: Fatal error : There was an error while processing a database query
Post by: Sami on October 30, 2006, 11:38:09 am: http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#13
Title: Re: Fatal error : There was an error while processing a database query
Post by: jplatinu on October 31, 2006, 12:21:49 am: k updated the gallery to the new cpg 1.4.9
with the image magick etc

gallery still not working
Title: Re: Fatal error : There was an error while processing a database query
Post by: Nibbler on October 31, 2006, 12:45:23 am: You need to update your gallery, you have not done this. You need to enable debug mode in order to see the real error message.
Title: Re: Fatal error : There was an error while processing a database query
Post by: Joachim Müller on October 31, 2006, 05:46:55 am: As Nibbler suggested: you haven't upgraded http://www.platinumworld.ca/gallery/ as suggested, it is still running cpg1.3.x
Title: Re: Fatal error : There was an error while processing a database query
Post by: jplatinu on November 01, 2006, 05:03:15 am: hey guys
the tech who hosts our site wrote me this yesterday saying he did it already

Tech - - - : Nelson. 2006-10-30 / 14:24:32
Hi,
I have done the backup of your databases and also the gallery data and have updated the gallery. The update was ok without any errors you can check that at

http://www.platinumworld.ca/gallery/update.php

but the gallery is still not working.

Feel free to contact us if you need further assistance.

Regards,
Nelson

im not sure whats the problem here im tryin my best to b helpful w my limited understanding of all this, please let me know what the next step to take is
Title: Re: Fatal error : There was an error while processing a database query
Post by: Sami on November 01, 2006, 07:45:18 am: The guys didn't upgrade your gallery correctly !!!
your sql files are old (1.3.x version)
tell him Do exactly as suggested under upgradeing document .....
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#13
Title: Re: Fatal error : There was an error while processing a database query
Post by: jplatinu on November 01, 2006, 09:31:20 am: i have forwarded ur msg to them and will b in touch w their response asap
Title: Re: Fatal error : There was an error while processing a database query
Post by: Joachim Müller on November 02, 2006, 05:09:41 pm: Don't expect your webhost to upgrade for you. If you want the job to be done, do it yourself - your webhost has proven already that they don't understand Coppermine well enough to properly do the upgrade. In fact it doesn't matter who ignores the documentation: you or your webhost ::).