IPB 3.4.6 -> vBulletin 4.2.2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • `Tyluur
    Member
    • Mar 2011
    • 55
    • 3.8.x

    IPB 3.4.6 -> vBulletin 4.2.2

    Hello, I am trying to convert the members from my previous IPB forum to my new vBulletin forum, but I am running into some issues. I uploaded the impex folder, renamed the config file, added my database information (the databases are stored on the same local server, just different prefixes), and transported to ACP -> Import -> Import. This is the error which I get

    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 ipb_members AS m
                    LEFT JOIN ipb_profile_portal AS pp ON (m.member_id = pp.pp_member_id)
                    LEFT JOIN ipb_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: Monday 28th 2014f July 2014 07:52:22 AM
    Database: lazarus_ipb
    MySQL error: Unknown column 'pp.notes' in 'field list'
    Last edited by `Tyluur; Mon 28 Jul '14, 4:53am.
  • Rafa-el
    Member
    • Feb 2010
    • 54
    • 4.0.x

    #2
    Both, IPB and vBulletin database should go on different databases, if you use the same database for both, even with different prefixes only, that shouldn't work fine.
    Jesus is coming. Are you ready?

    Comment

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