v4.1 Error Message

[TheFiringLine.com]

I'm getting the following errors mailed to me. I understand that it's coming from post attempts, but I don't know what's causing it or how to correct it. All help appreciated.
Thanks-
Rich

Database error in vBulletin: Invalid SQL:
SELECT


post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter


FROM
post


LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid


LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid


WHERE
post.postid IN ()
ORDER BY dateline


mysql error: You have an error in your SQL syntax near ')
ORDER BY dateline
' at line 16
mysql error number: 1064

[Wayne Luke]

Bug fix is listed in the bug tracking thread in the bug forum.

[TheFiringLine.com]

Thanks much.
Rich

[TheFiringLine.com]

Nope-
Not in there. I see a post from Ed or John elsewhere that would indicate it's not yet published? Is this correct or am I missing the fix?
Rich

[TheFiringLine.com]

Still looking for help on this one.
10Q
Rich

[Wayne Luke]

I quote:

SQL error from showthread pages that don't exist.

showthread.php, change:

$postids=""; 
 while ($post=$DB_site->fetch_array($getpostids)) {
   $postids.=",".$post[postid]; 
 }
 $postids="post.postid IN (".substr($postids, 1).")";

to

$postids="post.postid IN (0"; 
 while ($post=$DB_site->fetch_array($getpostids)) { 
   $postids.=",".$post[postid]; 
 } 
 $postids.=")";

From thread:
http://www.vbulletin.com/forum/showt...threadid=12971

[TheFiringLine.com]

Thanks again, Wayne.
I didn't connect that fix with the problem.
Rich