[alain4ever]

hi

i have install this hack on my vb3.0.0 rc1 and it works fine.... but after upgrade my vb to rc3 and try to use the hack every thing work fine exept news, when i try to set forum news number i got an error, i try to uninstall and reinstall it 2 times but i got the same error....

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(76)
				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: Monday 26th of January 2004 09:02:42 AM