[rrudeboy]

i keep getting this (email) error since i upgraded to vB 4.0.3;

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT user.username, post.username AS postusername, attachment.filename, attachment.postid, thread.forumid, thread.threadid, attachment.thumbnail_dateline,
attachment.attachmentid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize, attachment.filesize, attachment.dateline
FROM attachment AS attachment
LEFT JOIN post AS post ON (attachment.postid = post.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN user AS user ON (attachment.userid = user.userid)
WHERE thread.forumid IN(43, 48, 44, 53, 50, 49, 51, 3, 18, 32, 8, 9, 10, 11, 26, 16, 19, 24, 20, 27, 22, 34, 37, 35, 36, 72, 38, 41, 40, 52, 67, 68, 69, 70, 71, 54, 66, 55, 56, 57, 64, 63, 58, 59, 60, 61, 62, 4, 12, 13, 29, 14, 15, 23, 42, 65, 21) AND attachment.visible = 0 AND attachment.postid <> 0;

MySQL Error : Unknown column 'attachment.postid' in 'field list'
Error Number : 1054
Request Date : Monday, June 28th 2010 @ 01:39:00 PM
Error Date : Monday, June 28th 2010 @ 01:39:01 PM
Script : http://totalsmartphone.net/forum/mod...do=attachments
Referrer : http://totalsmartphone.net/forum/mod...dex.php?do=nav
IP Address : 24.184.225.144
Username : xxxxx
Classname : vB_Database
MySQL Version : 4.1.20-max-log

any idea what could be wrong ?

thanks.