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/showthread.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.

[rjp0615]

tried that, it gave me a different db error

[Antivirus]

if there's no table prefix set in the config file, try putting the following as the value for that:

wrest7_forums

[rjp0615]

nothing, all i get is a db error

[Antivirus]

same db error as before?

did any data get into your new db at all?

can you check your db with phpmyadmin and see wha tthe table it's looking for is called in the db then compare that to what the sql dump is looking for?

[mr moose]

i think this could be a problem with vbulletin itself i have been in contact with their support for exactly the same problem.

im awaiting a reply from them i even tried brand new sql database didnt work so tried new database server still didnt work

so its gotta be vbulletin itself

[Opserty]

vBulletin works fine normally, after all so many people use it. :p

Its when something happens which isn't normal that stuff breaks.

As stated above its worth checking out to see if them table does exist using a db administration tool such as phpMyAdmin. It could be that you were given an incomplete database backup.

Is the backup of the vBulletin from the same version as the one you have installed?

[rjp0615]

no, the backup is 3.6.7, and i use 3.6.8

[Opserty]

Can't you upload the files for 3.6.7 restore the database? Then follow the normal instructions for upgrading your version of vBulletin from 3.6.7 to 3.6.8. That would seem like a logical approach to me...

You could probably just upload the 3.6.8 files and run upgrade.php though I'd test out the forum with the 3.6.7 files if I were in your shoes.

[Pc 1203]

I'd try vBulletin's Support Ticket System for this.

- Pc1203

[rjp0615]

problem solved, downgraded to 3.6.4 and redumped the db. thanks for your help.

[Antivirus]

glad you got it all worked out :)