forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: .holdme on June 13, 2008, 04:49:07 pm

Title: [Solved]: Critical error: There was an error while processing a database query.
Post by: .holdme on June 13, 2008, 04:49:07 pm

Hey. Like an ediot I clicked on 'Restore Factory Settings' and as soon as i clicked another page I got this error message:

Critical error
There was an error while processing a database query.

While executing query "DELETE FROM cpg_mod_online WHERE last_action < NOW() - INTERVAL  MINUTE" on 0

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

File: /home/kellyima/public_html/include/functions.inc.php - Line: 248

I enabled debug mode but i don't understand what its about. I think its something to do with the mod_online table in the database?

http://kellyimages.org/index.php Thats my gallery, the debug infomation is there or if you want me to post it here I will. Thanks for any help!

Title: Re: Critical error: There was an error while processing a database query.
Post by: Nibbler on June 13, 2008, 05:30:00 pm

Delete the online stats plugin from the plugins table manually using phpmyadmin and then reinstall it.

Title: Re: Critical error: There was an error while processing a database query.
Post by: .holdme on June 13, 2008, 05:39:18 pm

Thankyou so much. I looked all over this board trying to find the answer. Thankyou again!

Title: Re: [Solved]: Critical error: There was an error while processing a database query.
Post by: Nibbler on June 13, 2008, 06:06:52 pm

Great. You need to update to 1.4.18 though.