[SMF Converter] PHP-Fusion 7

[Norv]

For member logins, please, try using the package found in this thread's first post: the login fix. It is a mod and should be installed on the forum (using an admin account). You might need to reset the password of the admin account, though, unless you could install the mod before conversion.

[dantekun94]

Dude, first: I wanna thank you for the conversion script.
Second: I have a problem... i mean, two problems.
1. I can't login, even if I instaled phpfusion_login_fix.tgz before conversion.
2. Website doesn't send password reset email -.- i dont know what to do...

Can you help me?
Pleaseeee.... I really need this conversion

[luuuciano]

Try using a md5 generator (search for it), then replace the password value using phpmyadmin or something similar

Ask your hosting provider why php sendmail do not work

[Imutep]

Hello together,
sorry for open an old thread but i've a big problem with converting my php-fusion 7.01.06 to SMF 2.0.2.
It show me this after converting...

Code Select Expand

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting attachments...
Warning: copy(/www/htdocs/w0088335/studio/ams/forum/attachments/ams_02.jpg) [function.copy]: failed to open stream: No such file or directory in /www/htdocs/w0088335/studio/ams/forums/convert.php(1254) : eval()'d code on line 13

Warning: copy(/www/htdocs/w0088335/studio/ams/forum/attachments/ams_03.jpg) [function.copy]: failed to open stream: No such file or directory in /www/htdocs/w0088335/studio/ams/forums/convert.php(1254) : eval()'d code on line 13

Warning: copy(/www/htdocs/w0088335/studio/ams/forum/attachments/bulletcam2.zip) [function.copy]: failed to open stream: No such file or directory in /www/htdocs/w0088335/studio/ams/forums/convert.php(1254) : eval()'d code on line 13

Warning: copy(/www/htdocs/w0088335/studio/ams/forum/attachments/mission.png) [function.copy]: failed to open stream: No such file or directory in /www/htdocs/w0088335/studio/ams/forums/convert.php(1254) : eval()'d code on line 13

Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /www/htdocs/w0088335/studio/ams/forums/Sources/Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: id_attach

I also tryied it with changing the Subs-Db-mysql (example from N.N.), but no chance.

And it show me no post counts and posts/threads.
Some help would be great 

[Gold1s]

Hi.
I have error during convert.

Code Select Expand

Converting members...
Unsuccessful!
This query:

    SELECT
    user_id AS id_member, SUBSTRING(user_name, 1, 80) AS member_name,
    user_joined AS date_registered, user_posts AS posts, SUBSTRING(user_password, 1, 64) AS passwd,
    SUBSTRING(user_web, 1, 255) AS website_title,
    SUBSTRING(user_web, 1, 255) AS website_url, user_lastvisit AS last_login,
    user_birthdate AS birthdate, SUBSTRING(user_icq , 1, 255) AS icq,
    SUBSTRING(user_name, 1, 255) AS real_name,
    '' AS notify_once, '' AS lngfile,
    SUBSTRING(user_email, 1, 255) AS email_address,
    SUBSTRING(user_aim, 1, 16) AS aim,
    '' AS personal_text,
    user_hide_email AS hide_email, SUBSTRING(user_ip , 1, 255) AS member_ip,
    SUBSTRING(user_ip , 1, 255) AS member_ip2,
    SUBSTRING(user_yahoo, 1, 32) AS yim, '' AS gender,
    SUBSTRING(user_msn, 1, 255) AS msn,
    SUBSTRING(REPLACE(user_sig, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(user_location, 1, 255) AS location, user_offset AS time_offset,
    SUBSTRING(user_avatar, 1, 255) AS avatar,
    '' AS usertitle, '' AS pm_email_notify, '' AS karma_bad, '' AS karma_good,
    '' AS notify_announcements, '' AS secret_question, '' AS secret_answer,
    IF(user_level = 103, 1, 0) AS id_group, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS message_labels, '' AS validation_code, user_groups AS additional_groups,
    '' AS smiley_set, '' AS password_salt
    FROM `seven`.fusion_users
    LIMIT 0, 500;

Caused the error:

    Unknown column 'user_web' in 'field list'and when I delete from convert.php this lines:

Code Select Expand

SUBSTRING(user_web, 1, 255) AS website_title,
SUBSTRING(user_web, 1, 255) AS website_url, user_lastvisit AS last_login,i have next error:

Code Select Expand

Converting members...
Unsuccessful!
This query:

    SELECT
    user_id AS id_member, SUBSTRING(user_name, 1, 80) AS member_name,
    user_joined AS date_registered, user_posts AS posts, SUBSTRING(user_password, 1, 64) AS passwd,
    user_birthdate AS birthdate, SUBSTRING(user_icq , 1, 255) AS icq,
    SUBSTRING(user_name, 1, 255) AS real_name,
    '' AS lngfile,
    SUBSTRING(user_email, 1, 255) AS email_address,
    SUBSTRING(user_aim, 1, 16) AS aim,
    '' AS personal_text,
    user_hide_email AS hide_email, SUBSTRING(user_ip , 1, 255) AS member_ip,
    SUBSTRING(user_ip , 1, 255) AS member_ip2,
    SUBSTRING(user_yahoo, 1, 32) AS yim, 0 AS gender,
    SUBSTRING(user_msn, 1, 255) AS msn,
    SUBSTRING(REPLACE(user_sig, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(user_location, 1, 255) AS location, user_offset AS time_offset,
    SUBSTRING(user_avatar, 1, 255) AS avatar,
    '' AS usertitle, 0 AS pm_email_notify, 0 AS karma_bad, 0 AS karma_good,
    0 AS notify_announcements, '' AS secret_question, '' AS secret_answer,
    IF(user_level = 103, 1, 0) AS id_group, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS message_labels, '' AS validation_code, user_groups AS additional_groups,
    '' AS smiley_set, '' AS password_salt
    FROM `seven`.fusion_users
    LIMIT 0, 500;

Caused the error:

    Unknown column 'user_icq' in 'field list'then I delete this line:

Code Select Expand

user_birthdate AS birthdate, SUBSTRING(user_icq , 1, 255) AS icq,after it i have this error:

Code Select Expand

Converting members...
Unsuccessful!
This query:

    SELECT
    user_id AS id_member, SUBSTRING(user_name, 1, 80) AS member_name,
    user_joined AS date_registered, user_posts AS posts, SUBSTRING(user_password, 1, 64) AS passwd,
    SUBSTRING(user_name, 1, 255) AS real_name,
    '' AS lngfile,
    SUBSTRING(user_email, 1, 255) AS email_address,
    SUBSTRING(user_aim, 1, 16) AS aim,
    '' AS personal_text,
    user_hide_email AS hide_email, SUBSTRING(user_ip , 1, 255) AS member_ip,
    SUBSTRING(user_ip , 1, 255) AS member_ip2,
    SUBSTRING(user_yahoo, 1, 32) AS yim, 0 AS gender,
    SUBSTRING(user_msn, 1, 255) AS msn,
    SUBSTRING(REPLACE(user_sig, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(user_location, 1, 255) AS location, user_offset AS time_offset,
    SUBSTRING(user_avatar, 1, 255) AS avatar,
    '' AS usertitle, 0 AS pm_email_notify, 0 AS karma_bad, 0 AS karma_good,
    0 AS notify_announcements, '' AS secret_question, '' AS secret_answer,
    IF(user_level = 103, 1, 0) AS id_group, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS message_labels, '' AS validation_code, user_groups AS additional_groups,
    '' AS smiley_set, '' AS password_salt
    FROM `seven`.fusion_users
    LIMIT 0, 500;

Caused the error:

    Unknown column 'user_aim' in 'field list'and i delete this line:

Code Select Expand

SUBSTRING(user_aim, 1, 16) AS aim,after it i have this error:

Code Select Expand

Converting members...
Unsuccessful!
This query:

    SELECT
    user_id AS id_member, SUBSTRING(user_name, 1, 80) AS member_name,
    user_joined AS date_registered, user_posts AS posts, SUBSTRING(user_password, 1, 64) AS passwd,
    SUBSTRING(user_name, 1, 255) AS real_name,
    '' AS lngfile,
    SUBSTRING(user_email, 1, 255) AS email_address,
    '' AS personal_text,
    user_hide_email AS hide_email, SUBSTRING(user_ip , 1, 255) AS member_ip,
    SUBSTRING(user_ip , 1, 255) AS member_ip2,
    SUBSTRING(user_yahoo, 1, 32) AS yim, 0 AS gender,
    SUBSTRING(user_msn, 1, 255) AS msn,
    SUBSTRING(REPLACE(user_sig, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(user_location, 1, 255) AS location, user_offset AS time_offset,
    SUBSTRING(user_avatar, 1, 255) AS avatar,
    '' AS usertitle, 0 AS pm_email_notify, 0 AS karma_bad, 0 AS karma_good,
    0 AS notify_announcements, '' AS secret_question, '' AS secret_answer,
    IF(user_level = 103, 1, 0) AS id_group, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS message_labels, '' AS validation_code, user_groups AS additional_groups,
    '' AS smiley_set, '' AS password_salt
    FROM `seven`.fusion_users
    LIMIT 0, 500;

Caused the error:

    Unknown column 'user_yahoo' in 'field list'and i delete this line:

Code Select Expand

SUBSTRING(user_yahoo, 1, 32) AS yim, 0 AS gender,and i see next error:

Code Select Expand

Converting members...
Unsuccessful!
This query:

    SELECT
    user_id AS id_member, SUBSTRING(user_name, 1, 80) AS member_name,
    user_joined AS date_registered, user_posts AS posts, SUBSTRING(user_password, 1, 64) AS passwd,
    SUBSTRING(user_name, 1, 255) AS real_name,
    '' AS lngfile,
    SUBSTRING(user_email, 1, 255) AS email_address,
    '' AS personal_text,
    user_hide_email AS hide_email, SUBSTRING(user_ip , 1, 255) AS member_ip,
    SUBSTRING(user_ip , 1, 255) AS member_ip2,
    SUBSTRING(user_msn, 1, 255) AS msn,
    SUBSTRING(REPLACE(user_sig, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(user_location, 1, 255) AS location, user_offset AS time_offset,
    SUBSTRING(user_avatar, 1, 255) AS avatar,
    '' AS usertitle, 0 AS pm_email_notify, 0 AS karma_bad, 0 AS karma_good,
    0 AS notify_announcements, '' AS secret_question, '' AS secret_answer,
    IF(user_level = 103, 1, 0) AS id_group, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS message_labels, '' AS validation_code, user_groups AS additional_groups,
    '' AS smiley_set, '' AS password_salt
    FROM `seven`.fusion_users
    LIMIT 0, 500;

Caused the error:

    Unknown column 'user_msn' in 'field list'after this i delete this line:

Code Select Expand

SUBSTRING(user_msn, 1, 255) AS msn, and i was see this error:

Code Select Expand

Converting members...
Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Duplicate entry '0-37' for key 'last_message'
Someone could help me?
I have phpfusion 7, and SMF 2.0, converter from this topic.
Greetz.

[Gold1s]

Bump.
Some1 know, where is a problem?

[ThorstenE]

Gold1s,
can you attach your modified version of phpfusion7_to_smf.sql, please? I'll take a look...

[Gold1s]

Here is it.
Greetings.

[ThorstenE]

please try the attached version..

[Gold1s]

Hi.
Thanx for reply.
Posts now are converted, but attachments nope :/, I have this error now:

Code Select Expand

Converting...
Converting posts (this may take some time)...
Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting attachments...
Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/imgp1357.gif) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/mml-punch-full-72-rgb_400.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/69d067cb0028225048e1d7cd.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/imgp1494.gif) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/big_1r429d.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/25fca1c3becbcd63.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/21e6dc5aeaa0e832.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/imgp1768.gif) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/_masters_of_dirt_1.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/bartphone176.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/imgp1871.gif) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/799617_20071001041014_3.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/799617_20070919050905_2.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/799617_20070919050905_3.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/799617_20070919050906_5.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/aci.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/imgp2022.gif) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/imgp2101.gif) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/p1000363.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/p1000366.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: copy(E:\XAMPP\xampp\htdocs\seven/forum/attachments/p1000367.jpg) [function.copy]: failed to open stream: No such file or directory in E:\XAMPP\xampp\htdocs\smf7\convert.php(1244) : eval()'d code on line 13

Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in E:\XAMPP\xampp\htdocs\smf7\Sources\Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: id_attach
Help me please.
Greetz.

[ThorstenE]

The attachment files  seem to be missing...(or the path to attachments is wrong).. Can you please check if this file exists?
E:\XAMPP\xampp\htdocs\seven/forum/attachments/imgp1357.gif

[Gold1s]

Nope, I don't have it :/.
Hm, I don't know why.
Can I delete this attachment from database?
Or something?
Greetz.

[ThorstenE]

No problem, the attached version checks, if a file exists before trying to insert.. Hope it works.

[Gold1s]

Hi.
Thanx for reply.
Now I have this error:

Code Select Expand

Converting personal messages (step 1)...
Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting attachments...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in E:\XAMPP\xampp\htdocs\smf7\Sources\Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: id_attach
Could u help me?
Please, thanx.
Greetz.

[ThorstenE]

ok, please try the attached version. hopefully that one works as expected..

[Gold1s]

Thanx for reply, but now I have this error:

Code Select Expand

Converting...
Converting attachments...
Successful.
Converting membergroups... Successful.
Recalculating forum statistics...
Warning: mysql_fetch_assoc(): 25 is not a valid MySQL result resource in E:\XAMPP\xampp\htdocs\smf7\convert.php on line 1448

Warning: mysql_free_result(): 25 is not a valid MySQL result resource in E:\XAMPP\xampp\htdocs\smf7\convert.php on line 1472
Table 'smfx.fusion_settings' doesn't exist
Could u help me?
Thanx bro.

[ThorstenE]

odd, your convert.php seems to be different, maybe I've used an older version.... Can you please rerun the converter with the attached version of convert.php?

[Gold1s]

Now, when I click Continue I have this error:

Code Select Expand

Fatal error: Call to undefined function loadFile() in E:\XAMPP\xampp\htdocs\smf7\convert.php on line 330

[ThorstenE]

huhh, that's a bug in the recent SVN version .. Sorry, try this one instead ..

[ChandlerBing]

Hi!

When I try using this converter i get:

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Duplicate entry '1013' for key 'PRIMARY'