Simple Machines Community Forum

Software: PHP-Fusion
Version: 7.x

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

Changelog


Password Support
To be able to login again after you complete the conversion, You will simply need to apply the phpfusion_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.

А по русски всё это можно доступно объяснить как это всё сделать?

Quote from: JCDenton1 on May 21, 2009, 11:00:41 PM
А по русски всё это можно доступно объяснить как это всё сделать?

Translates roughly to:
Is there a Russian available who can help explain this?

JCDenton,
Вы можете найти дополнительную информацию в вашем языке поддержку.

hello, do not speak English (this is a google translation, sorry) and tried to use the converter does not work, always gives the error that let in the photos attached.
  help please.
thanks

this error is related to a missing column (user_aim).. please edit the phpfusion7_to_smf.sql

remove:
SUBSTRING(user_aim, 1, 16) AS AIM,

hello again, thanks for the help and it worked, but now the error has left it a few more errors, vai attached the photos, thanks and please help

the last error is a minor bug in convert.php and you can ignore this message (the conversion has finished successfully).

The "copy" errors are related to attachments.. two possible reasons:
- the files don't exist (e.g. old database entries still exists but the files are already deleted)
- the path to attachments wasn't properly detected. ( we could modify the converter file but I need to know the exact path from that missing files..)

You can check this via FTP, our converter expects this files in /public_html/files/forum/attachments/

Thanks friend, good job of supporting the forum is working well only lost a few minor little things.
Thanks

I'm sorry I'm a total newbie at this.

I have Php-Fusion with fusionboard4 installed on it.

This converter is used to change the fusionboard4 with losing my members right?

I dont exactly know what to do with the attached files. Please guide me? Thank you

This guide should help you: Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)

I'm getting this error whenever i want to convert my phpfusion7 to smf.

Caused the error:

    Unknown column 'memberName' in 'field list'

Kindly view attachment for the error_log.

Did you install SMF 2.0 by any chance?
Please note that the converter here is for the 1.1.x branch.

If you have SMF 2.0, then try using the attached files.

hello

i have a question does this converter convert php fusion complete or only its forum so it matches with php fusion??

so you have php fusion as frontpage and smf as forum??

thanks in advance

Floda

Hello there, and welcome to SMF! :)

The converter scripts converts the posts, members, topics from the phpfusion forum, to a SMF forum. It does not do anything with articles or whatever else phpfusion has, in addition to the forum.

You could have phpfusion as frontpage and SMF as forum, but only if you work on their code, to integrate them, otherwise they won't work together automatically. There is no bridge that I know of, for now.

An alternative might be to take a look at a portal mod for SMF, the SMF forum can have a frontpage and many other CMS-like features through the use of portal mods. ( http://custom.simplemachines.org/mods/index.php?action=search;type=17 )

Thanks for the quick reply ;)

i will have a look on it :D

hi, i used the converter u attached. but now i'm getting this error:

Recalculating forum statistics... Table 'merapune_merapu2.fusion_settings' doesn't exist

Please, try using the attached files instead.

its working now ! thanks for the help .. btw how to use the login fix ? is there login fix for phpfusion 7 ?

Please try adding this code to your_smf_directory/Sources/LogInOut.php :

// phpBB3 users new hashing.  We now support it as well ;).


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


UPDATE: it should work just fine for phpfusion 7 as well. Please make sure you empty your browser's cache and don't save passwords in the browser, and try logging in after this modification.

Does it import the users correctly if I have fusionboard4 installed?
You haven't answered it when a guy asked before.
If you don't know, can someone test it?
I can't because if it fails I'd probably lose all of my users, and I have MANY of them

Quote from: Mikolak on November 25, 2009, 01:37:41 PM
Does it import the users correctly if I have fusionboard4 installed?
You haven't answered it when a guy asked before.
If you don't know, can someone test it?
I can't because if it fails I'd probably lose all of my users, and I have MANY of them

If you run the conversion, nothing is lost. The converter only reads the phpfusion board database, it does nothing to modify it. It only modifies your newly installed SMF's database, inserting into it data from the other one.
Therefore, it can be run no matter how many times with no problem: the original database and forum installation are not modified at all.

Of course, like with any operation on databases, you should really take a backup of your database before starting it, regardless of other people successful or failed experiences.

Oh, yeah, of  course it doesn't make any changes to the database. Stupid me  ::)
Thanks for the quick reply

QuoteConverting 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 `ixas_ixas`.fusion_users
    LIMIT 0, 500;

Caused the error:

    Unknown column 'user_icq' in 'field list'

i get this error, what does it mean? and how i could fix it?

That's a quite unexpected error, it seems your phpfusion database doesn't have the field user_icq in the table fusion_users. On a fresh installation of phpfusion 7, I have this field.
Can you please tell what version of phpfusion you are converting from?

i fix that error, but i found another one

