Advertisement:

Author Topic: [SMF Converter] e107 - 0.7.7  (Read 485308 times)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
[SMF Converter] e107 - 0.7.7
« on: January 10, 2007, 01:26:50 PM »
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.
« Last Edit: July 18, 2009, 02:44:01 PM by TE »
Follow me on Twitter

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

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #1 on: January 10, 2007, 03:17:59 PM »
sorry, but where sql attached file?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] e107 - 0.7.7
« Reply #2 on: January 10, 2007, 03:29:07 PM »
[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

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #3 on: January 10, 2007, 03:37:32 PM »
ok. tnx.
I will test it.

How about True convert E107 Subforums?

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #4 on: January 10, 2007, 03:44:33 PM »
I have trouble convert more 1500 members on this error
Caused the error:
Duplicate entry '3482' for key 1

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] e107 - 0.7.7
« Reply #5 on: January 10, 2007, 04:33:45 PM »
On what step is that?
Follow me on Twitter

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

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #6 on: January 10, 2007, 04:38:03 PM »
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...

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] e107 - 0.7.7
« Reply #7 on: January 10, 2007, 04:46:36 PM »
Try this one.
Follow me on Twitter

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

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #8 on: January 10, 2007, 04:57:02 PM »
Converting members... Successful.
but e107_user have 1742 rows
new smf_members have 1621 rows  :(

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] e107 - 0.7.7
« Reply #9 on: January 10, 2007, 05:01:11 PM »
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

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #10 on: January 10, 2007, 05:42:24 PM »
User_id it's primary key and not have dupelecated rows

look to screenshot

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] e107 - 0.7.7
« Reply #11 on: January 10, 2007, 05:45:42 PM »
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

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #12 on: January 10, 2007, 05:50:46 PM »
i already try, but no changes.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] e107 - 0.7.7
« Reply #13 on: January 10, 2007, 05:59:48 PM »
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

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #14 on: January 10, 2007, 06:05:07 PM »
good!!!!
all rows added.

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #15 on: January 10, 2007, 06:16:02 PM »
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.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] e107 - 0.7.7
« Reply #16 on: January 10, 2007, 06:33:56 PM »
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]
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

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #17 on: January 10, 2007, 06:41:02 PM »
no count > 1

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] e107 - 0.7.7
« Reply #18 on: January 10, 2007, 06:44:29 PM »
Code: [Select]
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

Offline Angpeu

  • Semi-Newbie
  • *
  • Posts: 64
  • Gender: Male
Re: [SMF Converter] e107 - 0.7.7
« Reply #19 on: January 10, 2007, 07:04:17 PM »
WHERE cannot plased after GORUP True query
Code: [Select]
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.