Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 30 Jun 2010, 19:36
rrudeboy's Avatar
rrudeboy rrudeboy is offline
 
Join Date: May 2009
Question Unknown column 'attachment.postid' in 'field list'

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.
__________________
~rb 
Reply With Quote
  #2  
Old 01 Jul 2010, 00:37
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Real name: Corey
Did you try to rebuild attachments??

Maintenance > Update Counters
Reply With Quote
  #3  
Old 01 Jul 2010, 01:51
rrudeboy's Avatar
rrudeboy rrudeboy is offline
 
Join Date: May 2009
Originally Posted by ChopSuey View Post
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 01:52 ---------------

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:\"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....
__________________
~rb 

Last edited by rrudeboy; 01 Jul 2010 at 01:55. Reason: Auto-Merged DoublePost
Reply With Quote
  #4  
Old 01 Jul 2010, 06:10
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Real name: Corey
Looks like a modification is causing this.
Reply With Quote
  #5  
Old 01 Jul 2010, 12:04
rrudeboy's Avatar
rrudeboy rrudeboy is offline
 
Join Date: May 2009
yea, the Thanks mod is likely the culprit.
__________________
~rb 
Reply With Quote
  #6  
Old 01 Jul 2010, 16:09
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Both of those errors are from a modification.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #7  
Old 01 Jul 2010, 16:18
rrudeboy's Avatar
rrudeboy rrudeboy is offline
 
Join Date: May 2009
Originally Posted by Lynne View Post
Both of those errors are from a modification.
i know, thanks for the help /sarcasm
__________________
~rb 
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

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

Layout Options | Width: Wide Color: