Unknown column 'attachment.postid' in 'field list'

[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/modcop/moderate.php?do=attachments
Referrer : http://totalsmartphone.net/forum/modcop/index.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.

[ChopSuey]

Did you try to rebuild attachments??

Maintenance > Update Counters

[rrudeboy]

Did you try to rebuild attachments??

Maintenance > Update Counters

thanks.... just did a rebuild, not sure how to reproduce the issue so i guess i'll wait and see.

--------------- Added 1277949170 at 1277949170 ---------------

also still have this one:


Database error in vBulletin 4.0.3:

Invalid SQL:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '66.249.71.205', 1, 'n99hockey', '', 'post.dateline', 'DESC', 0.00095, 1, '20243', 1277926672, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:9;s:9:\"n99hockey\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', 'f1be740ef3315ab9d620baeecc1b6b74');

MySQL Error : Table 'roeiboo_berry.search' doesn't exist
Error Number : 1146
Request Date : Wednesday, June 30th 2010 @ 02:37:52 PM
Error Date : Wednesday, June 30th 2010 @ 02:37:53 PM
Script : http://totalsmartphone.net/forum/post_thanks.php?do=findthanks&u=9
Referrer :
IP Address : 66.249.71.205
Username : Unregistered
Classname : vB_Database
MySQL Version :


added: am rebuilding the search index as well....

[ChopSuey]

Looks like a modification is causing this.

[rrudeboy]

yea, the Thanks mod is likely the culprit.

[Lynne]

Both of those errors are from a modification.

[rrudeboy]

Both of those errors are from a modification.

i know, thanks for the help /sarcasm