[Forum] MYSQL error

[sahareto]

I recevied this error 3 time at the day

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  : Thursday, November 22nd 2012 @ 03:39:13 PM
Error Date    : Thursday, November 22nd 2012 @ 03:39:13 PM
Script        : http://www.mysite.com/vb/search.php?searchid=415575
Referrer      : http://www.mysite.com/vb/search.php?do=process
IP Address    : 41.254.2.247
Username      : username
Classname     : vB_Database
MySQL Version : 

how to know from where the problem
and how to solve it

thanks

[Hartmut]

Look like there is a postid missing in the query. Are you using third party addons? That could be an explanation.

[sahareto]

yes and that is what I use

Anti Bump old Threads plugin-DE 1.0
CT second_post_Ads 2.0.8
Digital Point Analytics 1.1.1
Forum Runner 4.2.0
LancerForHire, LLC. - Bot Blocker 1.2
Links and Downloads Manager 3.0.2
Links and Downloads Manager Extras 3.0.2
Make Prefixes Clickable to Filter Forumdisplay 1.1
No Logout for Banned Users 2.0.0
Post Thank You Hack 7.82
Quick Auto Image-Resize (Posts & Signature) 1.0.0
Recent Thanks 2.6.2
Separate Sticky and Normal Threads 1.1
Skimlinks Plugin 4.2.0
Threads Auto Close advanced (by Usergroup) 0.5
Threads notifications 3.0
Usergroup Color Bar 2.1.1
vBSEO :: Sitemap Generator 3.0
VSa - Login To User Account
VSa - Sub-Forum Manager
[APM] Advanced Product Management
[CKEditor] MARCO1 Advanced Quick Reply And Edit

[Zachery]

What happens when you disable all of those addons?

[sahareto]

I think the error will not appear (because this error happened recently and not happened before)

But I don't know which one make this error
because that error happened 2 time per day

is there any way to know which one make this error ?

[Trevor Hannant]

Disable them all then turn one on at a time until you see which one causes the problem.