Advertisement:

Author Topic: [SMF Converter] PHP-Fusion 6.x  (Read 53978 times)

Offline ixas

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #40 on: December 01, 2010, 01:03:47 PM »
Hi, when i try to convert my phpf 6 to smf 4 i get this:


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:


How could i fix it?
« Last Edit: December 01, 2010, 01:18:02 PM by ixas »

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #41 on: December 01, 2010, 02:19:03 PM »
there are two bugs in convert.php:
Bug1:
find
Code: [Select]
if (!isset($indexes['ipIndex']))
replace with:
Code: [Select]
if (!isset($indexes['ip_index']))
Bug2:
find:
Code: [Select]
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:
Code: [Select]
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')),
« Last Edit: December 01, 2010, 03:04:23 PM by TE »

Offline ixas

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #42 on: December 02, 2010, 12:00:27 PM »
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:


How could i fix it?

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #43 on: December 02, 2010, 12:11:58 PM »
can you login to the admin panel and check the smf error log? there should be at least one error related to the database.

Offline ixas

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #44 on: December 02, 2010, 12:27:46 PM »
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

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #45 on: December 02, 2010, 12:59:20 PM »
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?

Offline ixas

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #46 on: December 02, 2010, 02:01:59 PM »
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

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #47 on: December 02, 2010, 02:08:23 PM »
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

Offline ixas

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #48 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 still exists?

where shuold i put the converted_boards.patch file?

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #49 on: December 02, 2010, 03:15:03 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:
Code: [Select]
updateMemberData($user_settings['id_member'], array('passwd' => $user_settings['passwd'], 'password_salt' => $user_settings['password_salt']));replace it with:
Code: [Select]
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'));

Offline ixas

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #50 on: December 03, 2010, 08:33:40 AM »
i created an acount with name test and password testtest

and i get: ddf63c1a8f2492aa4e41b34e93a9d54e

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #51 on: December 03, 2010, 01:41:10 PM »
yep, this is exactly md5(md5('testtest'));

this is a code fragment from Sources/LogInOut.php
Code: [Select]
// 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?

Offline phantomm

  • Sophist Member
  • *****
  • Posts: 1,063
  • Gender: Male
    • pages/smfpl/171860759503032 on Facebook
    • Polish ElkArte community
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #52 on: December 29, 2010, 04:35:00 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.


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 ?
Polskie wsparcie SMF na simplemachines.org

My mods

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #53 on: December 30, 2010, 03:02:05 AM »
password support for php-fusion is IMO build-in in SMF 2.0 series..

Offline phantomm

  • Sophist Member
  • *****
  • Posts: 1,063
  • Gender: Male
    • pages/smfpl/171860759503032 on Facebook
    • Polish ElkArte community
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #54 on: December 31, 2010, 03:58:24 AM »
so, i tried to convert PHP-Fusion v6.01.6 to SMF RC4, but i get this error:


Thjere is:
Quote
Converting 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
« Last Edit: December 31, 2010, 04:01:43 AM by adi1166 »
Polskie wsparcie SMF na simplemachines.org

My mods

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #55 on: December 31, 2010, 06:36:52 AM »
adi1166,
in phpfusion6_to_smf.sql find:
Code: [Select]
TRUNCATE {$to_prefix}moderators;

---* {$to_prefix}moderators 25
---{
$no_add = true;
add after:
Code: [Select]
$ignore = true;
then restart the converter.

Offline phantomm

  • Sophist Member
  • *****
  • Posts: 1,063
  • Gender: Male
    • pages/smfpl/171860759503032 on Facebook
    • Polish ElkArte community
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #56 on: January 01, 2011, 11:17:56 AM »
still the same error

and i got the same problem like ixas - can't login using data from PHP-Fusion site...
« Last Edit: January 01, 2011, 11:46:30 AM by adi1166 »
Polskie wsparcie SMF na simplemachines.org

My mods

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #57 on: January 01, 2011, 05:25:10 PM »
ok, you're right..
moderators:
I'd simply remove the entire moderators block from the converter:
Code: [Select]
/******************************************************************************/
--- 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)
in Sources/LogInOut.php find:
Code: [Select]
elseif (strlen($user_settings['passwd']) == 32)replace it with:
Code: [Select]
if (strlen($user_settings['passwd']) == 32)after changing this line old passwords should work..

Offline thomasdk81

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #58 on: January 07, 2011, 05:26:01 AM »
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  "
Code: [Select]
1_0a90b45f8ecf25d674fb55c4f3b8cde22a1d42cf" but the paths are "
Code: [Select]
/forum/attachments/c1.jpg"

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

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #59 on: January 07, 2011, 10:25:58 AM »
thomasdk81,
please try the attached version....