Skip to:
Content
Pages
Categories
Search
Top
Bottom

Importing from phpBB 3.2.1 to bbPress 2.6 RC 3


  • vamshidhar
    Participant

    @vamshidhar

    I am trying to import data from phpBB 3.2.1 to bbPress 2.6 RC 3. I am working on my local machine.
    It is converting Forums, Topics and Replies but Users are not getting imported. Author column is showing as Anonymous.

    While importing below error is showing up

    WordPress database error: [Unknown column ‘profile_fields_data.pf_phpbb_wlm’ in ‘field list’]
    SELECT convert(users.user_id USING “utf8mb4”) AS user_id,convert(users.user_password USING “utf8mb4”) AS user_password,convert(users.user_form_salt USING “utf8mb4”) AS user_form_salt,convert(users.username USING “utf8mb4”) AS username,convert(users.user_email USING “utf8mb4”) AS user_email,convert(profile_fields_data.pf_phpbb_website USING “utf8mb4”) AS pf_phpbb_website,convert(users.user_regdate USING “utf8mb4”) AS user_regdate,convert(profile_fields_data.pf_phpbb_aol USING “utf8mb4”) AS pf_phpbb_aol,convert(profile_fields_data.pf_phpbb_yahoo USING “utf8mb4”) AS pf_phpbb_yahoo,convert(profile_fields_data.pf_phpbb_icq USING “utf8mb4”) AS pf_phpbb_icq,convert(profile_fields_data.pf_phpbb_wlm USING “utf8mb4”) AS pf_phpbb_wlm,convert(profile_fields_data.pf_phpbb_facebook USING “utf8mb4”) AS pf_phpbb_facebook,convert(profile_fields_data.pf_phpbb_googleplus USING “utf8mb4”) AS pf_phpbb_googleplus,convert(profile_fields_data.pf_phpbb_skype USING “utf8mb4”) AS pf_phpbb_skype,convert(profile_fields_data.pf_phpbb_twitter USING “utf8mb4”) AS pf_phpbb_twitter,convert(profile_fields_data.pf_phpbb_youtube USING “utf8mb4”) AS pf_phpbb_youtube,convert(users.user_jabber USING “utf8mb4”) AS user_jabber,convert(profile_fields_data.pf_phpbb_occupation USING “utf8mb4”) AS pf_phpbb_occupation,convert(profile_fields_data.pf_phpbb_interests USING “utf8mb4”) AS pf_phpbb_interests,convert(users.user_sig USING “utf8mb4”) AS user_sig,convert(profile_fields_data.pf_phpbb_location USING “utf8mb4”) AS pf_phpbb_location,convert(users.user_avatar USING “utf8mb4”) AS user_avatar FROM phpbb_users AS users LEFT JOIN phpbb_profile_fields_data AS profile_fields_data USING (user_id) WHERE users.user_type !=2 LIMIT 0, 100

  • You must be logged in to reply to this topic.
Skip to toolbar