News:

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

Main Menu

e107 to SMF problem

Started by cyberserg, January 26, 2007, 03:07:11 AM

Previous topic - Next topic

cyberserg

Not sure if i have posted in the right topic, i have an error comming up every time i try to convert my Forum from e107 ro SMF the error is:
_______________________________________________
Converting ranks...Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    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,
    u.user_birthday AS birthdate,
    SUBSTRING(REPLACE(u.user_homepage, 'http://', ''), 1, 255) AS websiteTitle,
    SUBSTRING(u.user_homepage, 1, 255) AS websiteUrl,
    SUBSTRING(u.user_location, 1, 255) AS location,
    SUBSTRING(u.user_icq, 1, 255) AS ICQ, SUBSTRING(u.user_aim, 1, 16) AS AIM,
    SUBSTRING(u.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, '' 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 `cyber_phpbb1`.e107_user AS u
    WHERE u.user_id > 0
    LIMIT 0, 500;

Caused the error:

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

___________________________________
Why is this comming up? i have tryed 3 times to reimstall everything and nothing, no luck  :(

I have specified this also so maybe problem in thet location:
Path to SMF: /home/cyber/public_html/forum
Path to e107: /home/cyber/public_html

THANKS FOR HELP IN ADVANCE!  :)

JayBachatero

Try using the converter in this topic: e107 0.7.7
Follow me on Twitter

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

Advertisement: