[Zachery]

Originally Posted by eger

im gettin this error after install. followed all directions.

Database error in vBulletin 3.0.0 Release Candidate 3:
 
Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
			 , avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline 
			 ,thread.iconid 
			  ,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize 
				FROM thread AS thread
				LEFT JOIN post AS post ON (post.postid = thread.firstpostid) 
				LEFT JOIN user AS user ON (user.userid = post.userid) 
				LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
				LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid) 
				LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
				WHERE forumid IN(2)
				GROUP BY post.postid
				ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous
 
mysql error number: 1052
 
Date: Friday 23rd of January 2004 01:23:03 PM
Script: http://test.test.test
Referer: 
Username: test
IP Address: 63.63.63.63

EDIT: i've determined this to be the New attachment option. when i turn it off, the page displays. BUT it only displays the very first thread from the news forumid and it only displays the Subject, not the text from the post. this is odd =\

did you upgrade? with the correct upgrade script?