QuoteConverting members... Unsuccessful!
This query:

    INSERT INTO `ixas_ixas`.smf_members
    (ID_MEMBER, memberName, dateRegistered, posts, passwd, websiteTitle, websiteUrl, lastLogin, birthdate, realName, notifyOnce, lngfile, emailAddress, AIM, personalText, hideEmail, memberIP, memberIP2, gender, signature, location, timeOffset, avatar, usertitle, pm_email_notify, karmaBad, karmaGood, notifyAnnouncements, secretQuestion, secretAnswer, ID_GROUP, buddy_list, pm_ignore_list, messageLabels, validation_code, additionalGroups, smileySet, passwordSalt)
    VALUES ('1', 'iXas', '1242421759', '79', '85993ff9d1042325efd7aece023920c1', 'http://www.gerbejai.net', 'http://www.web.net', '1259359602', '1992-05-28', 'iXas', '', '', '[email protected]', '', '', '0', '78.61.105.41', '78.61.105.41', '', '', 'GargĆ¾dai', '0', 'av_1[1].png', '', '', '', '', '', '', '', '1', '', '', '', '', '8', '', ''),
    ('2', 'Zloj', '1242426065', '42', 'ea04ed23d27fef2fa76b243ed4a44ada1', 'http://www.gerbejai.net', 'http://www.gerbejai.net', '1257773668', '1988-12-24', 'Zloj', '', '', '[email protected]', 'lee_bronius', '', '1', '86.100.113.127', '86.100.113.127', '', '(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fcache.www.gametracker.com%2Fserver_info%2F79.98.30.171%3A27015%2Fb_560x95.png&hash=f2e48f92325be3b9629154b88fef667fc6900dc2) (http://www.gametracker.com/server_info/79.98.30.171:27015/)', 'Lietuva', '0', '', '', '', '', '', '', '', '', '1', '', '', '', '', '8', '', ''),
    ('114', 'kebabinis', '1250199026', '0', 'e4a8249d9a34693a8640f97fea12b54a', '', '', '1250245265', '1992-03-28', 'kebabinis', '', '', '[email protected]', 'donsiawaz', '', '1', '78.58.209.46', '78.58.209.46', '', '', 'Kunioniai', '0', '', '', '', '', '', '', '', '', '0', '', '', '', '', '8', '', ''),
    ('3', 'kQ-', '1242460905', '0', 'a8c669eb234702015ac57aea6144809a', '', '', '1243606891', '0000-00-00', 'kQ-', '', '', '[email protected]', '', '', '0', '78.59.118.196', '78.59.118.196', '', '', '', '0', '', '', '', '', '', '', '', '', '0', '', '', '', '', '8', '', ''),

...

Quote('498', 'danynas', '1256449793', '0', 'ff5725c33f8ecb83fa83d130e805093f', '', '', '1256450329', '0000-00-00', 'danynas', '', '', '[email protected]', '', '', '1', '77.87.8.25', '77.87.8.25', '', '', '', '0', '', '', '', '', '', '', '', '', '0', '', '', '', '', '8', '', ''),
    ('500', 'erlukas', '1256486392', '0', 'bb374aa2597ab8a1a0edeb77f1087fc8', '', '', '1256726113', '0000-00-00', 'erlukas', '', '', '[email protected]', '', '', '1', '85.232.128.51', '85.232.128.51', '', '', '', '0', '', '', '', '', '', '', '', '', '0', '', '', '', '', '8', '', '');

Caused the error:

    Unknown column 'memberName' in 'field list'

what's now?

It might be because you are using the converter to SMF 1.1.10, but you have installed SMF 2.0 RC2.
If that is the case, please try either installing the older SMF 1.1.10, if you wish to convert to 1.1.10, or, use the converter to SMF 2.0, which can be found in this site's Downloads > Converters.

now i get this

QuoteConverting 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... Successful.
Converting moderators... Successful.
Converting membergroups... Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1259424443),
    ("conversion_from", "phpfusion7_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", 1259424443)' at line 1

all my forum topics and users from fusion appeared in smf, but i can't login

Please don't worry about the last error, it's actually a bug in the converter that has nothing to do with your conversion succeeding.
For the login: check out the first topic in this thread, for the login fix.

thank you a lot for help me :)

Is this converter able to do reverse conversion: from SMF to PHP fusion 7 and how?

Thanks.

No, it doesn't do that. We don't work to provide software that converts away from SMF. Please refer to PHPFusion site for that.

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_first_msg)


Can you guys help me with this?

Hello there!
Please, find in phpfusion7_to_smf.sql:

MIN(post_id) as id_first_msg, MAX(post_id) AS id_last_msg



IFNULL(MIN(post_id), 0) as id_first_msg, IFNULL(MAX(post_id), 0) AS id_last_msg

Then simply run the conversion again.

Quote from: Norv on December 27, 2009, 07:53:46 AM
Hello there!
Please, find in phpfusion7_to_smf.sql:

Code (find) Select Expand


MIN(post_id) as id_first_msg, MAX(post_id) AS id_last_msg


Code (replace) Select Expand


IFNULL(MIN(post_id), 0) as id_first_msg, IFNULL(MAX(post_id), 0) AS id_last_msg

Then simply run the conversion again.

Thank you for the fast anwser, now i got this:

Notice: Undefined index: convert_script in /home/oskarcom/public_html/foro/convert.php on line 977

Warning: Invalid argument supplied for foreach() in /home/oskarcom/public_html/foro/convert.php on line 980

Notice: Undefined index: convert_script in /home/oskarcom/public_html/foro/convert.php on line 992
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/oskarcom/public_html/foro/convert.php on line 2501

Notice: Undefined variable: result in /home/oskarcom/public_html/foro/convert.php on line 2502

Notice: Undefined index: db_fetch_assoc in /home/oskarcom/public_html/foro/convert.php on line 1393

Fatal error: Function name must be a string in /home/oskarcom/public_html/foro/convert.php on line 1393

Can you please make sure you restart the converter fully?
That is, run your_address/convert.php, and not your_address/convert.php?step=1, even, if really necessary, clean your cookies and try again.

i just did a fresh instalation again, now i got this:

Steps
Select Script
Welcome
Main Conversion
      - Members...
      - Categories...
      - Boards...
      - Topics...
      - Posts (this may take some time)...
      - Personal messages (step 1)...
      - Personal messages (step 2)...
      - Topic notifications...
      - Attachments...
      - Moderators...
      - Membergroups...
Recount Totals and Statistics
Done



Converting...
Converting topics...
Duplicate entry '5746' for key 1

