Announcement

Collapse
No announcement yet.

Anybody smart enough here to figure this out?

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

  • Anybody smart enough here to figure this out?

    I'm trying to convert my IPB 3 forum to vB3.

    I get this error when trying to import the users:

    There seems to have been a problem with the database.


    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,pf.field_11 AS location
    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: Saturday 08th 2011f October 2011 03:57:22 PM
    Database: *******_****
    MySQL error: Unknown column 'pp.notes' in 'field list'



  • #2
    What version of IPB3?


    (Moved to Impex forum)
    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
      IP.Board 3.2.2

      I did manage to convert the posts, topics, and forums over successfully. Just the members didn't go through.

      Comment


      • #4
        Anybody have any idea?

        Comment


        • #5
          Originally posted by Fratal View Post
          IP.Board 3.2.2

          I did manage to convert the posts, topics, and forums over successfully. Just the members didn't go through.

          not supported...
          -- Web Developer for hire
          ---Online Marketing Tools and Articles

          Comment


          • #6
            Yes, I realize that, but I still went ahead anyway.

            I successfully converted over the posts, topics, and the member's usernames, but I'm missing their profile link/accounts. The error in the OP is displayed when I try to use the Users module.

            Comment


            • #7
              Add the missing field to your database. That is add the notes field to your ipb_profile_portal table.
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API - Full / Mobile
              Vote for your favorite feature requests and the bugs you want to see fixed.

              Comment


              • #8
                Thanks Wayne. By any chance can you give me the instructions on how to do this? What is the exact query I am supposed to type in?

                Comment


                • #9
                  It isn't a vBulletin table but I guess you would use something like:

                  ALTER TABLE `ipb_profile_portal` ADD COLUMN `notes` TEXT NULL;
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud demonstration site.
                  vBulletin 5 API - Full / Mobile
                  Vote for your favorite feature requests and the bugs you want to see fixed.

                  Comment

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