database error issue

[rjp0615]

can someone shed some light on this for me? i just imported a db dump into a new server

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT pf.profilefieldid, pf.profilefieldcategoryid, pf.required, pf.type, pf.data, pf.def, pf.height
FROM profilefield AS pf
LEFT JOIN profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
WHERE pf.form = 0
ORDER BY pfc.displayorder, pf.displayorder;

MySQL Error : Table 'wrest7_forums.profilefieldcategory' doesn't exist
Error Number : 1146
Date : Thursday, August 2nd 2007 @ 10:26:40 PM
Script : http://wrestling-dungeon.net/forums/member.php?u=4716
Referrer : http://wrestling-dungeon.net/forums/...d.php?p=228347
IP Address : 75.35.243.47
Username : Dreamer
Classname : vb_database

[Antivirus]

iut seems like it's got something to do with the table prefix. Can you include your code for the query which is giving this error?

[rjp0615]

its no query, i just imported my forum to a new host, 5000+ members and this happened

[Antivirus]

It seems as though the database is expecting the table 'wrest7_forums.profilefieldcategory' to be in the database and it's not there. Look in your sql file you are trying to import and see if there's anything like DROP IF EXISTS, or CREATE TABLE, etc...

[rjp0615]

you're speaking greek to me now

[Antivirus]

the server is telling you the following error:

MySQL Error : Table 'wrest7_forums.profilefieldcategory' doesn't exist

It's expecting that table to exist and it doesn't.

How did you do your import? Using IMPEX or a mysql dump file?

ALSO: does your new vb installation's cfg file have anything set under the "table prefix" setting?

[rjp0615]

mysql dump, and no table prefix

[R1lover]

Is the old site still up? so you can try another backup of the database?

[rjp0615]

no, i just bought this site of somebody else, and this was the only backup i was given

[R1lover]

The only thing I can think to do, is to create the table and then see what happens.

There won't be any data in it but that may not be a big issue.