Database error in vBulletin

[Allen Reed]

Hello,

I bet this has been posted many times, can't seem to find the answer I am looking for. I recently had to change servers to WHM 11.23.2 cPanel my previous server I had my forum up and running. After transferring my files I continue to get this error message. How do I go about fixing this?

Invalid SQL:
SELECT title, data
FROM datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupcache','stylecache','languagecache','prod ucts','pluginlist','cron','userstats','birthdaycache','maxloggedin','iconcache','eventcach e','mailqueue');
MySQL Error : Table 'wqmamon_forums.datastore' doesn't exist
Error Number : 1146
Date : Tuesday, October 21st 2008 @ 04:31:14 AM

[Jake Bunce]

1) Did you transfer your database to the new server? If the database on the new server is empty then that would explain the error.

2) Make sure the table prefix is correct in your includes/config.php file.

[roots549]

similar error

I just installed a new vbulletin, on a new server, with a new sql dbase

I am unsure about the config.php file prefix setting.

I left it blank, installed vbulletin and got this error:

I have recently create a new sql database; moviepal_forum and installed vbulletin to /public_html/forum

At first attempt to open the new forum I get the following error:
____________________________________

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','user stats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');

MySQL Error : Table 'moviepal_forum.datastore' doesn't exist
Error Number : 1146
Request Date : Saturday, November 22nd 2008 @ 05:31:52 AM
Error Date : Saturday, November 22nd 2008 @ 05:31:52 AM
Script : http://www.moviepals.net/forum/
Referrer :
IP Address : 200.232.233.210
Username :
Classname : vB_Database
MySQL Version :

____________________________________

Perhaps assigning a prefix such as "vb_" to my sql tables and then updating the vbulletin config.php file would solve this?

I do not know how to make the sql prefix changes in cpanel.

Also,

"Jake Bunce;1641020]1) Did you transfer your database to the new server? If the database on the new server is empty then that would explain the error."

I imagine the db is completely empty, this is a new server, vbull, db...how how does one correct this?

thanks

Please advise.

eric

[Jake Bunce]

If you didn't copy the database to the new server then you need to do that. This is the recommended backup / restore method:

http://www.vbulletin.com/docs/html/main/maintenance_ssh_backup

http://www.vbulletin.com/docs/html/main/maintenance_ssh_restore