Strange MYSQL error after installing Wikiw

[jwocky]

First off, the wiki is amazing. I'm in love

But ever since installing it i'm getting these strange errors, about 3-5 per hour..

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,

editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid


FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 16 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 16 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.threadid =  AND post.dateline > 1224383443 AND (post.visible = 1 OR post.postid = 164690)

ORDER BY dateline;

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 'AND post.dateline > 1224383443 AND (post.visible = 1 OR post.postid = 164690)
' at line 27
Error Number  : 1064
Request Date  : Saturday, October 18th 2008 @ 10:56:41 PM
Error Date    : Saturday, October 18th 2008 @ 10:56:41 PM

Any ideas what the fix for this might be?

[pegasus]

This error can be safely ignored. There is an ongoing investigation into what causes it. Perhaps if you also report the content of the post that generated this error (id: 164690)

[jwocky]

This error can be safely ignored. There is an ongoing investigation into what causes it. Perhaps if you also report the content of the post that generated this error (id: 164690)

Well it seems from the error that the problem is that the ThreadID is being left blank in that call, I put in my (there should be a value here) in the place that was originally left blank.

Original
WHERE post.threadid = AND post.dateline > 1224383443 AND (post.visible = 1 OR post.postid = 164690)

WHERE post.threadid = (there should be a value here) AND post.dateline > 1224383443 AND (post.visible = 1 OR post.postid = 164690)

Im assuming in your hack it is clearing out the threadid value and null-ingit somewhere along the way, or its not globalizing and passing it or something along those lines.

[pegasus]

We are aware that the threadID is NULL but there is nowhere in the code where it would modify the threadID. Also considering that it doesn't happen in every Quick Reply, we believe there may be something in common with the content of the replies that do cause this (because the mod does run that through the parser before the query).

We believe that part of the issue arises because the $threadinfo array is not passed by reference in vBulletin's build_new_post() function, but as I said that is only part of the issue.

[pegasus]

We have not had this error pop up for months. I believe that we finally squashed it during the 2.2.x series (around January).