IPB 3.3.4 to VB4.2.0 Impex wrong plz help
 

i have convert starting all right, but when import members this wrong:


Quote:
ImpEx Database error

mysql error: Invalid SQL:
SELECT
m.*,
pp.notes, pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type
,pf.field_1 AS aim_name,pf.field_2 AS msnname,pf.field_4 AS icq_number,pf.field_8 AS yahoo
FROM ipb3members AS m
LEFT JOIN ipb3profile_portal AS pp ON (m.member_id = pp.pp_member_id)
LEFT JOIN ipb3pfields_content AS pf ON (m.member_id = pf.member_id)
ORDER BY m.member_id
LIMIT 0, 2000


mysql error: Unknown column 'pp.notes' in 'field list'



i have try this is not working:
plz help me :_)




In upload/impex/systems/ibp3/000.php

Find
PHP Code:
pp.notes, pp.links, pp.bio, pp.ta_size, pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type


Change it to
PHP Code:
pp.notes, pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type


Save and reupload over your current 000 file. and re-run the import from the start.
This is a temporary workaround for the issue if you need to import now. These fields are no longer present in IBP 3.1