Can you please tell, are you using the converter for RC2 from here: http://download.simplemachines.org/?converters;software=phpfusion ?

Also, please login in phpMyAdmin (What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)), select your phpfusion database from the left column, and the SQL tab, and run:

SELECT thread_id FROM fusion_threads WHERE thread_id = '5746';

and copy paste or screenshot the result, and attach it here.

Hello

I just keep getting the same error but with a different number.

Converting posts (this may take some time)...
Duplicate entry '73561' for key 1

and yeah, im using the coverter from the link you showed me.

Thank you for all your help, SMF Support Rocks!

Can you please tell, what did you do to get rid of the error the first time? (the "Duplicate key" at "Converting topics...").

i was replacing the number on this code to the new number.

SELECT thread_id FROM fusion_threads WHERE thread_id = '5746';


But seem like this is an endless, i have a big forum with 1000's of treads.

This doesn't solve anything, however, I simply asked if you could post here its result, so I can see what is going on.

If you ran the conversion again, and then it worked, then something else must have happened, because this code didn't solve a thing.

Update: eventually, please consider selecting your smf_messages table (in SMF database), and find in phpmyadmin the command to "empty" the table. Please do so. Then, run the conversion again?
It's strange however, because the converter should have done it itself.
Are you using two different databases for phpfusion and smf ?

i just di what u told me and this it what i got now.

I think im closed now

Please find in phpfusion7_to_smf.sql:

'' AS max_messages, '' AS stars


'0' AS max_messages, '0' AS stars


Note that you might need to redo running "empty" of the table smf_messages, like before, perhaps of smf_topics as well, before redoing the conversion.

Ok, thats not a problem!

I'll be back,  thank you again!

Thanks you one more time, finally works!


I just can't log-in now, the password doesnt work anymore.


i got this:

Password security has recently been upgraded. Please enter your password again.

Should request a new pass? is this gonna happen to all my members?

Just enter your (same) password again, what does it do then?

I request a newone and it works now.

You shoudn't need to request a new one, nor do the other members.
SMF is asking for one more confirmation, because the hash it saves the password with, really did change, from what was saved in the database (the old hash was using phpfusion's method of hashing). It will ask any member the same thing: to enter the password again, for confirmation. That's all, it should recognize the account correctly afterwards.

I have sucesfully converted phpfusion7 to smf 2rc2
(at least I can see the contents, and there was no error...)

just a problem with passwords... do I need to change something in the smf 2rc2 files?

I saw the fix file in the first post... but it is only for smf 1.11?


SOLVED: I have added the code explained here:
http://www.simplemachines.org/community/index.php?topic=294705.msg2325982#msg2325982

thanks a lot!

btw, in the fix file... can you change it to "php-fusion 6.x & 7.x Login Method in smf 1.1 & 2rc2?" or something similar
I did not use it because I thought it was only for phpfusion6 and smf 1.11

Thank you for the feedback.
I will check it out and eventually, add the note about SMF 2.0, yes. The reason why the fix files aren't named that way is that they were created for 1.1.x, and even, a significant number of them are not needed for SMF 2.0, because SMF 2.0 already includes the necessary checks for a wide range of passwords from other software. I don't know off-hand if it should contain one for phpfusion 6.x - 7.x, though.

three questions...

Recently I have noted that the uploaded attachments to php-fusion (7) were not converted to smf... well, in fact, in the smf I can see just 1 attachment of many of them
Is that ok? or attachmentes are supposed to be fully conerted?

the same happened with custom avatars...
I will need to just move them to the avatars directory?

I made a first convert, to test it, install mods, customize a theme, etc... in a few days my plan is to do the final convert (up to date)... if I do the convert, I will loose all the smf mods? settings?

best regards, and sorry for the bad english :)
luciano

About converting again: If you reconvert on a customized SMF, you shouldn't lose themes, that is not a problem. But as mods are concerned, it depends, those modifying the database might be affected. I strongly advice to uninstall mods, convert, then install mods.

About attachments and avatars: did you have errors during conversion? What messages do you get, during conversion?
Both attachments and avatars should be converted.
What do you mean when you say that in SMF you can see 1 attachment of many, you mean some attachments were converted and others weren't?

Sorry, then I realize that I was using the main admin user, that have uploaded just 1 attachment (lol)... users can see their own attachments, right?

(I have not tested if attachments url are ok, or give 404, yet)

the avatar thing... for example, one user has http://mydomain.com/foros/avatars/AVATAR[174].jpg but that url gives 404
http://mydomain.com/images/avatars/AVATAR[174].jpg is the php-fusion location...
paths are converted, but files are not copied, right?

Quote from: luuuciano on January 31, 2010, 10:18:52 AM
Sorry, then I realize that I was using the main admin user, that have uploaded just 1 attachment (lol)... users can see their own attachments, right?

(I have not tested if attachments url are ok, or give 404, yet)

Thing is, an admin should be able to see all attachments on the forum. Where exactly do you look and see 1 attachment? Normally, I'd expect to browse the forum, look in the topics view, look at the messages where there were attachments uploaded. Were you looking at messages? A screenshot, perhaps?

Quote from: luuuciano on January 31, 2010, 10:18:52 AM
the avatar thing... for example, one user has http://mydomain.com/foros/avatars/AVATAR[174].jpg but that url gives 404
http://mydomain.com/images/avatars/AVATAR[174].jpg is the php-fusion location...
paths are converted, but files are not copied, right?

I'm not sure, it would be good to know if there were errors during the conversion. Thing is, the default avatar directory in SMF is the attachments directory. :) That is, forum_url/attachments, not forum_url/avatars. Did you change the avatar directory in SMF's options? (Admin > Attachments and avatars > Avatars settings)
Is there a file AVATAR[174].jpg in the "attachments" directory in the SMF folder?

