E107 Conversion Error

[Spookd]

SMF Version: SMF 1.1 RC2
Converting members... Unsuccessful!
This query:

    SELECT
    u.user_id AS ID_MEMBER, u.user_name 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,
    u.user_name AS realName, u.user_password AS passwd,
    u.user_email AS emailAddress, 0 AS gender, ue.user_birthday AS birthdate,
    REPLACE(ue.user_homepage, 'http://', '') AS websiteTitle,
    ue.user_homepage AS websiteUrl, ue.user_location AS location,
    ue.user_icq AS ICQ, ue.user_aim AS AIM, ue.user_msn AS MSN,
    u.user_hideemail AS hideEmail, u.user_signature AS signature,
    IF(SUBSTRING(u.user_timezone, 1, 1) = '+', SUBSTRING(u.user_timezone, 2), u.user_timezone) AS timeOffset,
    u.user_image AS avatar, u.user_customtitle as usertitle,
    u.user_ip AS memberIP
    FROM `godforum`.e107_user AS u
    LEFT JOIN `godforum`.e107_user_extended AS ue ON (u.user_id = user_extended_id)
    WHERE u.user_id > 0
    LIMIT 0, 500;

Caused the error:

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

-------------
SMF 1.1 Rc2
E107 .75

Ive read multiple topics with little help.. I'm not a master SQL programmer but I know my way around phpadmin.. Any help is greatly appriciated, thanks.

[H]

If you look at the structure of the smf members in phpmyadmin which fields do you have?

[Spookd]

ok, looks as if i was just missing the fields, but heres another problem... i keep getting duplicate entry errors for my users. and i have no clue whats causing it...

Honestly my database is sorta messed up and outa my grasp to fix it... if anyone can do a sorta borked conversion send me a pm, im even willing to pay a bit...
-Spook

[Spookd]

Conversion successful, but not really... the boards are not in the correct categories, and they even arent showing up on the admin pannel... also... it seems as each thread repeats itself. this is basicly causing each thread to go to 100 pages.. any help is appriciated.

[H]

Did you get any errors during the conversion?

Did you convert to 1.0 or 1.1?

/edit: You should be converting to 1.1 using the e107 converter and convert.php stickied in this board

[Spookd]

Did you get any errors during the conversion?

Did you convert to 1.0 or 1.1?

/edit: You should be converting to 1.1 using the e107 converter and convert.php stickied in this board

1.1 RC2

Ive converted, played around with some database stuff, and got most of it to work. Theres an error with threads though, replies show up in the begining of the thread and at the end (100 page). If you want you are free to check it out at godwowguild.com.

[kalleball]

ok, looks as if i was just missing the fields, but heres another problem... i keep getting duplicate entry errors for my users. and i have no clue whats causing it...

Honestly my database is sorta messed up and outa my grasp to fix it... if anyone can do a sorta borked conversion send me a pm, im even willing to pay a bit...
-Spook

i'm getting duplicate entry errors aswell, don't know what's wrong with my user tables =/

Code Select Expand

Caused the error:

    Duplicate entry '2' for key 1

[青山 素子]

Check that auto_increment is set on the user's ID number in the database.