Skip to:

Opened 5 years ago

Closed 5 years ago

#2979 closed defect (bug) (invalid)

BBpress 2.6 alpha – problem importing phpBB

Reported by: senatorman Owned by:
Milestone: Priority: normal
Severity: normal Version:
Component: API - Importers Keywords: needs-patch reporter-feedback



I’ve been trying as suggested bbpress 2.6 alpha but the PhpBB import fails right at the beginning.
I’ve been already importing successfully by using the latest 2 versions and I’ve never faced this error before

directly at the begin i get this error:

WordPress databasefout: [Unknown column 'profile_fields_data.pf_phpbb_website' 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

Change History (4)

#1 @senatorman
5 years ago

  • Keywords needs-patch removed
  • Milestone changed from Awaiting Review to 2.6

#2 @netweb
5 years ago

  • Component changed from General to API - Importers
  • Keywords needs-patch reporter-feedback added
  • Priority changed from high to normal

Thanks for the ticket @senatorman, what version of phpBB are you importing from?

#3 follow-up: @senatorman
5 years ago

i using 3.0.13-PL1

The latest version is 3.0.14

#4 in reply to: ↑ 3 @netweb
5 years ago

  • Milestone 2.6 deleted
  • Resolution set to invalid
  • Status changed from new to closed

Replying to senatorman:

i using 3.0.13-PL1

The latest version is 3.0.14

The latest version is 3.1.9

I previously updated to the phpBB 3.1.x branch in #2716, as part of that update support for importing from 3.0.x was removed. Its fairly straight forward to upgrade phpBB, see for details

Note: See TracTickets for help on using tickets.