phpBB import problem

[macara]

I need to import database from phpBB2.0.22 to vBulletin 3.6.5


Selection - Check and update database

Pressed - Start Module

Move to page:

Get database information
This module will check the tables in the database as well as the connection.

Pressed - Check and update database

Result:

Import / Export
ImpEx build version : 1.80
Database cleanup & restart ||| Online manual
Using includes/config.php for target config.

Altering tables
ImpEx 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
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed
Valid found tables :

Possibly 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 :

mkp_ Failed Check database permissions and connection, or table prefix to ensure its correct
vBulletin® v3.6.5, Copyright ©2000-2007, Jelsoft Enterprises Ltd.2007

Pressed - Continue

Move to page:

Import / Export :: phpBB2

Selection - Associate Users
Pressed - Start Module

Show the following letter:

This module is dependent on Check and update database cannot run until that is complete.

Pressed - Continue

Where is the error?

Thank you in advance for assistance.

[Steve Machol]

That's because it failed the check:

mkp_ Failed Check database permissions and connection, or table prefix to ensure its correct

Something is wrong in your ImpExConfig.php settings.

[macara]

Thank you very much for assistance. Possible clarified more?

[Steve Machol]

The source db info in your ImpExConfig.php file is wrong. You need to edit that file with the correct info.

[macara]

Thank you once again for this assistance.

I think in a deadlock

Did you mean the data here:

####
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'xxxxxxxxxxxx';
$impexconfig['target']['password'] = 'xxxxxxxxxxxx';
$impexconfig['target']['database'] = 'xxxxxxxxxxxx';
$impexconfig['target']['tableprefix'] = '';
# 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
$impexconfig['sourceexists'] = true;
####
#
# SOURCE - The source is the old forum database (where the data is coming from)
#
####
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mysql'; // mysql OR mssql
$impexconfig['source']['server'] = 'localhost';
$impexconfig['source']['user'] = 'xxxxxxxxxxxx';
$impexconfig['source']['password'] = 'xxxxxxxxxxxx';
$impexconfig['source']['database'] = 'xxxxxxxxxxxx';
$impexconfig['source']['tableprefix'] = '';
####
#
# DUPLICATE CHECKING
# Where unique import id's are aviable ImpEx can check for duplicates with some
# Tier2 systems this will need to be set to false.
#
# yahoo_groups,
#
####

[Steve Machol]

Yes, specifically the source db info.

[macara]

Thank you for such care.

Deleted Forum database and started from scratch but it didn't help.

I do not know what I do?

I have this problem since five days.

[Steve Machol]

What is the latest error?

[Bledi]

i'm having the same probleme and don't know what to do can u please give us more info whre to check or what to edit please

[Steve Machol]

If you are getting the same error, then it has the same cause. The source db info you are using is wrong.

Unfortunately I have no way of knowing for sure what the correct info is, but in my experience almost all phpBB databases use a table prefix, specifically: phpbb_

Try that.

[macara]

Thanks lot.

Here is the solution:

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

Best Regards