• Welcome to Simple Machines Community Forum. Please login or sign up.
December 07, 2021, 08:14:50 AM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) Read more.


[SMF Converter] e107 - 0.7.7

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

Previous topic - Next topic

ThorstenE

Great work, and thank you for sharing your solution to the public :)

kaloer


WarBirD

Anyone knows how to get passed this ?

Quote
Converting members... Unsuccessful!
This query:

    SELECT
    u.user_id AS ID_MEMBER, SUBSTRING(u.user_loginname, 1, 80) AS memberName,
    u.user_join AS dateRegistered, u.user_forums AS posts,
    (CASE WHEN u.user_admin = 1 THEN 1 ELSE 0 END) AS ID_GROUP, u.user_lastvisit AS lastLogin,
    SUBSTRING(u.user_name, 1, 255) AS realName,
    SUBSTRING(u.user_password, 1, 64) AS passwd,
    SUBSTRING(u.user_email, 1, 255) AS emailAddress, 0 AS gender,
    ue.user_birthday AS birthdate,
    SUBSTRING(REPLACE(ue.user_homepage, 'http://', ''), 1, 255) AS websiteTitle,
    SUBSTRING(ue.user_homepage, 1, 255) AS websiteUrl,
    SUBSTRING(ue.user_location, 1, 255) AS location,
    SUBSTRING(ue.user_icq, 1, 255) AS ICQ,
    SUBSTRING(ue.user_aim, 1, 16) AS AIM,
    SUBSTRING(ue.user_msn, 1, 255) AS MSN, u.user_hideemail AS hideEmail,
    SUBSTRING(u.user_signature, 1, 65534) AS signature,
    CASE
    WHEN SUBSTRING(u.user_timezone, 1, 1) = '+'
    THEN SUBSTRING(u.user_timezone, 2)
    ELSE u.user_timezone
    END AS timeOffset,
    SUBSTRING(u.user_image, 1, 255) AS avatar,
    SUBSTRING(u.user_customtitle, 1, 255) AS usertitle,
    SUBSTRING(u.user_ip, 1, 255) AS memberIP,
    SUBSTRING(u.user_ip, 1, 255) AS memberIP2, '' AS lngfile, '' AS buddy_list,
    '' AS pm_ignore_list, '' AS messageLabels, '' AS personalText, '' AS YIM,
    '' AS timeFormat, '' AS secretQuestion, '' AS secretAnswer, '' AS passwordSalt,
    '' AS validation_code, '' AS additionalGroups, '' AS smileySet
    FROM `advanc19_joawsite`.e107_user AS u
    LEFT JOIN `advanc19_joawsite`.e107_user_extended AS ue ON (ue.user_extended_id = u.user_id)
    WHERE u.user_id != 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'ue.user_birthday' in 'field list'

I know, activate Extended Userfields. It is active. But it still gives me that error. Before it was the same error with "ICQ" instead of the "Birthday", then I deleted the ICQ Field and now its the Birthday field. I read many topics that just say "Enable extended User Fields" which is on, but it just won´t work.

Any ideas ?

WarBirD

UPADTE:

I do have the User Extended Fields in the Database, just not that Birthday thing. Other extended Fields are in the tables. I tried adding a Extended userfield called "user_birthday" but I did not know exactly what to fill in, and what i tried usually led to a message like:

Quote
Update unsuccessful as no changes were made.
Please try again.

Any help on this please ?  :(

ThorstenE

try removing this line from e107_to_smf.sql

ue.user_birthday AS birthdate,

WarBirD

Ok, thanks. :) That worked. So far it looks good. But i realize that the IP´s that usually are shown only to Admins & Moderators now are all set to "0.0.0.0" even if I am posting things in the new Forum already. Its not picking up my IP in there.

That the others are not visible from before is because that Data isn´t converted from the old Site, but shouldn´t that at least start now after the conversion ?

Thanks

SleePy

Sounds like you are getting an invalid ip address.

Are these for new posts? The converter may not be picking up existing posts ips, but new posts you make on your SMF forum should work.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

WarBirD

May 08, 2009, 02:49:59 PM #247 Last Edit: May 08, 2009, 02:59:58 PM by WarBirD
Well, now I´ve realized that the Conversion had a major flaw.

