Announcement

Collapse
No announcement yet.

IPB 3.3.1 to vBulletin 4.1.12 Patch Level 1 problem

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

  • IPB 3.3.1 to vBulletin 4.1.12 Patch Level 1 problem

    Getting following error when converting users on IPB 3.3.1 to vBulletin 4.1.12 Patch Level 1 conversion

    Code:
    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: Sunday 29th 2012f April 2012 01:13:56 PM
    Database: trikersu_trikersuk
    MySQL error: Unknown column 'pp.notes' in 'field list'

  • #2
    Can you check your IPB database - is there a column with that name in the members table? Also, what version of Impex is showing at the top of the page?
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      I found this on google

      Code:
      In upload/impex/systems/ibp3/000.php
      
      Find: pp.notes, pp.links, pp.bio, pp.ta_size, pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type  
      
      And then replace that with this : pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type
      It seems to have worked.
      Impex is latest version downloaded yesterday

      Comment


      • #4
        This is correct. Had to do it with mine also.
        Husky Owners Forum - For all Siberian Husky Owners

        Comment

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