vb.org Archive - Unknown column 'attachment.postid' in 'field list'

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Unknown column 'attachment.postid' in 'field list' (https://vborg.vbsupport.ru/showthread.php?t=245600)

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

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.

Did you try to rebuild attachments??

Maintenance > Update Counters

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 [DATE]1277949170[/DATE] at [TIME]1277949170[/TIME] ---------------

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:\"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/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....

Looks like a modification is causing this.

yea, the Thanks mod is likely the culprit.

Both of those errors are from a modification.

Quote:

Originally Posted by Lynne (Post 2062806)

Both of those errors are from a modification.

i know, thanks for the help /sarcasm

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02137 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: