Announcement

Collapse
No announcement yet.

IPB 3.3.4 to VB4.2.0 Impex wrong plz help

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • sisterhood
    replied
    Thank you soooo much, great support :-)
    Last edited by sisterhood; Wed 24th Oct '12, 12:38am.

    Leave a comment:


  • Trevor Hannant
    replied
    I cleared your import session and re-ran the Connection, Usergroup and Users modules and they all ran fine - you can continue with the rest of your import now.

    Leave a comment:


  • sisterhood
    replied
    Originally posted by soniceffect View Post
    This error is def fixed when removing PP.Notes. I had the same problem myself when I moved my site over. If I remember rightly there is another field which needs removing as well somewhere down the line.




    @vb when my account transfer from vbulletin-germany.com can i use support ticket?

    - - - Updated - - -

    ok. allright i have support ticket now
    Last edited by sisterhood; Fri 19th Oct '12, 5:34am.

    Leave a comment:


  • soniceffect
    replied
    This error is def fixed when removing PP.Notes. I had the same problem myself when I moved my site over. If I remember rightly there is another field which needs removing as well somewhere down the line.

    Leave a comment:


  • betterthanyours
    replied
    If the file is not there, the error should not be being generated. You might want to seek paid help for this..

    Leave a comment:


  • sisterhood
    replied
    Originally posted by borbole View Post
    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

    Leave a comment:


  • borbole
    replied
    Originally posted by sisterhood View Post
    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.

    Leave a comment:


  • sisterhood
    replied
    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

    Leave a comment:


  • Trevor Hannant
    replied
    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?

    Leave a comment:


  • sisterhood
    replied
    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'

    Leave a comment:


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

    Leave a comment:


  • sisterhood
    replied
    Originally posted by Trevor Hannant View Post
    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}
    ");

    Leave a comment:


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

    Leave a comment:


  • sisterhood
    replied
    Originally posted by Trevor Hannant View Post
    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'

    Leave a comment:


  • Trevor Hannant
    replied
    Can you post that complete section of the file here please

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X