Mysql error

[Bladed]

I just moved my forum to a new host. It took us several days to get the database to the point of where I could even access it, due to the poor hosting service of the previous host.
Here is the error message (user name has been starred out:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT *
FROM session
WHERE userid = 0
AND host = '157.55.33.34'
AND idhash = '3f0601152dfc3592e95afec8f1e250b1'
LIMIT 1;

MySQL Error : Table '********_vbulletin.session' doesn't exist
Error Number : 1146

What do I need to do to fix this?

[nerbert]

What do you have for your table prefix in includes/config.php? Check your database with phpMyAdmin if you don't know what it's supposed to be

[ForceHSS]

you have a missing table session not there upload all files for your version and run upgrade.php should replace it and any others missing

[Bladed]

this was odd. I restarted my computer due to lag on my ftp client, while uploading the install file. When I restarted my browser my forum came up and is working ok now.

[ForceHSS]

Even so still do what I said above as that table is still missing and others might be as well

[Bladed]

I checked the database before I posted this and the session table is there. (shrug)

[ForceHSS]

Table '********_vbulletin.session' doesn't exist
In you first post you seem to of blocked some part of the message out without this info I am going by what I see without the full message its hard to help and I can only go with info given

[Bladed]

What was blocked out as I said in the op was the user name.
I've had my forum up since then, however I discover the C99madShell v. 2.0 madnet edition hack. So I've now deleted the old install and trying to upgrade to the new version.