Advertisement:

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

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,868
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
[SMF Converter] PHP-Fusion 6.x
« on: June 04, 2008, 11:57:39 PM »
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.

convert.php
Use this convert.php with the .sql file attached in this topic.
« Last Edit: July 18, 2009, 02:51:09 PM by TE »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline DOOM666

  • Semi-Newbie
  • *
  • Posts: 25
  • Gender: Male
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #1 on: June 09, 2008, 12:38:23 AM »
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
« Last Edit: June 09, 2008, 12:46:00 AM by DOOM666 »

Offline BumDiva

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #2 on: September 01, 2008, 12:00:50 AM »
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

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,868
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #3 on: September 02, 2008, 12:27:35 PM »
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  :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline BumDiva

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #4 on: September 03, 2008, 08:02:36 PM »
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.

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #5 on: September 04, 2008, 01:42:14 AM »
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:
Code: [Select]
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

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

Offline BumDiva

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #6 on: September 04, 2008, 03:20:03 AM »
Thank you, It worked! I am amazed at how smooth this conversion went. Keep up the great work!

Offline BumDiva

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #7 on: September 04, 2008, 02:22:59 PM »
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.

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #8 on: September 04, 2008, 03:20:57 PM »
yes, you can run it again..

Offline r35pect

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #9 on: October 20, 2008, 02:49:03 PM »
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. :)

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,868
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #10 on: October 23, 2008, 12:29:21 AM »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline lkj_tim

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #11 on: January 19, 2009, 12:30:41 PM »
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)?

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #12 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...

Offline Shadow~

  • Semi-Newbie
  • *
  • Posts: 10
  • Gender: Male
  • Dirty Commie
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #13 on: January 19, 2009, 12:58:16 PM »
This is very helpful, thanks.

Offline lkj_tim

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #14 on: January 19, 2009, 01:15:58 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

Offline Savinaa

  • Semi-Newbie
  • *
  • Posts: 14
Re: [SMF Converter] PHP-Fusion 6.x - Stuck with message "max_allowed_packet"
« Reply #15 on: January 22, 2009, 09:25:50 PM »
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? 

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #16 on: January 23, 2009, 01:37:47 AM »
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:

Code: [Select]
---* {$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.


Offline Savinaa

  • Semi-Newbie
  • *
  • Posts: 14
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #17 on: January 23, 2009, 11:22:21 AM »
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))

ThorstenE

  • Guest
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #18 on: January 23, 2009, 12:49:00 PM »
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:
Code: [Select]
UPDATE smf_members SET passwd = 'test' WHERE memberName ='myoldphpfusionadmin';
after you can login again -> check the first post in this topic.
Quote
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.

Offline Savinaa

  • Semi-Newbie
  • *
  • Posts: 14
Re: [SMF Converter] PHP-Fusion 6.x
« Reply #19 on: January 23, 2009, 01:40:26 PM »
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 :(