News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

[SMF Converter] e107 - 0.7.7

Started by JayBachatero, January 10, 2007, 01:26:50 PM

Previous topic - Next topic

xanaphia

I am using this sql file;
http://www.simplemachines.org/community/index.php?topic=141395.msg1025912#msg1025912

And the converter from this page timestamped June 24, 2007, 07:23:55 AM;
http://www.simplemachines.org/community/index.php?topic=140741

I am running e107 Version 0.7.8 and SMF 1.1.3 both out of mySQL 5.0.27 and PHP 5.1.6, separated into different virtual hosts.

And I am getting the following errors.
Converting smileys...
Notice: Array to string conversion in /var/www/test.vegasfurs/htdocs/convert.php(671) : eval()'d code on line 46
Warning: in_array() [function.in-array]: Wrong datatype for second argument in /var/www/test.vegasfurs/htdocs/convert.php(671) : eval()'d code on line 46

There are stack traces that I can probably snapshot as needed. It says conversion complete but I am always concerned that this means something didn't go properly.

- - - -
I also noticed two things I though were really off, maybe bugs maybe features, but I thought I would point them out;

1) When users are migrated over their login name and display name is not pulled over in a way I thought logical. It makes their SMF login name their current e107 display name and  the SMF display name is set to match.

2) User Avatars are not migrated over.

JayBachatero

#121
For the username issue if I remember correctly e107 just has one column for it.
In regards to the avatarsmiley.  I'll look into it.

EDIT:  Can you give me a sample of the data in the core table under the emote_ name.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

xanaphia

Quote from: JayBachatero on August 09, 2007, 01:22:39 AM
For the username issue if I remember correctly e107 just has one column for it.
In regards to the avatarsmiley.  I'll look into it.

EDIT:  Can you give me a sample of the data in the core table under the emote_ name.

Is this the info you want?
a:60:{i:0;a:1:{s:2:"&|";s:7:"cry.png";}i:1;a:1:{s:3:"&-|";s:7:"cry.png";}i:2;a:1:{s:3:"&o|";s:7:"cry.png";}i:3;a:1:{s:3:":((";s:7:"cry.png";}i:4;a:1:{s:3:"~:(";s:7:"mad.png";}i:5;a:1:{s:4:"~:o(";s:7:"mad.png";}i:6;a:1:{s:4:"~:-(";s:7:"mad.png";}i:7;a:1:{s:2:":)";s:9:"smile.png";}i:8;a:1:{s:3:":o)";s:9:"smile.png";}i:9;a:1:{s:3:":-)";s:9:"smile.png";}i:10;a:1:{s:2:":(";s:9:"frown.png";}i:11;a:1:{s:3:":o(";s:9:"frown.png";}i:12;a:1:{s:3:":-(";s:9:"frown.png";}i:13;a:1:{s:2:":D";s:8:"grin.png";}i:14;a:1:{s:3:":oD";s:8:"grin.png";}i:15;a:1:{s:3:":-D";s:8:"grin.png";}i:16;a:1:{s:2:":?";s:12:"confused.png";}i:17;a:1:{s:3:":o?";s:12:"confused.png";}i:18;a:1:{s:3:":-?";s:12:"confused.png";}i:19;a:1:{s:3:"%-6";s:11:"special.png";}i:20;a:1:{s:2:"x)";s:8:"dead.png";}i:21;a:1:{s:3:"xo)";s:8:"dead.png";}i:22;a:1:{s:3:"x-)";s:8:"dead.png";}i:23;a:1:{s:2:"x(";s:8:"dead.png";}i:24;a:1:{s:3:"xo(";s:8:"dead.png";}i:25;a:1:{s:3:"x-(";s:8:"dead.png";}i:26;a:1:{s:2:":@";s:7:"gah.png";}i:27;a:1:{s:3:":o@";s:7:"gah.png";}i:28;a:1:{s:3:":-@";s:7:"gah.png";}i:29;a:1:{s:2:":!";s:8:"idea.png";}i:30;a:1:{s:3:":o!";s:8:"idea.png";}i:31;a:1:{s:3:":-!";s:8:"idea.png";}i:32;a:1:{s:2:":|";s:11:"neutral.png";}i:33;a:1:{s:3:":o|";s:11:"neutral.png";}i:34;a:1:{s:3:":-|";s:11:"neutral.png";}i:35;a:1:{s:2:"?!";s:12:"question.png";}i:36;a:1:{s:2:"B)";s:12:"rolleyes.png";}i:37;a:1:{s:3:"Bo)";s:12:"rolleyes.png";}i:38;a:1:{s:3:"B-)";s:12:"rolleyes.png";}i:39;a:1:{s:2:"8)";s:10:"shades.png";}i:40;a:1:{s:3:"8o)";s:10:"shades.png";}i:41;a:1:{s:3:"8-)";s:10:"shades.png";}i:42;a:1:{s:2:":O";s:12:"suprised.png";}i:43;a:1:{s:3:":oO";s:12:"suprised.png";}i:44;a:1:{s:3:":-O";s:12:"suprised.png";}i:45;a:1:{s:2:":p";s:10:"tongue.png";}i:46;a:1:{s:3:":op";s:10:"tongue.png";}i:47;a:1:{s:3:":-p";s:10:"tongue.png";}i:48;a:1:{s:2:":P";s:10:"tongue.png";}i:49;a:1:{s:3:":oP";s:10:"tongue.png";}i:50;a:1:{s:3:":-P";s:10:"tongue.png";}i:51;a:1:{s:2:";)";s:8:"wink.png";}i:52;a:1:{s:3:";o)";s:8:"wink.png";}i:53;a:1:{s:3:";-)";s:8:"wink.png";}i:54;a:1:{s:4:"!ill";s:7:"ill.png";}i:55;a:1:{s:7:"!amazed";s:10:"amazed.png";}i:56;a:1:{s:4:"!cry";s:7:"cry.png";}i:57;a:1:{s:6:"!dodge";s:9:"dodge.png";}i:58;a:1:{s:6:"!alien";s:9:"alien.png";}i:59;a:1:{s:6:"!heart";s:9:"heart.png";}}

