Mysql error
 

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT post.*,userfield.*, usertextfield.*, user.*, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar,
customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height,
customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb
FROM post AS post
LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (user.userid = usertextfield.userid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = post.userid)
WHERE post.postid IN (.);

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 10
Error Number : 1064
Request Date : Saturday, June 16th 2012 @ 10:27:40 AM
Error Date : Saturday, June 16th 2012 @ 10:27:41 AM
Script : http://forum.fckya.com/search.php?searchid=6843
Referrer : http://forum.fckya.com/search.php
IP Address : 98.218.239.123
Username : pmoyjap
Classname : vB_Database
MySQL Version :



I got this email twice (maybe user tried to search twice) , i get this email once in 3-4 days regularly , any fix for it ?

remove the ip from the post

who cares ?

Anyway bump , still need this.

Something to do with custom avatars so I would first try disabling/uninstalling and add-ons that have anything to do with avatars. Once you narrow it down to a specific mod, go to that mod's thread for a solution. And let us know what it was!