None of the Useraccounts has its Email still. How the hell can that be ? How can the Emails be just not in there ?

OMG, now I see it. There were some lines like the ICQ in the sql File i had to remove, otherwise it wouldn´t work. And now I see, i must have deleted the line that says to import the Email Accounts as well. :(

How can I use the converter to only convert the users again, not all the other stuff that is converted ??? Any idea how I can make that possible ? I don´t want to redo all of it, since the rest works. I just need to convert the Email Adresses really. Please, anyone knows how to make that that specific ?

SleePy

You would just need to remove the other parts of the conversion in the .sql.

I attached a file that has only the members conversion.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

SBurke930

May 19, 2009, 11:04:08 AM #249 Last Edit: May 19, 2009, 11:51:42 AM by SBurke930
Quote from: mitooz on August 04, 2007, 03:27:05 AM
Hello I get this on the first step of the converter.
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of e107. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user xxxxxxxxxx @'localhost' for table 'e107_user'

Any idea how to fix this?
Thanks in advance.

I get this same error and after talking to the host (netfirms) they wanted me to make a backup of the database and upload it into the test forum. 


UPDATE!

I got the convertor to work however I have a list of errors
Notice: Undefined index: convert_script in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 810

Warning: Invalid argument supplied for foreach() in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 813

Notice: Undefined index: convert_script in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 825

Notice: Undefined index: convert_script in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 721
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1211

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1221

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1229

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1252

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1265

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1311

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1313

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1319

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1325

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1336

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1337

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1345

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1347

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1353

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1354

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1360

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1361

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1385

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1387

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1393

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1405

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1430

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1432

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1476

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1491

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1520

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1522

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1535

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1557

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1562

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1623

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1625

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1661

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1680

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1703

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1704

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2411

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2411

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240
Successful.


When I checked the testforum nothing has happened.  Can someone help me get this corrected?

ThorstenE

the new error is a broken session... have you tried to restart the conversion from the beginning?


SBurke930

May 19, 2009, 07:07:37 PM #251 Last Edit: May 19, 2009, 09:12:42 PM by SBurke930
How can it be a broken session when the first warning says there is an Invalid argument supplied for foreach() in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 813

This is line 813 so what is wrong with it?

foreach ($convert_data['globals'] as $global)

ThorstenE

There is nothing wrong with convert.php (I used convert.php more than 500x myself), the error indicates that $convert_data['globals'] isn't set.  I believe the cause of this problem is that your host has session.save_path to a non writeable directory. Ask your host to change this setting in php.ini and use the correct path.

defac

Hello there :)
I was successfully converted e107 (0.7.15) to SMF (1.1.9) I was read this theme and i do. After all, i wrapped smf forum into joomla 1.5. And thats also okay. Well, only problem is not too big, but if you can help me that will be fine. All my members, topics and themes (30.737 topics and 6.256 themes) are here, but all my members have a zero (0) messages in statistic under avatar and nickname.

And, also i have question about default smf theme customisation: how to remove or edit help button from top menu.

PS#Sorry for my poor english.


dimmdesign

July 26, 2009, 01:18:23 PM #255 Last Edit: July 26, 2009, 01:25:07 PM by dimmdesign
I'm getting this error could you please help me! thanks in advance.

Fatal error: Call to undefined function loadDatabase() in /var/www/vhosts/macephemera.gr/httpdocs/smf/smf-import/convert.php on line 410.

i've searched inside the convert.php file and although there was a reference to a loadDatabase() there was no function with the the same name. really weird to me...

ThorstenE

I belive you used the wrong files (SMF 2.0 converters instead of SMF 1.1.x converters)
this one should be right: http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-10_e107_converter.zip

dimmdesign

thanks that got me to the next page which for my own bad luck I again got another error :

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of e107 ver.0.7.7. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'my_smf_username'@'localhost' for table 'e107_user'

should i have installed smf into the same database as the e107 and not on a new one as I did???

ThorstenE

convert.php needs read access to your e107 database..

Quote from: dimmdesign on July 26, 2009, 01:39:04 PM
should i have installed smf into the same database as the e107 and not on a new one as I did???
that's the easiest solution ;)

ABCDiamond

Is this still the right topic for the converter from E107 to SMF ?

And are there different methods for each SMF version. ?

Thanks

Advertisement: