Import Problem IP.Board 3.4.4 to vbulletin 4.2.1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • naveedali
    New Member
    • May 2013
    • 5
    • 4.2.X

    Import Problem IP.Board 3.4.4 to vbulletin 4.2.1

    hello. I've been trying for four days ، And I have tried to get help from the vb team ( Ticketid: 1196225 ) Zachery Woods , But my problem is still not resolved.

    i have IP.Board 3.4.4 i want to Import in vbulletin 4.2.1 but i facing many error.

    1. Import user.
    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, 100
                
    
    mysql error: Unknown column 'pp.notes' in 'field list'
    
    mysql error number: 1054
    
    Date: Saturday 25th 2013f May 2013 06:46:50 AM
    Database: xxxx_xxbMinDB
    MySQL error: Unknown column 'pp.notes' in 'field list'
  • BirdOPrey5
    Senior Member
    • Jul 2008
    • 9613
    • 5.6.3

    #2
    I would just add the column pp.notes to your existing IP Board database. It will be empty but as long as the column exists you won't get this error.

    Comment

    • naveedali
      New Member
      • May 2013
      • 5
      • 4.2.X

      #3
      how to add this column pp.notes ?

      Comment

      • naveedali
        New Member
        • May 2013
        • 5
        • 4.2.X

        #4
        And the first issue is Associate Users ۔ i have 15,+++ Members how to add one by one ?

        Comment

        • naveedali
          New Member
          • May 2013
          • 5
          • 4.2.X

          #5
          oky.

          Find
          PHP Code:
          pp.notespp.signaturepp.avatar_locationpp.avatar_sizepp.avatar_type 
          And remove pp.notes,

          Should look like this when done
          PHP Code:
          pp.signaturepp.avatar_locationpp.avatar_sizepp.avatar_type 
          [/QUOTE]

          http://www.vbulletin.com/forum/forum...-8-6-pl1/page3

          Thanks working fine, my user imprt.

          Now my problem on posts. i have 52,327 Total Posts . this imprt 68.75%. 14806 only. Now Stop . what i do ?
          Last edited by naveedali; Sun 26 May '13, 4:53am.

          Comment

          • BirdOPrey5
            Senior Member
            • Jul 2008
            • 9613
            • 5.6.3

            #6
            There is an ipe option to wipe the import data and start again.

            Comment

            • naveedali
              New Member
              • May 2013
              • 5
              • 4.2.X

              #7
              Originally posted by Joe D.
              There is an ipe option to wipe the import data and start again.
              again same error .. 68.75%.

              Comment

              • snakes1100
                Senior Member
                • Aug 2001
                • 1249

                #8
                If i recall, its been sometime, but you will also have to make another fix for this import to work, cant recall the field name tho thats triggering it, check your server logs & also display_errors in php.ini
                Gentoo Geek

                Comment

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