PDA

View Full Version : Whats wrong here can someone help please


Hanif
Tue 5th Apr '05, 8:39am
Hi all,

Manage to successfully install vBulletin and I'm now at version 3.0.7.

What would like to do is upgrade my current forums that are in SMF 1.0.2 to vBulletin.

However, I'm running into a few problems

The error message I keep getting is the following:

Invalid SQL: SELECT title, data FROM datastore WHERE title = 'ImpExSession'
mysql error: Table 'mulimpro.datastore' doesn't exist

mysql error number: 1146

When I'm running the Import/Export utility from the Admin Control Panel.

My ImpExConfig Scipt has the following values:

[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.

targetdatabasetype = mysql
targetserver = localhost
targetuser = mulimpro
targetpassword = *******
targetdatabase = mulimpro
targettableprefix =

[ Source Database ]
; If the system that is being imported from uses a database,
; enter the details for it here and set 'sourceexists' to TRUE.
; If the source data is NOT stored in a database, set 'sourceexists' to FALSE

sourceexists = true

; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = mulimpro
sourcepassword = *******
sourcedatabase = mulimpro
sourcetableprefix = smf_

Whats going wrong????

Anyone please.

Kind regards,

Hanif

Steve Machol
Tue 5th Apr '05, 3:12pm
Run this script to restore your datastore table:

http://www.vbulletin.com/forum/showpost.php?p=575568&postcount=7

Hanif
Tue 5th Apr '05, 3:31pm
Steve,

Thanks for that but I was missing the extension to vb3 in the targettableprefix = vb3

Installed the board and now just testing it.

From SMF to vBulletin in one day and thats with all the users, threads migrated as well.

A truly wonderful product.

Pass on my thanks to the team.

Hanif