Unable to import from SMF 113

[Windsun]

Been at this for a few hours now..

On step 1 of import it gets part way through, looks like it imports about half or a little less. Then I get this (cut and pasted from the page):

... about 15 files here...
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.
board_permissions NOT found.
boards NOT found.
calendar NOT found.
calendar_holidays NOT found.
categories NOT found.....
etc.... About 15 more files are RED.


Impex config file for the data base to be imported:

$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'] = 'database_admin';
$impexconfig['source']['password'] = 'admin_password';
$impexconfig['source']['database'] = 'wind-s2_xmb2';
$impexconfig['source']['tableprefix'] = '';

Any ideas?

[Windsun]

Still can't get any further after another 24 hours.

I am wondering if Impex can even work with 1.13. It seems to get about half imported and then barfs.

[peterska2]

This usually means that your source database has a table prefix set and you have not set the table prefix in impexconfig.php

[Windsun]

I finally got it, it seems that the prefix had a trailing underscore _ that was not showing up because it happened to fall right on the line below it in display.

[Jerry]

I finally got it, it seems that the prefix had a trailing underscore _ that was not showing up because it happened to fall right on the line below it in display.

ImpEx should of suggested that on the first page during the table check ?