Quote from: Norv on January 31, 2010, 10:59:03 AM
Thing is, an admin should be able to see all attachments on the forum. Where exactly do you look and see 1 attachment? Normally, I'd expect to browse the forum, look in the topics view, look at the messages where there were attachments uploaded. Were you looking at messages? A screenshot, perhaps?

for example the first two post (at bottom in the current configuration) had attachments in phpfusion...
http://cbabikes.com.ar/foros/index.php/topic,635.msg8196.html#msg8196
but smf forum shows nothing...

the main admin can only see 1 file attached

the only file that was properly imported (at least showed in the admin and frontend) is the one in this post: http://cbabikes.com.ar/foros/index.php/topic,16.msg66.html#msg66

phpfusion showed it with acode like this:

luuuciano adjunta el siguiente archivo:<br>
<a href="viewthread.php?thread_id=16&amp;getfile=66">recorrido-a-san-fernando-por-villa-allende-y-alrededores.kmz</a>

in the smf atachments directory I see 126 files with names like 1_3b9c64af895ec6e5f327e2e1a3c8d1edd1b85a09
all the files I tried to see were broken (jpgs, gifs, zip, kmz...)

in the phpfusion attachment directory I see almost the same number of files (just 4 more) with the "proper names", like casacada-los-chorrillos.kmz, recorrido-a-san-fernando-por-villa-allende-y-alrededores.kmz, etc

Quote from: Norv on January 31, 2010, 10:59:03 AM
I'm not sure, it would be good to know if there were errors during the conversion. Thing is, the default avatar directory in SMF is the attachments directory. :) That is, forum_url/attachments, not forum_url/avatars. Did you change the avatar directory in SMF's options? (Admin > Attachments and avatars > Avatars settings)
Is there a file AVATAR[174].jpg in the "attachments" directory in the SMF folder?

noup, the converter did not show any error... (I will check it in a couple of hours, in the final covertion...)

it is strange, I just used the defaults directories, the one that smf filled... and they are /attachments and /avatars...

the avatars have just the Actors and Musicians examples
and the attachments directory have the almost all broken and renamed attachments files

I just copied the phpfusion avatars files (uploaded by users) to the smf avatars directory and now it is showing them...

Quote from: luuuciano on January 31, 2010, 12:08:11 PM
for example the first two post (at bottom in the current configuration) had attachments in phpfusion...
http://cbabikes.com.ar/foros/index.php/topic,635.msg8196.html#msg8196
but smf forum shows nothing...

If you're looking as Guest (not logged in), please note that it could be the fault of an option in SMF, in Admin > Permissions, for Guests, to view attachments. I don't remember if by default is allowed or not, perhaps it would be worth if you verify Guests permissions. (if you were looking now as Guest, administrators should see everything all the time).

Quote from: luuuciano on January 31, 2010, 12:08:11 PM
in the smf atachments directory I see 126 files with names like 1_3b9c64af895ec6e5f327e2e1a3c8d1edd1b85a09
all the files I tried to see were broken (jpgs, gifs, zip, kmz...)

This is expected, all attachments should have been renamed to such names, for security reasons. And that doesn't mean they're broken, they should not be broken... only not have the extension in the name. Why do you say they're broken, how exactly do you download them (and with what, with FileZilla by any chance?) and on what operating system do you try to view them, on windows by any chance?

About the avatars: so you had avatars directory set instead of attachments... strange, I think it isn't the default, I wonder what changed it. (I don't think the converter was doing it). Anyway, I understand that now, avatars work, that's great. :)

Quote from: Norv on January 31, 2010, 12:46:42 PM
If you're looking as Guest (not logged in), please note that it could be the fault of an option in SMF, in Admin > Permissions, for Guests, to view attachments. I don't remember if by default is allowed or not, perhaps it would be worth if you verify Guests permissions. (if you were looking now as Guest, administrators should see everything all the time).

noup, I was looking it as administrator...
but it is strange, because the files are there, but they are not showed in the administration/frontend?

Quote from: Norv on January 31, 2010, 12:46:42 PM
This is expected, all attachments should have been renamed to such names, for security reasons. And that doesn't mean they're broken, they should not be broken... only not have the extension in the name. Why do you say they're broken, how exactly do you download them (and with what, with FileZilla by any chance?) and on what operating system do you try to view them, on windows by any chance?

yep, I used filezilla to download them (linux)... now I forced it do binary, and the files are ok :)
but, what could happen with the "lost" attachments? I will try converting it again

I have converted it again and there is no error... this is the output:

QuoteConverting...
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... Successful.
Converting moderators... Successful.
Converting membergroups... Successful.
Recalculating forum statistics... Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)

Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the PHPFusion 7.0.x installation.

We hope you had a smooth transition!

Previously I have erased the converted attchment files... then I saw the new converted files there, but in the admin backend it is showed just 1 attached file... the same than the previous convert...

any idea? can I help with something?

Perhaps running Admin > Attachments and avatars > Maintenance will help.

Quote from: Norv on January 31, 2010, 01:49:02 PM
Perhaps running Admin > Attachments and avatars > Maintenance will help.

mmmm, nothing changes...

it shows:

QuoteTotal Attachments:
    1
Total Avatars:
    0
Total Size of Attachment Directory:
    7540.28 kB [Maintain]
Total Space Available in Attachment Directory:
    2699.72 kB

Cliking in Maintain it shows:

QuoteNo errors were found!

