News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

E107 Conversion Error

Started by Spookd, August 01, 2006, 10:38:21 PM

Previous topic - Next topic

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.
**Web Admin**
http://godwowguild.com

H

If you look at the structure of the smf members in phpmyadmin which fields do you have?
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

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
**Web Admin**
http://godwowguild.com

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.
**Web Admin**
http://godwowguild.com

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
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Spookd

Quote from: huwnet on August 02, 2006, 12:08:31 PM
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.
**Web Admin**
http://godwowguild.com

kalleball

Quote from: Spookd on August 02, 2006, 11:24:09 AM
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 =/

Caused the error:

    Duplicate entry '2' for key 1

青山 素子

Check that auto_increment is set on the user's ID number in the database.
Motoko-chan
Director, Simple Machines

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


Advertisement: