IPB 3.3.4 to VB4.2.0 Impex wrong plz help

[sisterhood]

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

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

[Trevor Hannant]

Try removing pp.notes given that it can't find that...

[sisterhood]

i have try........then nothing happened......

[Trevor Hannant]

Can you post that complete section of the file here please

[sisterhood]

The orginal thread is this:

https://www.vbulletin.com/forum/showthread.php/373759-Unknown-column-pp-links-in-field-list-%28IPB-3-1-4-gt-vB-3-8-6-PL1%29?p=2120825&viewfull=1#post2120825

i have the same problem and i remove pp.notes and nothing happens. no user import

[Trevor Hannant]

Can you post that complete section of the file here please

[sisterhood]

Can you post that complete section of the file here please

??


i have only this message:


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'

[Trevor Hannant]

Please post the section of file impex/systems/ibp3/000.php that you have changed.

[sisterhood]

Please post the section of file impex/systems/ibp3/000.php that you have changed.

Original:

$details_list = $Db_object->query("
SELECT
m.*,
pp.notes, pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type
" . (!empty($pfarray) ? ',' . implode(',', $pfarray) : '') . "
FROM {$tableprefix}members AS m
LEFT JOIN {$tableprefix}profile_portal AS pp ON (m.member_id = pp.pp_member_id)
" . (!empty($pfarray) ? "LEFT JOIN {$tableprefix}pfields_content AS pf ON (m.member_id = pf.member_id)" : '') . "
ORDER BY m.member_id
LIMIT {$start_at}, {$per_page}
");

my changes without pp.notes

$details_list = $Db_object->query("
SELECT
m.*,
pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type
" . (!empty($pfarray) ? ',' . implode(',', $pfarray) : '') . "
FROM {$tableprefix}members AS m
LEFT JOIN {$tableprefix}profile_portal AS pp ON (m.member_id = pp.pp_member_id)
" . (!empty($pfarray) ? "LEFT JOIN {$tableprefix}pfields_content AS pf ON (m.member_id = pf.member_id)" : '') . "
ORDER BY m.member_id
LIMIT {$start_at}, {$per_page}
");

[Trevor Hannant]

So what's your error now - if you've removed pp.notes then you can't be getting that error...

[sisterhood]

sorry but my problem is obvious, why the same question?



when i remove pp.notes freeze the import have always wrong:

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'

[Trevor Hannant]

If you've removed it from the file on your server, you wouldn't be seeing that:

ImpEx Database error

mysql error: Invalid SQL:
SELECT
m.*,
pp.notes, pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type

After making the change, you have uploaded the file back to the right place?

[sisterhood]

i have very very bad english :-(

i have take this file:

impex/systems/ibp3/000.php

edit:

without pp.notes and then return to server.

Import again starting and freeze

[borbole]

i have very very bad english :-(

i have take this file:

impex/systems/ibp3/000.php

edit:

without pp.notes and then return to server.

Import again starting and freeze

Did you overwrite the old file? If you did, then try to re-run the import from the start.

[sisterhood]

Did you overwrite the old file? If you did, then try to re-run the import from the start.

please believe me i have everything try it out....everything, nothings works