Announcement

Collapse
No announcement yet.

Import Problem IP.Board 3.4.4 to vbulletin 4.2.1

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

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

  • #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


    • #3
      how to add this column pp.notes ?

      Comment


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

        Comment


        • #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 26th May '13, 4:53am.

          Comment


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

            Comment


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

              Comment


              • #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...
                X