Tweet
Tried to upgrade... uploaded the new files and ran the upgrade script. The upgrade script appears to go through fine, but the board does not upgrade. It still registers as Beta 3 and gives the following error on the Thread Listing.
Database error in vBulletin 3.5.0 Beta 3:
Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN (0,17716,17773,17800,17777,17754,17782,17791,17621,17792,17772,17762,17769,12492,17770,177 61,17751,17745,17767,17763,5061,17744,17726,17746,17757,17705,17671,17727,17749,17743,1774 1)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown column 'hiddencount' in 'field list'
Error Number : 1054
Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN (0,17716,17773,17800,17777,17754,17782,17791,17621,17792,17772,17762,17769,12492,17770,177 61,17751,17745,17767,17763,5061,17744,17726,17746,17757,17705,17671,17727,17749,17743,1774 1)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown column 'hiddencount' in 'field list'
Error Number : 1054
Comment