vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=245600

Unknown column 'attachment.postid' in 'field list'
by rrudeboy
30 Jun 2010 20:36

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

Quote:

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.

ChopSuey 01 Jul 2010 01:37

Did you try to rebuild attachments??

Maintenance > Update Counters

rrudeboy 01 Jul 2010 02:51

Quote:

Originally Posted by ChopSuey (Post 2062465)
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 01 Jul 2010 at 02:52 ---------------

also still have this one:


Quote:

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:\"use rs\";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/pos...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 01 Jul 2010 07:10

Looks like a modification is causing this.

rrudeboy 01 Jul 2010 13:04

yea, the Thanks mod is likely the culprit.

Lynne 01 Jul 2010 17:09

Both of those errors are from a modification.

rrudeboy 01 Jul 2010 17:18

Quote:

Originally Posted by Lynne (Post 2062806)
Both of those errors are from a modification.

i know, thanks for the help /sarcasm


All times are GMT. The time now is 12:18.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.