Community Server >> VBulletin
 

Hi,

i recetnly migrated a community server forum to vbulletin.

in order accomplish this i had to host both the target (CS) and destination (VB) database on the same Windows server - (so IMPEX could read the CS's MSSQL database directly off the same host's servers).

now that i have the VB forum up and running, i am trying to move the VB to my linux hosting.

i backed up the VB database from the windows host as a .sql file and imported it to the linux host, via phpmyadmin (i think thats what its called)

now the vb forum in not loading
i keep getting DB errors as shown below.

2 things i have noticed;

1: the number of tables in the database is too few: its like 81 tables,
as opposed to 148 tables that i have for my other VB forums on with my linux host

2: the db type is InnoDB as opposed to MyISAM for my other VB forums on with my linux host

Code:
Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT *
FROM session
WHERE userid = 0
AND host = '66.249.16.212'
AND idhash = '2733525bdb96fe767d7d5999513e70f9'
LIMIT 1;

MySQL Error : Table 'gameonme_sbnet2.session' doesn't exist
Error Number : 1146
Request Date : Monday, May 4th 2009 @ 01:16:32 PM
Error Date : Monday, May 4th 2009 @ 01:16:32 PM
Script : http://www.sportsbiker.net/forums/
Referrer :
IP Address : 66.249.16.212
Username :
Classname : vB_Database
MySQL Version :
please advise as to what to do