PDA

View Full Version : phpbb 2.0.6 to vb 3.0.3 import problems



Night Owl
Sat 20th Nov '04, 6:27am
I edit the config file, uploaded the files and clicked the import / export link in the admincp.

This is the error I received:


Database error in vBulletin:ImpEx Target 3.0.3:

Invalid SQL: SELECT title, data FROM vb3_*datastore WHERE title = 'ImpExSession'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '*datastore WHERE title = 'ImpExSession'' at line 1

mysql error number: 1064

Date: Saturday 20th of November 2004 02:25:09 AM
Script: http://www.wahmreview.com/forums/impex/index.php
Referer: http://www.wahmreview.com/forums/admincp/index.php?do=nav

What could I be doing wrong?

Jerry
Sat 20th Nov '04, 6:44am
Setting the targettableprefix to : "vb3_*" opposed to "vb3_"

I would guess.

Night Owl
Sat 20th Nov '04, 1:48pm
I don't understand why impex wants me to add the *. When I look at the table in phpmyadmin, it vb3_datastore. My target prefix in impex is set at vb3_.

So, why is it adding the *? FTR, I tried changing vb3_ to vb3_* in impex and it didn't work.

Night Owl
Sat 20th Nov '04, 1:50pm
Apparently, I had a space after the vb3_ targettableprefix in impex. It's working now. LOL