Originally posted by Steve Machol
ImpEx Database error
mysql error: Invalid SQL:
SELECT
m.*,
pp.notes, pp.links, pp.bio, pp.ta_size, 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 canuckco_members AS m
LEFT JOIN canuckco_profile_portal AS pp ON (m.member_id = pp.pp_member_id)
LEFT JOIN canuckco_pfields_content AS pf ON (m.member_id = pf.member_id)
ORDER BY m.member_id
LIMIT 0, 2000
mysql error: Unknown column 'pp.links' in 'field list'
mysql error number: 1054
Date: Thursday 17th 2011f February 2011 08:47:10 PM
Database: ****
MySQL error: Unknown column 'pp.links' in 'field list'
mysql error: Invalid SQL:
SELECT
m.*,
pp.notes, pp.links, pp.bio, pp.ta_size, 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 canuckco_members AS m
LEFT JOIN canuckco_profile_portal AS pp ON (m.member_id = pp.pp_member_id)
LEFT JOIN canuckco_pfields_content AS pf ON (m.member_id = pf.member_id)
ORDER BY m.member_id
LIMIT 0, 2000
mysql error: Unknown column 'pp.links' in 'field list'
mysql error number: 1054
Date: Thursday 17th 2011f February 2011 08:47:10 PM
Database: ****
MySQL error: Unknown column 'pp.links' in 'field list'
Have you a solution or work-around for this? Perhaps something has changed in IPB since 3.1.1 and impex needs to be updated maybe? IDK - but hopefully there is a easy solution for this!
Thanks,
Jacquii.
Comment