PDA

View Full Version : Impex Problems



NickGood
Sat 16th Apr '05, 1:28pm
I am having problems getting Impex to run to convert a PhpBB 2.0.13 fourm to vBulletin.

I get this error -
Database error in vBulletin:ImpEx Target 3.0.7:

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

mysql error number: 1146

I think my problem is one of simple syntax in the ImpExConfig.php file. This is
the entry for the Target...
targetdatabasetype = mysql
targetserver = localhost
targetuser = cruise8_import
targetpassword = Password
targetdatabase = cruise8_vbulletin
targettableprefix =

...for the source...

sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = cruise8_import
sourcepassword = Password
sourcedatabase = cruise8_phpbb1
sourcetableprefix =

I have attached a screen print of my Cpanel My SQL page. Can someone who is a font of such wisdom please check that the syntax above squares with this attachement as this is my theory as to the source of my problem.

Any other ideas would be appreciated...

Customer Number:

Zachery
Sat 16th Apr '05, 1:54pm
Did you install vBulletin with a table prefix?

NickGood
Sat 16th Apr '05, 4:25pm
Did you install vBulletin with a table prefix?
My ignorance is such that I don't understand this question!

I followed the instructions to the best of my ability

Steve Machol
Sat 16th Apr '05, 7:22pm
As per your support ticket, you were using the wrong targettableprefix.

NickGood
Sun 17th Apr '05, 2:36am
Thanks Impex seems to be running now!