Problem converting vb 3.8 to smf

[jordus]

I get this error when trying to convert...

Code Select Expand

    SELECT
    u.userid AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
    SUBSTRING(u.username, 1, 255) AS realName,
    SUBSTRING(u.password, 1, 64) AS passwd,
    SUBSTRING(u.email, 1, 255) AS emailAddress,
    SUBSTRING(u.homepage, 1, 255) AS websiteTitle,
    SUBSTRING(u.homepage, 1, 255) AS websiteUrl,
    SUBSTRING(u.icq, 1, 255) AS ICQ, SUBSTRING(u.aim, 1, 16) AS AIM,
    SUBSTRING(u.yahoo, 1, 32) AS YIM, SUBSTRING(u.msn, 1, 255) AS MSN,
    SUBSTRING(IF(u.customtitle, u.usertitle, ''), 1, 255) AS usertitle,
    u.lastvisit AS lastLogin, u.joindate AS dateRegistered, u.posts,
    u.reputation AS karmaGood, u.birthday_search AS birthdate,
    SUBSTRING(u.ipaddress, 1, 255) AS memberIP,
    SUBSTRING(u.ipaddress, 1, 255) AS memberIP2,
    CASE
    WHEN u.usergroupid = 6 THEN 1
    WHEN u.usergroupid = 5 THEN 2
    WHEN u.usergroupid = 7 THEN 2
    ELSE 0
    END AS ID_GROUP,
    CASE WHEN u.usergroupid IN (3, 4) THEN 0 ELSE 1 END AS is_activated,
    SUBSTRING(u.salt, 1, 5) AS passwordSalt,
    SUBSTRING(ut.signature, 1, 65534) AS signature, '' AS lngfile,
    '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
    '' AS personalText, '' AS timeFormat, '' AS avatar, '' AS secretQuestion,
    '' AS secretAnswer, '' AS validation_code, '' AS additionalGroups,
    '' AS smileySet
    FROM `smforum19`.vb_user AS u
    LEFT JOIN `smforum19`.vb_usertextfield AS ut ON (ut.userid = u.userid)
    WHERE u.userid != 0
    LIMIT 0, 500;

Caused the error:

    Table 'dbname.vb_usertextfield' doesn't exist



as far as I know the database never had a field called usertextfield.. any ideas?

[jordus]

I don't need a working conversion... Just a read  only archive of the posts would work just fine.... So any work arounds would be fine....