I have the same error, it looks like the "user_profile" table needs to be joined, as the converter is asking for fields in that table. I had the same idea as lifeaddict but without luck.
After Checking the join MYSQL Query, it turns out that some of the column names are turned in to "_" on the join, even tho all the fields in the SQL have "AS name" set. on the join result - i can see that the member_name column gets set to "_" which does not look good at all.
The query look like this :
SELECT uid AS id_member, SUBSTRING( uname, 1, 80 ) AS _, user_regdate AS _, SUBSTRING( pass, 1, 64 ) AS passwd, SUBSTRING( IF( name = '', uname, name ) , 1, 255 ) AS _, posts, SUBSTRING( email, 1, 255 ) AS _, SUBSTRING( url, 1, 255 ) AS _, SUBSTRING( url, 1, 255 ) AS _, IF( rank =7, 1, 0 ) AS id_group, SUBSTRING( user_icq, 1, 255 ) AS icq, SUBSTRING( user_aim, 1, 16 ) AS aim, SUBSTRING( user_yim, 1, 32 ) AS yim, SUBSTRING( user_msnm, 1, 255 ) AS msn, SUBSTRING( user_sig, 1, 65534 ) AS signature, IF( user_viewemail = '0', 1, 0 ) AS _, timezone_offset AS _, '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS _, '' AS _, '' AS location, '' AS _, '' AS avatar, '' AS usertitle, '' AS member_ip, '' AS _, '' AS _, '' AS validation_code, '' AS _, '' AS _, '' AS _, '' AS member_ip2
FROM 635yhesf_users u
JOIN 635yhesf_user_profile p ON u.uid = p.profileid
LIMIT 0 , 30
PHP File query is :
SELECT
uid AS id_member, SUBSTRING(uname, 1, 80) AS member_name,
user_regdate AS date_registered, SUBSTRING(pass, 1, 64) AS passwd,
SUBSTRING(IF(name = '', uname, name), 1, 255) AS real_name, posts,
SUBSTRING(email, 1, 255) AS email_address,
SUBSTRING(url, 1, 255) AS website_title,
SUBSTRING(url, 1, 255) AS website_url, IF(rank = 7, 1, 0) AS id_group,
SUBSTRING(user_icq, 1, 255) AS icq, SUBSTRING(user_aim, 1, 16) AS aim,
SUBSTRING(user_yim, 1, 32) AS yim, SUBSTRING(user_msnm, 1, 255) AS msn,
SUBSTRING(user_sig, 1, 65534) AS signature,
user_viewemail = 0 AS hide_email, timezone_offset AS time_offset,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
'' AS personal_text, '' AS location, '' AS time_format, '' AS avatar,
'' AS usertitle, '' AS member_ip, '' AS secret_question, '' AS secret_answer,
'' AS validation_code, '' AS additional_groups, '' AS smiley_set,
'' AS password_salt, '' AS member_ip2
FROM {$from_prefix}users u
JOIN {$from_prefix}user_profile p
ON u.uid=p.profileid;
Could anybody advise on this?
Kind Regards
density5
