News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Converting from Ikonboard to SMF does not work

Started by Warlock666, February 13, 2019, 07:25:45 AM

Previous topic - Next topic

Warlock666

Hi @all,

I am trying to migrate a forum from Ikonboard 3.1.2a to SMF 2.0.15.

So after some trial and error with PHP 7.2 I set up an machine with Ubuntu 14.04 and PHP 5.5.9, set up a working SMF Forum, imported the Ikonboard database and copied this converter https://download.simplemachines.org/index.php?converters;id=26 into the documentroot.

After filling all the fields I start the converting process, but I stops right at the first step "Converting members...". There are no running queries in the MySQL Server und no apache2 processes consuming any CPU.

Does anyone have a hint for me ?

Bye, Dirk

vbgamer45

Community Suite for SMF - Grow your forum with SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com - Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Warlock666

Thanks a lot !

I tried the version from github, but same problem - freezes at "Converting members..."  :(

vbgamer45

In the url address bar added &debug=1
To the request and see if you get any feedback
Community Suite for SMF - Grow your forum with SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com - Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Warlock666

Yes, I got some on top of the page

"Notice: Undefined index: convert_script in /var/www/html/convert.php on line 52Notice: Function set_magic_quotes_runtime() is deprecated in /var/www/html/convert.php on line 55Notice: Undefined index: start in /var/www/html/convert.php on line 89Notice: Undefined index: path_from in /var/www/html/convert.php on line 103 "

In the page it said :

"Notice: Undefined index: substep in /var/www/html/convert.php on line 844Converting members...Wrong value type sent to the database. Floating point number expected. (time_offset)"





Warlock666

I can also offer you the convert_error_log file - is that helps ?

vbgamer45

Community Suite for SMF - Grow your forum with SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com - Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Warlock666

Now it's

Notice: Undefined index: convert_script in /var/www/html/convert.php on line 52Notice: Function set_magic_quotes_runtime() is deprecated in /var/www/html/convert.php on line 55Notice: Undefined index: start in /var/www/html/convert.php on line 89Notice: Undefined index: path_from in /var/www/html/convert.php on line 103
IkonBoard 3.1.x to SMF Converter

and

Notice: Undefined index: substep in /var/www/html/convert.php on line 844Converting members...Wrong value type sent to the database. Integer expected. (last_login)

vbgamer45

Community Suite for SMF - Grow your forum with SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com - Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Warlock666

This time it's

Notice: Undefined index: convert_script in /var/www/html/convert.php on line 52Notice: Function set_magic_quotes_runtime() is deprecated in /var/www/html/convert.php on line 55Notice: Undefined index: start in /var/www/html/convert.php on line 89Notice: Undefined index: path_from in /var/www/html/convert.php on line 103

and

Notice: Undefined index: substep in /var/www/html/convert.php on line 844Converting members...Wrong value type sent to the database. Integer expected. (gender)

vbgamer45

Community Suite for SMF - Grow your forum with SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com - Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Warlock666

Ok, by doing a diff between the original file and your latest file I think I managed to fix the "gender" and another problem by inserting :

$row['gender'] = (int) $row['gender'];
$row['hide_email'] = (int) $row['hide_email'];

Now it stops at "preparing messages":

Notice: Undefined index: convert_script in /var/www/html/convert.php on line 52Notice: Function set_magic_quotes_runtime() is deprecated in /var/www/html/convert.php on line 55

Notice: Undefined variable: result in /var/www/html/convert.php on line 2150Notice: Undefined variable: result in /var/www/html/convert.php on line 2151Notice: Undefined index: db_fetch_assoc in /var/www/html/convert.php on line 2341

Warlock666

Ok I'll try your new version and will report  :)

Warlock666

Notice: Undefined index: substep in /var/www/html/convert.php on line 844Converting members...Wrong value type sent to the database. Integer expected. (hide_email)

I could fix this by inserting

$row['hide_email'] = (int) $row['hide_email'];

But the problem with the messages remains, of course.

vbgamer45

Try that. Strange that those fields are not integers.
But i haven't seen that forum's databases before.
Community Suite for SMF - Grow your forum with SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com - Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Warlock666

Ok I put 'hide_email' in like this:

$row['last_login'] = (int) $row['last_login'];
$row['time_offset'] = (int) $row['time_offset'];
$row['hide_email'] = (int) $row['hide_email'];
$row['gender'] = substr(strtolower($row['gender']), 0,1);
if ($row['gender'] == 'm')
        $row['gender'] = 1;
else if ($row['gender'] == 'f')
        $row['gender'] = 2;
else
        $row['gender'] = 0;

Now it stops at "preparing messages":

Notice: Undefined index: convert_script in /var/www/html/convert.php on line 52Notice: Function set_magic_quotes_runtime() is deprecated in /var/www/html/convert.php on line 55

Notice: Undefined variable: result in /var/www/html/convert.php on line 2150Notice: Undefined variable: result in /var/www/html/convert.php on line 2151Notice: Undefined index: db_fetch_assoc in /var/www/html/convert.php on line 2341


vbgamer45

Community Suite for SMF - Grow your forum with SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com - Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Warlock666

Looks like a already had the one from github
At least the md5sum was the same between my file and the one I just downloaded from github  ( it's 3916e1d26548312410b6081bb377569a ).

Error stays the same

vbgamer45

Do you have tmp_messages table in your smf database

is your smf's boards table have records?
Same for smf_members table?
Community Suite for SMF - Grow your forum with SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com - Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Warlock666

Yes, I have a table called tmp_messages

smf_boards hat 51 records
smf_members hat 3938 records

Advertisement: