Suite Database Error after switching to 4.0
 

Hello.

According to the intitial announcement if you are running 3.8.4. you do not need to run any scripts.

So I did as instructed and merely put the upload files into my server.

At first I had a redirect loop error* but that was fixed after changing content.php in my index.php file to forum.php. (Did you follow that?)

NOW

I am getting this database error.

Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT forum.forumid* forum.lastpost* forum.lastposter* forum.lastposterid* forum.lastthread* forum.lastthreadid* forum.lasticonid* forum.threadcount* forum.replycount* forum.lastpostid* forum.lastprefixid* user.usergroupid* user.homepage* user.options AS useroptions* IF(userlist.friend = 'yes'* 1* 0) AS isfriend

FROM forum AS forum

LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1);

MySQL Error : Unknown column 'forum.lastposterid' in 'field list'
Error Number : 1054
Request Date : Thursday* December 24th 2009 @ 09:10:08 PM
Error Date : Thursday* December 24th 2009 @ 09:10:08 PM
Script : http://www.theforumgame.net/forum/
Referrer :
IP Address : 67.249.248.84
Username : Fatality
Classname : vB_Database
MySQL Version : 5.0.88-community-log
I also get the following in my admin CP

Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT count(*) as count
FROM template AS tCustom
INNER JOIN template AS tGlobal ON
(tGlobal.styleid = -1 AND tGlobal.title = tCustom.title)
LEFT JOIN templatemerge AS templatemerge ON
(templatemerge.templateid = tCustom.templateid)
WHERE tCustom.styleid -1
AND tCustom.templatetype = 'template' AND tCustom.mergestatus IN ('merged'* 'conflicted')
ORDER BY tCustom.title;

MySQL Error : Unknown column 'tCustom.mergestatus' in 'where clause'
Error Number : 1054
Request Date : Thursday* December 24th 2009 @ 09:16:08 PM
Error Date : Thursday* December 24th 2009 @ 09:16:08 PM
Script : http://www.theforumgame.net/forum/ad...ex.php?do=home
Referrer : http://www.theforumgame.net/forum/admincp/
IP Address : 67.249.248.84
Username : Fatality
Classname : vB_Database
MySQL Version : 5.0.88-community-log
Site link: http://www.theforumgame.net/forum/

I figured...maybe I DO need to use the upgrade file* but when I went to it the file said it was going to upgrade to ALPHA and well* that certainly isn't what I want. I downloaded the lastest version from the customer download panel.