Geeklog Forums

Would like to know how I can have the complete error log from mysql. As of now, errors show up looking like this. The user listed in config.php has full access rights to the database. Any other suggestions would be appreciated. Thanks

Using:
Geeklog version 1.3.11sr1
Mysql 4.1.13
PHP 4.4.0

7/20/2005 2:05:56 PM - 1064: 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. SQL in question: SELECT COUNT(*) FROM

I guess that is the complete SQL statement - and the reason why MySQL complained in the first place ...

Taking a wild guess: Installed any plugins recently? This could be for the entries in the Admin menu, but missing the actual table name.

bye, Dirk

I was thinking the same thing too, but the last plugin I installed was about a month ago (randomquote) and everything was working fine until just recently about four days ago. It happens when I try to sign in. After clearing the sessions in the database, the site is up again in the logged out state.

I'll try to uninstall any plugins I have and try from there. Any other suggestions would be greatly appreciated.

Thanks agian,
Joe

EDIT: Got the site back up, the problem was the Bad Behavior Plugin for v1.3.11sr1 for some odd reason on another site. My site is currently using 1.3.12cvs and working fine.

This reply is more to help others than anything else.

The Bad Behavior Plugin is working fine. When I upgraded the site from 1.3.11 to 1.3.11sr1 by replacing the lib-common file, I forgot to add the entry needed inside lib-common in order to make the plugin work.

Anyway, hope this helps. I had to disable the plugin for awhile before figuring this out.

Joe