:(

Can you please: login in phpMyAdmin, select SMF's database, the table smf_attachments (or your_prefix_attachments, if you use another prefix for SMF tables), and simply browse it. Are there many records there?

It shows just 1 record...

maybe can I add some code to the convert attachment sections to see/log what is happening there?

(but I do not know too much php...)

Looking a bit in the code, it seems a strange little thing is here, can you please try:

---* {$to_prefix}attachments
---{


and remove the line after it:

$no_add = true;

Just remove this no_add line. Then, please restart the conversion. I didn't test, but it seems it should work just fine.

oh, in the sql file!

found it :)

will test it

It shows this:

QuoteConverting...
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: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/cba2kes/public_html/foros/Sources/Subs-Db-mysql.php on line 641
The database value you're trying to insert does not exist: id_attach

previously I have deleted the files of the smf attachments directory

Please try: (<SMF's folder>/Sources/Subs-Db-mysql.php)

// Here's where the variables are injected to the query.
$insertRows = array();
foreach ($data as $dataRow)
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);



// Here's where the variables are injected to the query.
echo "indexed_columns:<br>";
var_dump($indexed_columns);
echo "<br>";
$insertRows = array();
foreach ($data as $dataRow) {
echo "dataRow: <br>";
var_dump($dataRow);
echo "<br>";
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);
}


Then, there is no need to delete the attachments (though you might want to clear the folder before the last conversion you do, because the converter will create yet another set of hashed-named files, doubling the number of files at each run :). You most likely won't want duplicates for the real forum).
Then, please re-run the conversion. It should write out on the page a lot more data. The last messages before the error will be useful.

Note: with this modification, a lot more data will appear on forum too. Please undo this modification as soon as possible, after running the conversion, it's definitely meant for testing/debugging, not for a real site.

I have changed it, then uploaded and converted... here the last lines:

Converting attachments...indexed_columns:
array(8) { [0]=> string(9) "id_attach" [1]=> string(4) "size" [2]=> string(8) "filename" [3]=> string(9) "file_hash" [4]=> string(6) "id_msg" [5]=> string(9) "downloads" [6]=> string(5) "width" [7]=> string(6) "height" }
dataRow:
array(8) { ["id_attach"]=> int(1) ["size"]=> string(5) "10210" ["filename"]=> string(60) "recorrido-a-san-fernando-por-villa-allende-y-alrededores.kmz" ["file_hash"]=> string(40) "c2ee012163b4d8d234564dce9c7a52e11fdc45dd" ["id_msg"]=> string(2) "66" ["downloads"]=> string(1) "0" ["width"]=> string(1) "0" ["height"]=> string(1) "0" }
dataRow:
array(7) { ["id_attach"]=> string(1) "1" ["size"]=> string(5) "10210" ["filename"]=> string(60) "recorrido-a-san-fernando-por-villa-allende-y-alrededores.kmz" ["id_msg"]=> string(2) "66" ["downloads"]=> string(1) "0" ["width"]=> string(1) "0" ["height"]=> string(1) "0" }

Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/cba2kes/public_html/foros/Sources/Subs-Db-mysql.php on line 647
The database value you're trying to insert does not exist: id_attach

no more info provided

Please add back the line

$no_add = true;

where it was before, and add a few lines down:

if (copy($yAttachmentDir . '/' . $row['filename'], $attachmentUploadDir . '/' . $physical_filename))
{


$no_add = false;


changes done, convert...

and it shows the same message:
Successful.
Converting attachments...indexed_columns:
array(8) { [0]=> string(9) "id_attach" [1]=> string(4) "size" [2]=> string(8) "filename" [3]=> string(9) "file_hash" [4]=> string(6) "id_msg" [5]=> string(9) "downloads" [6]=> string(5) "width" [7]=> string(6) "height" }
dataRow:
array(8) { ["id_attach"]=> int(1) ["size"]=> string(5) "10210" ["filename"]=> string(60) "recorrido-a-san-fernando-por-villa-allende-y-alrededores.kmz" ["file_hash"]=> string(40) "44c8af055269b1b6bcd9a27db40ec0c3c20f98fe" ["id_msg"]=> string(2) "66" ["downloads"]=> string(1) "0" ["width"]=> string(1) "0" ["height"]=> string(1) "0" }
dataRow:
array(7) { ["id_attach"]=> string(1) "1" ["size"]=> string(5) "10210" ["filename"]=> string(60) "recorrido-a-san-fernando-por-villa-allende-y-alrededores.kmz" ["id_msg"]=> string(2) "66" ["downloads"]=> string(1) "0" ["width"]=> string(1) "0" ["height"]=> string(1) "0" }

Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/cba2kes/public_html/foros/Sources/Subs-Db-mysql.php on line 647
The database value you're trying to insert does not exist: id_attach

maybe something is bad in my phpfusion database?

several attachments conversion worked ok in other cases?

well I guess I will be doing a "manual" convert of important attachments, lol
:)

(at least it will free space and dump dumb attachments)

Hi guys
So I downloaded the convert.php and the phpfusion_to_smf.sql attachments, I've installed SMF and uploaded the above mentioned files, I went to the convert.php file, got the boxes, filled in the path to SMF, path to Fusion, database password, however when I click "Continue" all I get is a white page :S Any ideas?

After a conversion users can not set threads as viewed... you click the link to see unread threads, and there is allways the same links... no mather if you try marking all as read...
I have tried making a new user... all users see the same "unread threads"...

any idea?

well, finally I have used the 1.11.1 converter instead the not yet finished 2.0rc2 converter...
and the unread thread issue is not present...

but avatars were not translated... all the users are there without avatar settings at all and no file copied...

in phpfusion 7 avatars are stored in http://domain.com/images/avatars/
not in http://domain.com/forum/attachments
(the are just attached files)

any idea?

@SilvaD:
please check Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0).. I'm not 100% sure but a white page is often related  toa read only php session dir.

@luuuciano,
we can modify the converter slightly, did you get any errors during avatar conversion?

@ DjCrUzItOReY,
sorry but this part of SMF is english only.. please check our language specific support  (http://www.simplemachines.org/community/index.php?board=12.0)boards.

Quote from: Norv on October 24, 2009, 06:24:37 PM
Please try adding this code to your_smf_directory/Sources/LogInOut.php :

Code (find) Select Expand


// phpBB3 users new hashing.  We now support it as well ;).


Code (add before) Select Expand


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


UPDATE: it should work just fine for phpfusion 7 as well. Please make sure you empty your browser's cache and don't save passwords in the browser, and try logging in after this modification.

Thanks, the login is working again :D
But, there's one problem  :-\ I need to login twice...
First time: I can see myself at the "online members list"
Second time: Am I online...

After that I logout again... And login again.. but than it's just working once.. Deleting cookie's etc. I need to login twice  ??? (Could be a problem in Firefox ?)

Ok, So I have the old php-fusion 7 site and the new installed smf 1.1.11 site install where I would like the data converted too.

I copied the files convert.php into my SMF folder, plus the other files attached to this thread.

SMF path; /Webroot/www/clan-eve
PHP fusion; /Webroot/www/claneve

I add the info it needs plus the database password.

Hit next where the browser status says Done, with a blank page???

Can you please try using the files in the package found in this site's Downloads > Converters?

Quote from: Norv on August 20, 2010, 02:04:48 PM
Can you please try using the files in the package found in this site's Downloads > Converters?

Been there, I have the right convert.php the 80.7 KB (82637 bytes), 4 hours later after alot of missing around I get the darn thing to work. :)
http://www.ukscifi.net/claneve/ converted to http://www.ukscifi.net/clan-eve/

I am doing this for a friend, getting then onto SMF. :)

Member logins arn't working, but I'll try and fix this tomorrow.

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.

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

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

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...
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. (http://www.simplemachines.org/community/index.php?topic=294705.msg2482109#msg2482109)), but no chance.

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

Hi.
I have error during convert.
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: 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: 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: user_birthdate AS birthdate, SUBSTRING(user_icq , 1, 255) AS icq,after it i have this error: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:SUBSTRING(user_aim, 1, 16) AS aim,after it i have this error: 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: SUBSTRING(user_yahoo, 1, 32) AS yim, 0 AS gender,and i see next error: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: SUBSTRING(user_msn, 1, 255) AS msn, and i was see this error: 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.

Bump.
Some1 know, where is a problem?

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

Here is it.
Greetings.

please try the attached version..

Hi.
Thanx for reply.
Posts now are converted, but attachments nope :/, I have this error now:
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.

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

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

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

Hi.
Thanx for reply.
Now I have this error:
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.

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

Thanx for reply, but now I have this error:
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.

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?

Now, when I click Continue I have this error:
Fatal error: Call to undefined function loadFile() in E:\XAMPP\xampp\htdocs\smf7\convert.php on line 330

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

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'

have you tried the version attached to this message?
http://www.simplemachines.org/community/index.php?topic=294705.msg3402723#msg3402723
direct link to file:
http://www.simplemachines.org/community/index.php?action=dlattach;topic=294705.0;attach=208943

Now it's working!
Really big thanx to you Thorsten Eurich!
Greetz bro!

Quote from: Thorsten Eurich on September 12, 2012, 10:51:12 AM
have you tried the version attached to this message?
http://www.simplemachines.org/community/index.php?topic=294705.msg3402723#msg3402723
direct link to file:
http://www.simplemachines.org/community/index.php?action=dlattach;topic=294705.0;attach=208943

Hi, thanks for your reply

Yes I now tried that file with the convert.php from this post:
http://www.simplemachines.org/community/index.php?topic=294705.msg3403679#msg3403679

I get the same error...

mhh, sounds like there's a duplicate topic id ..

in phpfusion7_to_smf.sql find:
---* {$to_prefix}topics
add after:

---{
$ignore = true;
---}

then rerun the converter.

Great thanks - the conversion worked!

Now I just have to be able to login "Password security has recently been upgraded. Please enter your password again."

I ran the login-fix from the first post before convertering - didn't help :)

Any ideas?

Quote from: ChandlerBing on September 13, 2012, 09:26:27 AM
Now I just have to be able to login "Password security has recently been upgraded. Please enter your password again."

Do you get this message more than once? IIRC you should get this message during the first login only..

Quote from: Thorsten Eurich on September 13, 2012, 09:51:23 AM

Quote from: ChandlerBing on September 13, 2012, 09:26:27 AM
Now I just have to be able to login "Password security has recently been upgraded. Please enter your password again."

Do you get this message more than once? IIRC you should get this message during the first login only..

Yes, I get it until I reach the authentication reminder.

ok, checked the phpfusion7 source code and AFAICS they've changed the password authentication mechanism completely.  Maybe I can work on a login fix during the next days but you'd have to re-convert the forum because some important data is missing.

Their new password structure is based on three database rows (user_algo, user_salt and user_password) but the converter currently covers only 'user_salt' and 'user_password'.

Fantastic.

Until now I've just tested the converter on a wamp-server so I can wait :)

here we go ;) please use the attached version..

Login fix:
in Sources/LogInOut.php find:
// Whichever encryption it was using, let's make it use SMF's now ;).

add before:
$other_passwords[] = hash_hmac('sha256', $_POST['passwrd'], $user_settings['password_salt']);

I never got around to this but the solution worked!

Thanks for your help! :)

Has this been updated? I have PHP-Fusion version   7.02.05. I have never done anything remotely like this so i may have a lot of questions

