Topic: [Solved]: Critical error: There was an error while processing a database query. (Read 2938 times)

.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!

Nibbler · « **Reply #1 on:** June 13, 2008, 05:30:00 pm »

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

.holdme · « **Reply #2 on:** June 13, 2008, 05:39:18 pm »

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

Nibbler · « **Reply #3 on:** June 13, 2008, 06:06:52 pm »

Great. You need to update to 1.4.18 though.

News:

Author Topic: [Solved]: Critical error: There was an error while processing a database query. (Read 2938 times)

.holdme

[Solved]: Critical error: There was an error while processing a database query.

Nibbler

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

.holdme

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

Nibbler

Re: [Solved]: Critical error: There was an error while processing a database query.