The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Please I need a little help here. about vb database.
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. |
#2
|
||||
|
||||
Is the table prefix in config.php set correctly? Are you sure the backup was complete?
|
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Are the tables in the database all have a common prefix?
|
#5
|
|||
|
|||
Quote:
Thanks |
#6
|
|||
|
|||
Look in the database with a tool like phpMyAdmin
|
#7
|
|||
|
|||
ok i can browse the tables through phpmyadmin. but what shall i do after browsing?
Thanks |
#8
|
||||
|
||||
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_'; |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|