forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: kateheaven on January 05, 2011, 02:21:31 pm

Title: Critical Error - There was an error while processing a database query
Post by: kateheaven on January 05, 2011, 02:21:31 pm: I recently upgraded my Galleries from 1.4.27 to 1.5.10, and have since come across the following error on a few categories:

Quote
Critical Error
There was an error while processing a database query

This has happened on random categories - http://www.nkidman.com/gallery/index.php?cat=27 and http://www.isabellucasonline.org/gallery/index.php?cat=36 being two, although they are both fixed at the moment.

On http://www.isabellucasonline.org/gallery/index.php?cat=36 the error stopped showing after a little while and I was able to view the category. On http://www.nkidman.com/gallery/index.php?cat=27 I did some further research here and found someone mention a fix of disabling comment views below thumbnails. I tried that and the error message went away.

My question is, is it possible to allow the display of number of comments under thumbnails without getting this error? I couldn't find an answer to this here, but apologies if I have missed it. I'm also wondering if there's any other way I can prevent this error from occuring, seeing as it happened and then disappeared at http://www.isabellucasonline.org/gallery/index.php?cat=36 without me editing the comment thing etc.

Thanks for any help.
Title: Re: Critical Error - There was an error while processing a database query
Post by: Αndré on January 05, 2011, 02:34:42 pm: Enable debug mode so we can see the actual error message.
Title: Re: Critical Error - There was an error while processing a database query
Post by: kateheaven on January 05, 2011, 03:36:38 pm: Debug mode and notices in debug mode have now both been enabled on both http://www.nkidman.com/gallery/ and http://www.isabellucasonline.org/gallery/
Title: Re: Critical Error - There was an error while processing a database query
Post by: Αndré on January 05, 2011, 03:51:24 pm: Of course you need to enable the settings where the error occurs ;) If you don't want to retain your gallery in that state, just enable the settings, copy the detailed error message to this thread and disable the settings.
Title: Re: Critical Error - There was an error while processing a database query
Post by: kateheaven on January 05, 2011, 04:13:45 pm: Ah got it, oops!

At the moment it's only one category so I'll leave the debug and notices up for now: http://www.nkidman.com/gallery/index.php?cat=27

As I said, the error on http://www.isabellucasonline.org/gallery/index.php?cat=36 stopped showing by itself, so I can't do anything to get it up again for you to see the error notices.

Thanks
Title: Re: Critical Error - There was an error while processing a database query
Post by: Αndré on January 05, 2011, 04:22:43 pm: It's very hard to debug that without access to your website.

Quote
include/functions.inc.php on line 2445
belongs to the function count_pic_comments, which is called inside function build_caption:
Code: [Select]
if ($CONFIG['display_comment_count']) { $comments_nr = count_pic_comments($row['pid']); if ($comments_nr > 0) { $caption .= '<span class="thumb_num_comments">' . sprintf($lang_get_pic_data['n_comments'], $comments_nr) . '</span>'; } }which is called at several places at the code.

You can test several things:
1. disable the plugin engine, if you have installed some plugins
2. remove 'lastup' and 'random' from the content of the main page in Coppermine's config.
3. upload the theme 'curve' (you don't need to enable it, we can use that theme by adding the parameter
Code: [Select]
?theme=curve to the address bar)
Title: Re: Critical Error - There was an error while processing a database query
Post by: kateheaven on May 02, 2011, 02:42:34 pm: Hello again,

I thought the error had stopped, but it appears not. I hope it's ok to bring this thread up again.

Doing the things you suggested:

1. I have disabled all plugins at http://www.nkidman.com/gallery/

2. I have removed 'lastup,1/random,1/onlinestats' from the 'The content of the main page'

3. 'curve' theme has been uploaded

All at http://www.nkidman.com/gallery/

Let me know if you need more info.

Thanks in advance for any further help...
Title: Re: Critical Error - There was an error while processing a database query
Post by: Αndré on May 02, 2011, 02:45:31 pm: Quote from: kateheaven on May 02, 2011, 02:42:34 pm
1. I have disabled all plugins at http://www.nkidman.com/gallery/

2. I have removed 'lastup,1/random,1/onlinestats' from the 'The content of the main page'

3. 'curve' theme has been uploaded
Does the error still occur? If yes, where/when? I had a (very) short look at your gallery and it seems to work as expected.
Title: Re: Critical Error - There was an error while processing a database query
Post by: kateheaven on May 05, 2011, 11:59:36 pm: Yes, but only in one category from what I have noticed: http://www.nkidman.com/gallery/index.php?cat=27
Title: Re: Critical Error - There was an error while processing a database query
Post by: Joe Carver on May 06, 2011, 12:34:16 am: Something might be wrong with your theme.
The page source of your login page shows:
Quote

</body>
</html>


</body>
</html>
Which does not look right.

Try using:
http://www.nkidman.com/gallery/index.php?theme=curve
for a test
------------Edit
I looked at your site with Curve and that is not the problem - the theme will need to be fixed eventually...

Set Config >> Thumbnail view >> Display number of comments below the thumbnail to off (unchecked) for a test.
And also check your db for errors - backup and repair if needed.
------------/Edit
Title: Re: Critical Error - There was an error while processing a database query
Post by: Αndré on May 06, 2011, 09:48:43 am: If I remember right that error occurs if you've setup an album thumbnail that doesn't exist anymore. Try to update all album's thumbnails in that category.