PDA

View Full Version : Database error


emmalr
Wed 14th Jun '06, 5:33pm
I've just purchased VBulletin and have uploaded it to my server.

I have only one MySQL database on my hosting account which I've alreay got used (Wordpress). I was told that I can use one database for two different applications.

I've entered my database info in the config file and it seems to connect to the database ok but comes back with an error:

Invalid SQL:

SELECT title, data
FROM datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron','userstats','birthdaycache','maxlo ggedin','iconcache','eventcache','mailqueue');

MySQL Error : Table 'betheband.datastore' doesn't exist
Error Number : 1146
Date : Wednesday, June 14th 2006 @ 09:03:01 PM
Script : http://www.betheband.co.uk/forum/ (http://www.betheband.co.uk/forum/)
Referrer :
IP Address : 82.39.48.128
Username :
Classname : vb_database

I've tried manually adding a 'betheband.datastore' table but it wont allow the '.' (my database is called betheband)

Any advice would be much appreciated - this site is a new charity project and I've got to get it up and running asap!

Emma.

Colin F
Wed 14th Jun '06, 5:37pm
Did you run the installation script at /install/install.php ?

emmalr
Wed 14th Jun '06, 5:56pm
I figured it out... spelling mistake in my config file!

It's always something stupidly simple!

Thanks!

Marco van Herwaarden
Sat 17th Jun '06, 10:45am
1 More suggestion: If you are also using the database for other things (ie. wordpress), it might be advisable to use a table-prefix (set in config). Otherwise you could get conflicts if the other products sharing the same database, is using the same name for a table.