e107 converting error. help!

[Grzegorz]

e107 to SMF Converter
Converting...
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 `a11244_alhim`.e107_user AS u
    WHERE u.user_id > 0
    LIMIT 0, 500;

Caused the error:

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

[SleePy]

http://www.simplemachines.org/community/index.php?topic=141395.msg966027#msg966027

[Grzegorz]

enable extended user fields on e107 admin.

I made enable. All is equal, the same result.

[SleePy]

If you go into the database and then the extended profile table.
Do you see a column that is holding the birthdate in it? Can you paste the name of the column here?

[Grzegorz]

hxxp:ipicture.ru/Gallery/Viewfull/1860046.html [nonactive]

[SleePy]

Ok,

http://www.simplemachines.org/community/index.php?topic=141395.0

Try the .sql file linked in that first post. It seems to have the correct one. You must of used the ones of the download pages which are not as updated as the ones in the topic.

[Grzegorz]

Stoped at "Converting smileys..." but members and posts has been converted. Thanks!!!

[SleePy]

did it just stop or did some errors occur?