xanaphia

To be honest am all I loosing is the import of my smileys from e107?
If so I care so very little. I will note that pulling avatars is much more important to me but if that dosn't work with e107 then it just doesn't

JayBachatero

I,'ll download e107 and take a look at the avatar conversion and see if I can make it work.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

slackerpunk

sorry if I ask here I've been looking into SMF for a long time now... just wondering about the convertion system do I need to install SMF first and run the convert.php file from that directory? sorry for asking since there is really now exact procedure on how to do this..

by the way what version of SMF can I use with this conversion system? thanks

slackerpunk

also just a follow when I run the convert.php file will it create a new database for use with SMF for will it rewrite my existing database the e107 is using?

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

slackerpunk


slackerpunk

ok i've started converting from e107 0.7.8 so far as per my screen everything's been successful except for one mishap about extended user fields which I had to enable all fields as stated on previous posts..

Will post results here once it's done


slackerpunk

gave me errors

Notice: Undefined index: convert_script in /home/pinode1/public_html/smf/convert.php on line 586

Notice: Undefined index: convert_script in /home/pinode1/public_html/smf/convert.php on line 594
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 939

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 949

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 957

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 967

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 980

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 993

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1039

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1041

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1047

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1053

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1064

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1065

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1073

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1075

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1081

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1082

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1088

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1089

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1113

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1115

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1121

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1133

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1158

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1160

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1197

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1198

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1235

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1240

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1301

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1303

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1339

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1358

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1381

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1382
Successful.

but it shows it was successful

Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the
Notice: Undefined index: name in /home/pinode1/public_html/smf/convert.php on line 1472
installation.

slackerpunk

ok some threads were not transferred when you look at the forum it says that there are threads and reply on that forum but when you enter it no threads show up

slackerpunk

Quote from: Angpeu on January 14, 2007, 02:12:16 AM
script normaly done.
Sctatistic on Replies not updated.
Img bbc and NO subject not converted.

I think what he meant was the number of members it does not update SMF like for me when I tried it I got like 7k+ members and its not showing that I have 7k+

by the way I am starting from scratch SMF 1.1.3 and e107 0.7.8 using my database.. will post later if I get any errors

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

slackerpunk

yup I am using the last sql file that you posted.. I started from scratch and seems like everything was moved properly.

only problem I am seeing right now would be ascii characters

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

slackerpunk

nope it english just happens that some users use ascii characters for username like ñ ¢ and others

JayBachatero

Oh ok.  I was going to suggest using the UTF-8 converter but no reason to convert your forum to UTF-8 if its an English forum.  A lot of the data is messed up or only a few members?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

slackerpunk

@Jay

Only a few nothing to worry about. So I can confirm this convert works fine for e107 0.7.8

only found one error inside error.log file. Would it be possible if you can post what exactly do we need to see if the conversion was successful?

i.e.

Converting ranks.... Successful
Converting members.... Successful

because it took around 2 hours to convert my whole site around 1,000,000+ posts and 7000+ members so I did not have the luxury on staying infront of the computer waiting for errors or messages to come out.

So far everything works great except for:

1. like I posted earlier ascii characters not converted properly (does not matter only 4-5 members affected)
2. diplay names for e107 will become their login username after conversion
3. after converting I found out that some threads that has multiple pages did not come out it only shows 1 page but the post/reply count is correct. All I did was optimize the database and recomplete/recalculate forum posts/threads inside SMF admin and everything showed up fine with some salvaged posts around 15 of them.

will report more as and if they come by

JayBachatero

If I remember correctly e107 does not have a username column.  I'll have to look more into it and see if there is a way to keep the display name and the username.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: