Please I need a little help here. about vb database.

[MR.BOSS]

I imported a vbulletin database to my forum, i got an sql error.

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','style cache',
'languagecache','products','pluginlist','cron','pr ofilefield','loadcache','notic ecache','userstats','birthdaycache',
'maxloggedin','iconcache','
eventcache','mailqueue','blogstats','blogcategoryc ache');

MySQL Error : Table 'livelive_forums.datastore' doesn't exist
Error Number : 1146

thanks for any kind help.

[Dismounted]

Is the table prefix in config.php set correctly? Are you sure the backup was complete?

[MR.BOSS]

yes it is complete, 154 tables where impoted. the size was 22.5 mb.

how can i know if the table prefix is correct?

Thanks Dismounted.

[Marco van Herwaarden]

Are the tables in the database all have a common prefix?

[MR.BOSS]

Are the tables in the database all have a common prefix?

how can i know Marco?

Thanks

[Marco van Herwaarden]

Look in the database with a tool like phpMyAdmin

[MR.BOSS]

ok i can browse the tables through phpmyadmin. but what shall i do after browsing?

Thanks

[y2ksw]

The first table should be access. If it is something like vb_access, the prefix is vb_. To set the correct prefix, open your config.php and set:

$config['Database']['tableprefix'] = 'vb_';