Polskie forum wsparcia dla phpBB

Kod: Zaznacz cały

Converting members... Unsuccessful!
This query:

    SELECT
    user_id AS ID_MEMBER, SUBSTRING(user_name, 1, 80) AS memberName,
    user_joined AS dateRegistered, user_posts AS posts, SUBSTRING(user_password, 1, 64) AS passwd,
    SUBSTRING(user_web, 1, 255) AS websiteTitle,
    SUBSTRING(user_web, 1, 255) AS websiteUrl, user_lastvisit AS lastLogin,
    user_birthdate AS birthdate, SUBSTRING(user_icq , 1, 255) AS ICQ,
    SUBSTRING(user_name, 1, 255) AS realName,
    '' AS notifyOnce, '' AS lngfile,
    SUBSTRING(user_email, 1, 255) AS emailAddress,
    SUBSTRING(user_aim, 1, 16) AS AIM,
    '' AS personalText,
    user_hide_email AS hideEmail, SUBSTRING(user_ip , 1, 255) AS memberIP,
    SUBSTRING(user_ip , 1, 255) AS memberIP2,
    SUBSTRING(user_yahoo, 1, 32) AS YIM, '' AS gender,
    SUBSTRING(user_msn, 1, 255) AS MSN,
    SUBSTRING(REPLACE(user_sig, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(user_location, 1, 255) AS location, user_offset AS timeOffset,
    SUBSTRING(user_avatar, 1, 255) AS avatar,
    '' AS usertitle, '' AS pm_email_notify, '' AS karmaBad, '' AS karmaGood,
    '' AS notifyAnnouncements, '' AS secretQuestion, '' AS secretAnswer,
    IF(user_level = 103, 1, 0) AS ID_GROUP, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS messageLabels, '' AS validation_code, user_groups AS additionalGroups,
    '' AS smileySet, '' AS passwordSalt
    FROM `hermanek_as`.fusion_users
    LIMIT 0, 500;

Caused the error:

    Nieznana kolumna 'user_icq' w field list