Import error in ImPex for vB 3.5.1 from phpBB 2.0.17

[NineToez]

Could you shed a little more light on this? I too am getting this very same mysql error (I was using phpBB 2.0.17 tho), however adding the source tableprefix in ImpExConfig.php isn't correcting it.

Wasn't trying to hijack someone else's thread, but figured it was relevant which was why I posted this question there.

I recently installed vB 3.5.1 and am trying to import the entire database from phpBB 2.0.17 and got this error :

Module 001 Check and update database

Altering tablesImpEx will now Alter the tables in the vB database to include import id numbers.This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time.They will also be left after the import if you need to link back to the origional vB userid.
moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed

Valid found tables :


Possiablly custom tables or incorrect prefix :

attachments NOT found.
attachments_desc NOT found.
auth_access NOT found.
banlist NOT found.
categories NOT found.
config NOT found.
confirm NOT found.
disallow NOT found.
forum_prune NOT found.
forums NOT found.
groups NOT found.
posts NOT found.
posts_text NOT found.
privmsgs NOT found.
privmsgs_text NOT found.
ranks NOT found.
search_results NOT found.
search_wordlist NOT found.
search_wordmatch NOT found.
sessions NOT found.
smilies NOT found.
themes NOT found.
themes_name NOT found.
topics NOT found.
topics_watch NOT found.
user_group NOT found.
users NOT found.
vote_desc NOT found.
vote_results NOT found.
vote_voters NOT found.
words NOT found.

If you have all red tables, i.e. none correct this could possible be your table prefix :


phpbb_album_


Module 002 Associate users

There seems to have been a problem with the database.

ImpEx Database errormysql error: Invalid SQL:
SELECT user_id,username
FROM users
ORDER BY user_id
LIMIT 0,25
mysql error: Table 'mysqlxxxxxxxxxxxxxxxxxx.users' doesn't exist
mysql error number: 1146
Date: Tuesday 15th of November 2005 07:33:45 PM


What am I doing wrong?

[Jerry]

As it sayes you haven't set your source table prefix.

I'm guessing its phpbb_

[NineToez]

Jerry, I appreciate your response, however I might have left that portion of the info out since it shoulda been a given, but here's what I selected on the index page of ImPex :

Select Source Board Format :: 37. phpBB2

Select version to export to :: vBulletin 3.5.1

[katman]

Jerry, I appreciate your response, however I might have left that portion of the info out since it shoulda been a given, but here's what I selected on the index page of ImPex :

Select Source Board Format :: 37. phpBB2

Select version to export to :: vBulletin 3.5.1

That's not what he's talking about. He's saying you did not declare the table prefix, not what database you are import from and to, these are 2 different things. In the ImpExConfig.php you have to enter the correct value in this field >

$impexconfig['source']['tableprefix'] = 'phpbb_';
$impexconfig['target']['tableprefix'] = 'vb_';

[NineToez]

That sounds a little more like it! I've been tinkering around a little bit and did start to think that was in fact the missing link. Gonna give a shot and see what happens! I swear I'm not this much of a n00b, but of course something this silly will mess everything up. Will post back results.

[NineToez]

Got it to work finally, however it's a chore putting all the info from the database where it belongs in vB. Thought it would be more automated and simpler, but I want it done right so it'll be worth it in the long run. Thanks again for helping a n00b!!