Trying to upgrade* database error 1146
 

Newbie* at best. I'm preparing to move my forum to another host. I've set up the domain and DB at new host. I took all of the files from the old host and uploaded to new host. Ran install and went ok* but none of the current stuff/mods/etc were on new one.

I then uploaded my DB from the backup. I then get a message that I needed to run upgrade and maybe run bitfield repair. So I did upgrade* and then with tools.php attempted to repair bitfields* All that I see is Update bitfields cache. Which I did* nothing seems to "fix" this.

In the end I get this message:

Quote:
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT COUNT(*) AS count
FROM attachment AS attachment
INNER JOIN post AS post USING (postid)
WHERE attachment.visible = 0;

MySQL Error : Table 'xxxxxx_vb.post' doesn't exist
Error Number : 1146
Date : Sunday* October 25th 2009 @ 09:29:57 PM
Script : http://mydomain/admincp/index.php?do=home
Referrer : http://mydoman/admincp/index.php
IP Address : xxxxxxxx
Username : xxxxxxxx
Classname : vB_Database

I then attempted to create the post table* using the info from the old* to the new. I get an error 1170 from that side. I did make postid the primary and the other info appears to be right.

#1170 - BLOB/TEXT column 'pagetext' used in key specification without a key length

This may be related* the userid* threadid* title* in one of the errors showthat these are a "key" does that mean that I need to click on "unique" with these?

Any help would be appreciated.