• Welcome to Simple Machines Community Forum. Please login or sign up.
December 02, 2021, 04:21:16 AM

News:

Want to get involved in developing SMF, then why not lend a hand on our github!


[SMF Converter] e107 - 0.7.7

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

Previous topic - Next topic

JayBachatero

January 10, 2007, 01:26:50 PM Last Edit: July 18, 2009, 02:44:01 PM by TE
Software: e107
Version: 0.7.7

This is the official support topic for e107 converter.  Use this topic to ask for support for this converter.

Changelog
! Updated the converter to use the new user_extended table for profile data. (e107_to_smf.sql)
! Subtract 499 from the forum_id when converting categories since tinyint max value unsigned is 255. (e107_to_smf.sql)
! If no subject is specified use the default "(No subject)" subject. (e107_to_sql.sql)
! The table should be polls not poll. (e107_to_smf.sql)
! Updated to use the new table structure for polls. (e107_to_smf.sql)
! Updated to use the new table structure for private messages. (e107_to_smf.sql)
! Use the user_loginname column for the memberName column. (e107_to_smf.sql)

convert.php
Use this convert.php with the .sql file attached in this topic.
Follow me on Twitter

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

Angpeu

sorry, but where sql attached file?

JayBachatero

[acting like nothing happened]What chu talking about.  It's right there :P.

Sorry about that.  I uploaded the file.
Follow me on Twitter

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

Angpeu

ok. tnx.
I will test it.

How about True convert E107 Subforums?

Angpeu

I have trouble convert more 1500 members on this error
Caused the error:
Duplicate entry '3482' for key 1

JayBachatero

Follow me on Twitter

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

Angpeu

hmm....
m.b. step1
Converting ranks...Converting groups... Successful.
Converting members... Unsuccessful!
This query:
INSERT INTO `smf`.smf_members

Caused the error:
Duplicate entry '3482' for key 1

I do select count(1) from `smf`.smf_members
Result 1500 Records.
My table E107_user have 1740 records...

JayBachatero

Follow me on Twitter

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

Angpeu

Converting members... Successful.
but e107_user have 1742 rows
new smf_members have 1621 rows  :(

JayBachatero

Darn it.  Check your e107 install for duplicate accounts.  Check to see if there are duplicate user_id.
Follow me on Twitter

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

Angpeu

User_id it's primary key and not have dupelecated rows

look to screenshot

JayBachatero

I'll look more into this.  Not sure why the duplicate key.  Try the first converter again and see if it works.
Follow me on Twitter

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

Angpeu


JayBachatero

Ok drop the ID_MEMBER key from the members table and run the first converter.  Let me know how that goes.
Follow me on Twitter

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

Angpeu


Angpeu

have dupe id on smf_members but where i do
this script from sql file:
SELECT
    u.user_id AS ID_MEMBER, SUBSTRING(u.user_name, 1, 80) AS memberName,
    u.user_join AS dateRegistered, u.user_forums AS posts,
    IF (u.user_admin = 1, 1, 0) 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,
    IF(SUBSTRING(u.user_timezone, 1, 1) = '+', SUBSTRING(u.user_timezone, 2), u.user_timezone) 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 validation_code, '' AS additionalGroups, '' AS smileySet,
    '' AS passwordSalt, SUBSTRING(u.user_ip, 1, 255) AS memberIP2
FROM e107_user AS u
    LEFT JOIN e107_user_extended AS ue ON (u.user_id = user_extended_id)
WHERE u.user_id > 0
order by u.user_id;


no dupes on result and all 1742 row retuturned.

JayBachatero

This is weird.  I wonder if they some how got into the e107 table with the dup id.  Run this query on e107 board and tell me what you get.

SELECT user_id, COUNT(user_id) AS count
FROM {$e107_prefix}user
GROUP BY user_id
WHERE count > 1
Follow me on Twitter

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

Angpeu


JayBachatero


SELECT uid_member, COUNT(id_member) AS count
FROM smf_members
GROUP BY id_member
WHERE count > 1

Check SMF table.
Follow me on Twitter

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

Angpeu

WHERE cannot plased after GORUP True query
SELECT id_member, COUNT(id_member) AS count
FROM smf_members
GROUP BY id_member
HAVING count > 1


Result return 121 row with count = 2

1742-(121*2)=1500  IT's more 1500 rows Convert Problem.

Advertisement: