[IMPX-407] IP.Board 3.2.x fails

Category: vBulletin - ImpEx
Viewed: 72 times

ISSUE:
When attempting to run step 4 of Import Users the following SQL Error is triggered

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_3 AS website,pf.field_4 AS icq_number,pf.field_6 AS location,pf.field_7 AS interests,pf.field_8 AS yahoo
FROM members AS m
LEFT JOIN profile_portal AS pp ON (m.member_id = pp.pp_member_id)
LEFT JOIN pfields_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'

mysql error number: 1054

Date: Tuesday 20th 2011f December 2011 06:52:25 PM
Database: aikencen_ipboard
MySQL error: Unknown column 'pp.notes' in 'field list'

Fix:
As per reply 35 of this thread https://www.vbulletin.com/forum/showthread.php/373759-Unknown-column-pp-links-in-field-list-(IPB-3-1-4-gt-vB-3-8-6-PL1)/page3 The Visitors has identified the following fix:

Find
PHP Code:
pp.notes, pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type
And remove pp.notes,

Should look like this when done
PHP Code:
pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type