PDA

View Full Version : mysql problems moderating


ColdSpirit
10-07-2007, 07:19 PM
Hello,

i have this error each time i am trying to moderate the threads....


Invalid SQL:

SELECT * FROM user as u
LEFT JOIN usergroup as ug ON (u.usergroupid = ug.usergroupid)
LEFT JOIN post as p ON (u.userid = p.userid)
WHERE postid=;

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 4
Error Number : 1064
Date : Sunday, October 7th 2007 @ 04:00:45 PM
Script : http://www,domain.com/moderation.php?do=viewthreads&type=deleted
Referrer :
IP Address : xxx.xxx.xxx.xxx
Username :
Classname : database


Does anyone know how i can fix this?


thank you,
ColdSpirit

Paul M
10-07-2007, 09:02 PM
That is a faulty plugin, you need to track down which product/plugin and disable it.