ok i done everything the wiki said, and i got this in the end.

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 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 `ammweb`.fusion33K28_users
    LIMIT 0, 500;

Caused the error:

    Unknown column 'user_icq' in 'field list'

Hello everyone I got stuck at members to :)
My version of php-fusion: 7.02.04

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 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 `thesnakepit_se`.fusionl7r3A_users
LIMIT 0, 500;
Caused the error:
Unknown column 'user_sig' in 'field list'

First I thought it could be from some code for showing "online/offline/ingame - status" from members using Steam,
but Im not sure. I don´t recognize the column.  :-\ If you can help me with this one I would really appreciate your help!

Many regards

Smirre

remove SUBSTRING(REPLACE(user_sig, '<br>', '<br />'), 1, 65534) AS signature, from phpfusion7_to_smf.sql and try again.

Quote from: Dexter Morgan on November 28, 2013, 04:39:06 AM
remove

Code Select Expand

SUBSTRING(REPLACE(user_sig, '<br>', '<br />'), 1, 65534) AS signature, from phpfusion7_to_smf.sql and try again.

Thank you so much! It worked perfect!  :D

//Smirre

Hello,
excuse me for using this old topic, but I guess my issue fits here.

I'm trying to migrate an old PHP Fusion 7.02 board to SMF, it runs fine (as long as I do not click "Continue" and just let the converter do it's stuff :D), but when I arrive to attachment, I experience an issue that brings the process to stop:

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...The database value you're trying to insert does not exist: id_attach

In the apache error log I see the following message a lot of times:
PHP message: PHP Warning:  A non-numeric value encountered in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php(1270) : eval()'d code on line 4

The converter.php contains the following, line 1270 highlighted bold:

while ($row = convert_fetch_assoc($special_result))
{
if ($special_code !== null)
[b] eval($special_code);[/b]

// Here we have various bits of custom code for some known problems global to all converters.
if ($special_table == $to_prefix . 'members')
{
// Let's ensure there are no illegal characters.
$row['member_name'] = preg_replace('/[<>&"\'=\\\]/is', '', $row['member_name']);
$row['real_name'] = trim($row['real_name'], " \t\n\r\x0B\0\xA0");

if (strpos($row['real_name'], '<') !== false || strpos($row['real_name'], '>') !== false || strpos($row['real_name'], '& ') !== false)
$row['real_name'] = htmlspecialchars($row['real_name'], ENT_QUOTES);
else
$row['real_name'] = strtr($row['real_name'], array('\'' => '&#039;'));
}


The converter is the official one from the Download area.

Does anyone have an Idea?

Thanks a lot

Sebastian

Maybe the log messages above are not the reason for the stop of the process, i found another message:

[Thu Jan 16 12:41:37.021802 2020] [proxy_fcgi:error] [pid 21194:tid 140038499145472] [client 212.18.198.162:33686] AH01071: Got error 'PHP message: PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/vhosts/PAGENAME/httpdocs/smf/Sources/Subs-Db-mysql.php on line 1497', referer: https://PAGENAME/smf/convert.php?step=1&substep=9&start=96200

After the convert process stops, there has no entry been inserted to the _attachments table of SMF, around 500 files have been created in attachments directory on the server.

Another try (can't I edit posts here?):

I used the latest converter files from Github, now all ( i guess) 10 000 files are transferred to the attachments folder, but in the database there are only sometimes 2 attachment entries, sometimes 5 or 10.

After the attachments-converting, i receive the following message:

Converting attachments...
Successful.
Converting membergroups... Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `tda_smf`.qpx_topics
    SET id_first_msg = '101154',
    id_member_started = '4973', id_last_msg = '101162',
    id_member_updated = '75', num_replies = '6'
    WHERE id_topic = 6982
    LIMIT 1;

Caused the error:

    1062

So there seems also another problem. I really would appreciate some help :) I'm lost

We do not allow editing of posts after a few minutes on the forum.
Can you run the query via mysql such as phpmyadmin

UPDATE `tda_smf`.qpx_topics
    SET id_first_msg = '101154',
    id_member_started = '4973', id_last_msg = '101162',
    id_member_updated = '75', num_replies = '6'
    WHERE id_topic = 6982
    LIMIT 1;


QuoteWe do not allow editing of posts after a few minutes on the forum.

Ah, thank you, so I was just too late :)

QuoteCan you run the query via mysql such as phpmyadmin
[...]

After the latest try, the error was:
Converting...
Converting attachments...
Successful.
Converting membergroups... Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `tda_smf`.qpx_topics
    SET id_first_msg = '101154',
    id_member_started = '4973', id_last_msg = '101162',
    id_member_updated = '75', num_replies = '6'
    WHERE id_topic = 6982
    LIMIT 1;

Caused the error:

    1062

So I used the message above, phpmyadmin said:
SQL-Befehl:

UPDATE `tda_smf`.qpx_topics
SET id_first_msg = '101154',
id_member_started = '4973', id_last_msg = '101162',
id_member_updated = '75', num_replies = '6'
WHERE id_topic = 6982
LIMIT 1

MySQL meldet: Dokumentation
#1062 - Doppelter Eintrag '101154-6' für Schlüssel 'first_message'

What can I do? Between each try I cleared all database field that contained imported data, so this should not happen.

Do you also have an Idea regarding the attachment problem?

Try this convert.php for the second issue.

Looks like the last part worked, thank you!

Unfortunately there is still the problem with the attachments, could you help me with that, too? :)

