[SMF Converter] e107 - 0.7.7

[JayBachatero]

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.

[Angpeu]

sorry, but where sql attached file?

[JayBachatero]

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

Sorry about that.  I uploaded the file.

[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]

On what step is that?

[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]

Try this one.

[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.

[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.

[Angpeu]

i already try, but no changes.

[JayBachatero]

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

[Angpeu]

good!!!!
all rows added.

[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.

Code Select Expand


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


[Angpeu]

no count > 1

[JayBachatero]

Code Select Expand


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

Check SMF table.

[Angpeu]

WHERE cannot plased after GORUP True query

Code Select Expand

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.