Simple Machines Community Forum

Software: PHP-Fusion
Version: 6.x

This is the official support topic for PHP-Fusion converter.  Use this topic to ask for support for this converter.

Changelog
! Improve regex when working with multiple quotes and fix styling.

Password Support
To be able to login again after you complete the conversion, You will simply need to apply the phpfusion6_login_fix.tgz modification (attached below) via Package Manager (http://docs.simplemachines.org/index.php?board=49.0).

convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.

i did everthig this topic said http://docs.simplemachines.org/index.php?topic=15 went to www.yoursite.com/forums/convert.php. all i get is a white page.

reupload files worked

Hi, are there any step by step instructions on this? Also, this may be a silly question but... when I convert what is actually transferred? ALL members of my community (including those who've never posted on the forum), PMs and forums/threads/posts?

If someone could answer these questions I'd really appreciate it.

- BD

Yes we try to get at least the core data (that is members and posts [which inlcude topics]).
The converter will not modify any data in your old forum, so if you want to install SMF and run a conversion, things will still operate on your old forum while you look at what you have now on your new SMF forum  :)

Oh thank you! I ran the conversion and it seems everything went smooth, however I can not log in. I see that it says I need to install something though the "Package Manager" but I am VERY confused. I went to the link and do not know exactly what I'm supposed to do.

first of all you should reset your admin password.
- use the "forgotten" password link from SMF
- or if this doesn't work use PHPMyAdmin and execute the following sql query:

UPDATE smf_members SET passwd = 'test' WHERE memberName ='username';

change smf_ to your database prefix and username to your admins name

then download the phpfusion6_login_fix.tgz (http://www.simplemachines.org/community/index.php?action=dlattach;topic=242961.0;attach=57789)

go to Admin - Packages - Download Packages - then upload your package and click "Apply Mod", then "install now"

Thank you, It worked! I am amazed at how smooth this conversion went. Keep up the great work!

I installed this board as a test only. I am not planning to actually change from PHP Fusion to SMF for at least another month or two. When I am ready to officially convert, can I run convert.php again (on the current installation) to get the latest members, topics etc. or do I have to start over from scratch? I'm just wondering as I'd like to install a few mods right now.

yes, you can run it again..

sorry but what do this convert.php?

convert all php fusion o only the forum.

i want to use the forum (smf) with the same user databese of php fusion.
thanks and sorry for my english. :)

http://docs.simplemachines.org/index.php?board=4.0

Perhaps that may help?

I have separate databases for SMF and Fusion...my host wont seem to allow me to create a db user (in the fusion db) to match the SMF password.

Is there a way to specify both accounts? (i.e: x = smf user, y= php-fusion user)?

sorry, but this is not possible.. but you can install SMF in the same database like PHP-Fusion, SMF uses its own table prefix and leave the PHP-Fusion installation untouched...

This is very helpful, thanks.

Quote from: TE on January 19, 2009, 12:48:55 PM
sorry, but this is not possible.. but you can install SMF in the same database like PHP-Fusion, SMF uses its own table prefix and leave the PHP-Fusion installation untouched...

Thanks..That is what I wound up doing (was hesitant because the fusion db is "in production", so I didn't really want to mess with it..but all seems to be working well.)

Thanks for the quick reply

I cannot complete the conversion to to this error: 

Converting posts (this may take some time)... Unsuccessful!
This query:

(bunch of stuff)...then

Caused the error:

    Got a packet bigger than 'max_allowed_packet' bytes

TRY AGAIN button (but that doesn't resolve it..))  just stuck... suggestions? 

that's an error from your MySQL Server .. (too much data is send to the MySQL Server)

open the phpfusion_to_smf.sql and find:

---* {$to_prefix}messages 200

replace the 200 with 100 (or 50 if 100 will not work). this will reduce the concurrent converted posts from 200 to a lower size.

You're a genious...worked perfectly.

Now, the problem is...I can't log in. The SMF 'admin' user account i made does not exisit...so I can't get to the administrator side.  I did a 'forgot' password but 'admin' was not found.

did the (( UPDATE smf_members SET passwd = 'test' WHERE memberName ='username'; )) query in the database, but it pulled up nothing.

So, can't reset it..or do much now :(   suggestions?  ((and i am not savy on backend server stuff, i am surprised i made it this far))

all old SMF accounts were deleted during the conversion, but your php-fusion users are now in the database. the "forgotten password" link from SMF may help.

you can also reset your password with:
UPDATE smf_members SET passwd = 'test' WHERE memberName ='myoldphpfusionadmin';

after you can login again -> check the first post in this topic.

QuotePassword Support
To be able to login again after you complete the conversion, You will simply need to apply the phpfusion6_login_fix.tgz modification (attached below) via Package Manager.

it says it doesn't exist...and SMF 'forget' password says member not found...

SQL query:

UPDATE smf_members SET passwd = 'test' WHERE memberName = 'Luxa'

MySQL said: Documentation
#1146 - Table 'bmwmwjza_jo151.smf_members' doesn't exist

***moans.. I am so lost :(

OK OK WORKED...

Thank you Thank you for your support

Sav

:) Welcome to SMF.

Okies, I'm back...just when you thought you got enough of me.  I cannot 'Apply Mod' to get the "phpfusion6_login_fix.tgz" to install.  The package is there, but when i go to Apply Mod it takes me the FTP screen which reads:

Some of the files the package manager needs to modify are not writable. This needs to be changed by logging into FTP and using it to chmod or create the files and folders. Your FTP information may be temporarily cached for proper operation of the package manager.

So i enter the 'password' but then I get the message:

An Error Has Occurred!
Session verification failed. Please try logging out and back in again, and then try again

Grrrrr   Suggestions on what I am doing wrong?

change the file permissions from the file Sources/LoginOut.php to CHMOD 777.
How do I chmod? / what is chmod? (http://docs.simplemachines.org/index.php?topic=477)

the Session verification:
SMF 1.1.7: Session verification failed error when installing mods (http://www.simplemachines.org/community/index.php?topic=278824.0)

I love you, marry me :P

  Again...THANK YOU

Ran the conversion yesterday..

For the most part, everything looks great.

One issue is with the private messages that were moved over. In a users inbox, they see ALL of their messages (including ones that should be in the outbox)

messages they SENT, are displaying as being FROM the person they sent it to.

Not sure if that's clear... For example:

If I sent you a message on the old site, after the conversion it shows that message as being sent by you (instead of to you)

Any thoughts?

checked the converter-file (attached to this topic) and it looks ok for me:

for the PM-Inbox: pm.message_from AS ID_MEMBER_FROM

for the PM-Outbox:  message_to AS ID_MEMBER

Which version from php-fusion are you converting? maybe you used an older converter file? (you should use the file attached to the first post from this topic).

Hello, is it possible to modify this converter to converted of SMF2 to PHP Fusion 6.X? Over the past very much.

you meant from PHP-Fusion 6.x to SMF 2.0? Sorry, but our converters for SMF 2.0 are still in developement and not released yet.. You can convert your PHP-Fusion to SMF 1.1.9, then upgrage your Forum to 2.0
Upgrade SMF (http://docs.simplemachines.org/index.php?board=3.0;sort=subject)

Quote from: TE on June 20, 2009, 12:54:40 PM
you meant from PHP-Fusion 6.x to SMF 2.0? Sorry, but our converters for SMF 2.0 are still in developement and not released yet.. You can convert your PHP-Fusion to SMF 1.1.9, then upgrage your Forum to 2.0
Upgrade SMF (http://docs.simplemachines.org/index.php?board=3.0;sort=subject)

   
thanks, I already guessed himself, converted to make ok  :D

NEW Problem:  I created a new forum a while back all working, but site owner wiped it all out accidentally *sighs*

So now I am reinstalling everything .. all looks good till i get this:

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
.
.
Caused the error:
         Duplicate entry '0-124' for key 2

I can't find anything in here that is relevant, found some help topics close, but way over my head.  Anyone know what I can do to fix this?

in phpfusion6_to_smf.sql find
---* {$to_prefix}topics
---{
add after:
$ignore = true;

then re-start the conversion please.

Converting topics... Unsuccessful!

Still getting the message...this is how my sql looks:

TRUNCATE {$to_prefix}topics;
TRUNCATE {$to_prefix}log_topics;
TRUNCATE {$to_prefix}log_boards;
TRUNCATE {$to_prefix}log_mark_read;

---* {$to_prefix}topics
---{$ignore = true;

$ignore = true; needs to be on a new line..

Splendid....that worked...but what do you think this means?
ALSO: on SMF, only the topics posted...zero threads/posts...not sure what happened.

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...
Fatal error: Call to undefined function getLegacyAttachmentFilename() in /home/uzbcmapp/public_html/joomla/convert.php(1097) : eval()'d code on line 9

===modified post===

Ok so I downloaded a new *convert.php *  and now this is what I am getting...I have yet to find similar from other posts:

Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1251404433),
    ("conversion_from", "phpfusion6_to_smf.sql");

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1251404433)' at line 1

You can ignore the last error (minor bug in convert.php and already fixed in our SVN).

QuoteRecalculating forum statistics... Successful.

this was the last important step from convert.php, your forum was hopefully successful converted.

when I try to install the fix I get an error:
The package you tried to upload Either is not a valid package or has Become corrupted.


I converting PHP-Fusion 6.01.6 to SMF 1.1.11

Any solution?

Odd. It works fine for me.

There's not much to it though, you can modify the file /Sources/LogInOut.php manually:

find this

// Maybe they are using a hash from before the password fix.


add before

// php-fusuion 6.x Login Method?
        $other_passwords[] = md5(md5($_REQUEST['passwrd']));


How do I modify files? (http://www.simplemachines.org/community/index.php?topic=24110.0)

Thanks ;)
Manual installation worked :)

You're welcome :)

Hi, when i try to convert my phpf 6 to smf 4 i get this:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg337.imageshack.us%2Fimg337%2F7643%2Ferrorem0.jpg&hash=398eefe097a6edf9335e360f8d40dc767740331e)

When i open my web page it looks like all is converted, but when i click to view member profile or open some topic i get this error:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg227.imageshack.us%2Fimg227%2F7667%2Ferror2he.jpg&hash=09c18f95801cba85a9185b3b485024c7800d730a)

How could i fix it?

there are two bugs in convert.php:
Bug1:
find
if (!isset($indexes['ipIndex']))

replace with:
if (!isset($indexes['ip_index']))

Bug2:
find:
if (!isset($indexes['showPosts']))
$smcFunc['db_add_index']($to_prefix . 'messages', array(
'type' => 'INDEX', // no key
'name' => 'show_posts',
'columns' => array('id_member', 'id_member')),
            
replace with:
if (!isset($indexes['show_posts']))
$smcFunc['db_add_index']($to_prefix . 'messages', array(
'type' => 'INDEX', // no key
'name' => 'show_posts',
'columns' => array('id_member', 'id_board')),

First problem is fixed.

But the second one not fixed
When i open my web page it looks like all is converted, but when i click to view member profile or open some topic i get this error:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg227.imageshack.us%2Fimg227%2F7667%2Ferror2he.jpg&hash=09c18f95801cba85a9185b3b485024c7800d730a)

How could i fix it?

can you login to the admin panel and check the smf error log? there should be at least one error related to the database.

i fixed that error by my self, thats because of skype integration mod...

but now i cant login, i tried the phpfusion login fix, but it doesnt work

AFAIK the php-fusion passwords are doubled md5();, so you don't need the login fix (SMF 2.0 can read these type of passwords by default). Maybe there was a typo? Both username and password are case sensitive.
I accidentally deleted my admin account, what do I do? (http://docs.simplemachines.org/index.php?topic=466.0)

i dont get how to repair login bug, i have an 800 members, but they cant login

the link that you gave me is not useful

To be honest I have no clue about the reason. Is it 2.0 RC4 or an earlier version of SMF 2.0? there was a bug related to the login in pre RC4 versions.

Edit: http://dev.simplemachines.org/mantis/view.php?id=4365

what if i would try the previous smf version? for example rc2 or rc3?
the bug is still exists?

where shuold i put the converted_boards.patch file?

Quote from: ixas on December 02, 2010, 02:47:12 PM
what if i would try the previous smf version? for example rc2 or rc3?

the bug is in RC2 and RC3 and all former versions but should be fixed in RC4.
the diff can be applied with a special software like windiff or "diff" on a linux shell, you can't install it via package manager.
you could manually modify the file Sources/LogInOut.php
find:
updateMemberData($user_settings['id_member'], array('passwd' => $user_settings['passwd'], 'password_salt' => $user_settings['password_salt']));
replace it with:
updateMemberData($user_settings['id_member'], array('passwd' => $user_settings['passwd'], 'password_salt' => $user_settings['password_salt'], 'passwd_flood' => ''));
maybe php-fusion changed their password encryption?!?! can you create a test user in php-fusion with a password "test", then go to phpmyadmin (table users from your php-fusion installation) and verify the password from column: user_password

it should exactly match to: fb469d7ef430b0baf0cab6c436e70375   ==> ( md5(md5('test'));

i created an acount with name test and password testtest

and i get: ddf63c1a8f2492aa4e41b34e93a9d54e

yep, this is exactly md5(md5('testtest'));

this is a code fragment from Sources/LogInOut.php
// Some common md5 ones.
$other_passwords[] = md5($user_settings['password_salt'] . $_POST['passwrd']);
$other_passwords[] = md5($_POST['passwrd'] . $user_settings['password_salt']);
$other_passwords[] = md5($_POST['passwrd']);
$other_passwords[] = md5(md5($_POST['passwrd']));
threrefore your SMF should read the old passwords..  Can you please try it with a different browser?

Quote from: SleePy on June 04, 2008, 11:57:39 PM
Password Support
To be able to login again after you complete the conversion, You will simply need to apply the phpfusion6_login_fix.tgz modification (attached below) via Package Manager (http://docs.simplemachines.org/index.php?board=49.0).

i got a question about that
What if i got PHP-Fusion converted to SMF RC3, all works, and now i want to upgrade to RC4 - i need to again install this fix ?

password support for php-fusion is IMO build-in in SMF 2.0 series..

so, i tried to convert PHP-Fusion v6.01.6 to SMF RC4, but i get this error:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg408.imageshack.us%2Fimg408%2F1075%2Fcapturekcn.png&hash=ab43aca203860c32b8dec81cd76ef9abdd4fdda0)

Thjere is:

QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.

but topics, posts and users are not converted...
any solution ?

I downloaded converter from http://download.simplemachines.org/?converters;software=phpfusion

adi1166,
in phpfusion6_to_smf.sql find:
TRUNCATE {$to_prefix}moderators;

---* {$to_prefix}moderators 25
---{
$no_add = true;
add after:
$ignore = true;

then restart the converter.

still the same error

and i got the same problem like ixas - can't login using data from PHP-Fusion site...

ok, you're right..
moderators:
I'd simply remove the entire moderators block from the converter:

/******************************************************************************/
--- Converting moderators...
/******************************************************************************/

TRUNCATE {$to_prefix}moderators;

---* {$to_prefix}moderators 25
---{
$no_add = true;
$keys = array('id_board', 'id_member');

// All moderators are held in a period seperated array.
$moderators = explode('.', $row['forum_moderators']);

// Do a loop and get them corrected for inserting
foreach ($moderators AS $mod)
$row[] = "{$row['id_board']}, {$mod}";
---}
SELECT forum_id AS id_board, forum_moderators
FROM {$from_prefix}forums;
---*
IMO this part is useless because in php-fusion moderators are membergroups whereas in SMF they are unique members.

the passwords bug: there is a bug in Sources/LogInOut.php (made a bug report a few minutes ago (http://dev.simplemachines.org/mantis/view.php?id=4584))
in Sources/LogInOut.php find:
elseif (strlen($user_settings['passwd']) == 32)
replace it with:
if (strlen($user_settings['passwd']) == 32)
after changing this line old passwords should work..

I have made a conversion from PHP-fusion 6 to SMF 2 RC4
I removed the moderator part, as mentioned earlier in this thread.
The attachments reported successful, but there are no attachments in SMF.
Avatars couldn't be shown, but I just moved the folder from Fusion to SMF and they are working now.

Attachment aren't even showing, avatars were but just not moved.

Any ideas?
The attachments of the Fusion is not raw files, dont know what they are.
File names in the attacment folder are  "1_0a90b45f8ecf25d674fb55c4f3b8cde22a1d42cf" but the paths are "/forum/attachments/c1.jpg"

PHP-Fusion: jacoer.blomberg.it/fusion
SMF: jacoer.dk

thomasdk81,
please try the attached version....

Quote from: TE on January 07, 2011, 10:25:58 AM
thomasdk81,
please try the attached version....

Thank you for the reply.
I removed all the sections but the attachments because the forum is active and new posts and users shouldn't be deleted.

When I run the converter with the sql you attached I get this:
Warning: set_time_limit(): Cannot set time limit due to system policy in /customers/jacoer.dk/jacoer.dk/httpd.www/convert.php on line 29
PHPFusion 6.0.x to SMF Converter
Converting...
Converting attachments... Fatal error: Call to undefined function getAttachmentFilename() in /customers/jacoer.dk/jacoer.dk/httpd.www/convert.php(1109) : eval()'d code on line 2

ok, maybe your convert.php is an older version.. please use the attached one..

Hi, sorry for my late respons.

When I run the script I get:
Converting attachments... Unsuccessful!
This query:

    TRUNCATE `jacoer_dk`.smf_attachments
    LIMIT 0, 500;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 500' at line 2

can you attach your modified phpfusion6_to_smf.sql IIRC your version covers only attachments, right?

Sure :)
I dont touch the convert.php, but i'll attacht it to be sure.

find:
---*
/******************************************************************************/
--- Converting attachments...
/******************************************************************************/
replace with:
/******************************************************************************/
--- Converting attachments...
/******************************************************************************/

---* above the section header is the problem.

Wow... thats just stupid of me :D

It worked!! thank you so much  ;D :laugh: