Announcement

Collapse
No announcement yet.

users as guests and not all posts where converted over

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

  • users as guests and not all posts where converted over

    I just did the conversion from ipb board 3.3 to vbulletin 3.8 and all the users are showing up as guests and also i only was able to bring over 5000 posts when my ipb forum has over 10k in posts.Really need some help please

    - - - Updated - - -

    I just went back to the import and tried to import the users again and i get this error

    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, 70


    mysql error: Unknown column 'pp.notes' in 'field list'

    mysql error number: 1054

    Date: Monday 16th 2012f July 2012 09:22:11 PM
    Database: chatters_oldf
    MySQL error: Unknown column 'pp.notes' in 'field list'
    - - - Updated - - -

    Is anyone able to give any advice please on this so i can close my other forum down before people start posting on there.Thank you so much

  • #2
    In upload/impex/systems/ibp3/000.php, find:

    Code:
     pp.notes, pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type 


    And remove pp.notes,

    Should look like this when done
    Code:
          pp.signature, pp.avatar_location, pp.avatar_size, pp.avatar_type  
    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)
    - Highlight the correct navigation tab when you are on a custom page
    - "Quick Route" Interface...
    - Allow to use custom icons for individual forums

    Comment


    • #3
      I just did tht but now it will not let me into the import it is coming up with a error but it is too quick to let me see what the error is

      Comment

      Loading...
      Working...
      X