Upgraded to latest version and when i clic k to view my tournaments that was created before the upgrade i get :
Database error in vBulletin 4.0.5:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*,
postparsed.pagetext_html, postparsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid,
user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight , customavatar.width_thumb AS width_thumb, customavatar.height_thumb AS height_thumb
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN forumsavatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN forumscustomavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1)
WHERE post.threadid = '3433'
AND post.visible != 2
ORDER BY post.dateline
LIMIT 1, 12;
MySQL Error : Table 'nextgen6_forum.post' doesn't exist
Error Number : 1146
Request Date : Sunday, September 19th 2010 @ 01:48:32 AM
Error Date : Sunday, September 19th 2010 @ 01:48:32 AM
Script :
http://www.nextgenerationgamers.co.u...p?do=view&id=6
Referrer :
http://www.nextgenerationgamers.co.u...itions.php?c=8
IP Address : 88.111.185.67
Username : NGG betts02
Classname : vB_Database
MySQL Version : 5.0.91-community
Any helo or ideas ?
Cheers in advance