I'm clueless, maybe the error message from #116 is the reason, i don't know :(

I tried around, but there is always (depending on the SQL) file a message:

First, with "official" SQL file (Downloads > Converters > PHP Fusion 7) and convert.php from @vbgamer45:

QuoteConverting attachments...The database value you're trying to insert does not exist: id_attach

and the process stops (~500 files in attachments folder, no database entry for attachments).

PHP error log: :07:05.994735 2020] [proxy_fcgi:error] [pid 32312:tid 140479656032000] [client *IP*:51774] AH01071: Got error 'PHP message: PHP Notice:  Undefined index: convert_script in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 987PHP message: PHP Warning:  Invalid argument supplied for foreach() in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 990
PHP message: PHP Notice:  Undefined index: convert_script in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 1002', referer: https://PAGENAME/smf/convert.php
[Fri Jan 17 20:07:05.995076 2020] [proxy_fcgi:error] [pid 32312:tid 140479656032000] [client *IP*:51774] AH01071: Got error 'PHP message: PHP Deprecated:  strpos(): Non-string needles will be interpreted as strings in the future. Use an explicit chr() call to preserve the current behavior in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 2449
PHP message: PHP Notice:  Undefined variable: result in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 2510PHP message: PHP Notice:  Undefined variable: result in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 2511
PHP message: PHP Notice:  Undefined index: db_fetch_assoc in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 1401
PHP message: PHP Fatal error:  Uncaught Error: Function name must be a string in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php:1401\nStack trace:\n#0 /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php(1341): doStep2()\n#1 /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php(51): doStep1()\n#2 {main}\n  thrown in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 1401', referer: https://PAGENAME/smf/convert.php
[b]PHP message: PHP Warning:  A non-numeric value encountered in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php(1269) : eval()'d code on line 4[/b]*
Last (bold marked) line appears more than 4400 times in the logfile (quick word search for "non-numeric value encountered"  8) )


Next try with Github SQL-file and convert.php from @vbgamer45:

QuoteConverting...
Converting attachments...
Successful.
Converting membergroups... Successful.
Recalculating forum statistics... Successful.
Conversion Complete

So it seems to be finished  ( There are 10 005 files in attachments folder, (seems to be okay) but (this time) 11 database entries for attachments).

[Fri Jan 17 21:27:19.490425 2020] [proxy_fcgi:error] [pid 32312:tid 140479882856192] [client *IP*:60438] AH01071: Got error 'PHP message: PHP Warning:  A non-numeric value encountered in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php(1269) : eval()'d code on line 4
This line also appears more than 4400 times in the logfile (quick word search for "non-numeric value encountered"  8) ) seems to be the same issue than above.

I tried also the official convert.php and the Github one, the result depends on the SQL-file (see above).

Regarding the PHP Fusion database, there should be around 10000 attachments.

So can someone help? Do you need further information?

Can you explain PHP fusion more I haven't used it before. Is it just a downloads system or does it do more with posts?

PHP Fusion is a CMS-system with integrated forum. The attachments are related to forum posts, mostly they are pictures in my case.


Downloads are not included with this converter, but i dont need it also. Just the forum contents including the post attachments would be fine.

Do you need further information? :)

Isn't there somebody out there who can help me?  :)
I'd spend a coffee or two for some help  ;D

Can I do something to make it easier to help me? Id does not have to be for free of course, i just need to convert attachments, too :/

So, no way to help me? As you notice, i'm quite desparate

It would probably have to be done via a script that is manually created. Would take probably 2 to 3 hours of work depending on the format.

So it becomes quite expensive? Myself - i do not have the knowledge to do this :(
I mean, in general, the parts seem to work besides this "bug"...

Is there someone who would do that for me? If yes, let me know the prize. I can give access then

For me it looks like there's something wrong with the attach_id as all files inserted in the new attachment folder begin with 1_ (which should be the attachment ID as far I can read the script).
It looks like there is a block of 500 items copied, after that i guess the mysql entries should be inserted which seems to fail...

20$ for the person that helps me find a solution  :laugh:

Edit:
now i inserted a dummy entry in the database, now the system runs multiple runs to copy all the files, but per run, there are only 1-2 database entries added...

Even if i'm the only one answering me... i made some progress

in the phpfusion7_to_smf.sql i changed line 232:
$rows[] = array(
'id_attach' => $id_attach,

to

$rows[] = array(
'id_attach' => $row['id_attach'],


the result is that all files are copied and there are database entries for all the files.

Problems I found:

• Due to the change, the file names are wrong, the file prefix seems to be the one of the first item that has been processed in the block, so I have (i guess) blocks with 500 items with the same prefix and their hashes then. The result is that attachments are not working due to missing files (404).
• For only one item per processing block (?), width and height of an image seems to be processed, so I have only 5 items where this information has been added, the others contain the zero values (Thinking of it, 5 items with this information seems to be less than processing blocks...)

For the first issue, a script could rename the files using the database (lookup for the ID using the hash values), but i'm not able to program it unfortunately.

I think it should be 'id_attach' => $id_attach,

I checked all the other convertors and it is like that but I would also change

$file_hash = getAttachmentFilename($row['filename'], $row['id_attach'], null, true);

To

$file_hash = getAttachmentFilename($row['filename'], $id_attach, null, true);

I noticed PHP Fusion was the only who had that statement above changed.
Let me know if that helps.

Nearly there.

I found out that i had to change the sql file in two places to make it work.

First (as already mentioned):
in the phpfusion7_to_smf.sql i changed line 232:

$rows[] = array(
'id_attach' => $id_attach,

to
$rows[] = array(
'id_attach' => $row['id_attach'],

Second:

$physical_filename = $id_attach . '_' . $file_hash;

to

$physical_filename = $row['id_attach'] . '_' . $file_hash;


The variable $id_attach seems to be not available, using the $row array seems to work.

Thanks a lot, i'm done!

Added changes to next release update. thanks for the information

Thank you :)