Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Is 4.x-dev supposed to work with phpbb3 or phpbb2 only?
I'm asking because tables on this version are wrong for phpbb3, they are clearly phpbb2's.
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'phpbb3_categories' doesn't exist
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'phpbb3_posts_text' doesn't exist
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'phpbb3_posts_text' doesn't exist
I guess I should use 3.x
Comments
Comment #1
mikeryanIn the phpBB migration configuration, did you set the PHPDB Table Prefix to phpbb3_? What are the actual table names in your database?
Comment #2
challenge CreditAttribution: challenge commentedeverything imported fine running version 3.x.
----------------------------------------------------------
back on 4.x dev:
tables in forum's DB use "phpbb3_" prefix, so I set them like that.
"brainstorming" is database name, "phpbb" is name of migration.
migration page shows this:
if I run the migration:
You see it's searching for phpbb2 tables? I mean posts_text is a phpbb2 table, that on phpbb3 has another name. Same for categories table, it doesn't exist on phpbb3, I don't remember how they are stored but phpbb2drupal v3 import all correctly, so something happened on 4.x
Comment #3
CWSmith1701 CreditAttribution: CWSmith1701 commentedI'm getting the same issue on mine with 2 phpbb forums to import, both on seperate databases, both installed phpbb3. THe prefix for them is phpbb_. But all I get when I run drush ms is this.
I'm using migrate 7.x-2.6-rc1+13-dev with phpbb2drupal 7.x-4.x-dev
Comment #3.0
CWSmith1701 CreditAttribution: CWSmith1701 commented.
Comment #4
erwangel CreditAttribution: erwangel commentedHere are some changes I made in order to have 7-x-4.x-dev work with phpBB3:
First, I hade to tell it that phpBB version was 3 (it's internal detection mechanism did't work in my case). So
1) in phpbb2drupal.inc around line 32 (function __construct):
2) and around line 215 (function registerMigrations):
3) in file phpbb2drupal_core.inc around line 112 (PhpbbUserMigration/function query):
4) and finally around line 853 (PhpbbPostMigration/function query)
Be aware, this is a dirty solution, just for my needs. Hope it helps others in their migration or make one day this module work
Comment #5
amh5514 CreditAttribution: amh5514 commented@mikeryan
I hope you haven't given up on this. To answer you questions
No, the table prefix name is "phpbb_".
And here are my phpbb3 tables: (I hope this helps)
phpbb_acl_groups
phpbb_acl_options
phpbb_acl_roles
phpbb_acl_roles_data
phpbb_acl_users
phpbb_attachments
phpbb_banlist
phpbb_bbcodes
phpbb_bookmarks
phpbb_bots
phpbb_config
phpbb_confirm
phpbb_disallow
phpbb_drafts
phpbb_extensions
phpbb_extension_groups
phpbb_forums
phpbb_forums_access
phpbb_forums_track
phpbb_forums_watch
phpbb_groups
phpbb_icons
phpbb_lang
phpbb_log
phpbb_moderator_cache
phpbb_modules
phpbb_poll_options
phpbb_poll_votes
phpbb_posts
phpbb_privmsgs
phpbb_privmsgs_folder
phpbb_privmsgs_rules
phpbb_privmsgs_to
phpbb_profile_fields
phpbb_profile_fields_data
phpbb_profile_fields_lang
phpbb_profile_lang
phpbb_ranks
phpbb_reports
phpbb_reports_reasons
phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch
phpbb_sessions
phpbb_sessions_keys
phpbb_sitelist
phpbb_smilies
phpbb_styles
phpbb_styles_imageset
phpbb_styles_imageset_data
phpbb_styles_template
phpbb_styles_template_data
phpbb_styles_theme
phpbb_topics
phpbb_topics_posted
phpbb_topics_track
phpbb_topics_watch
phpbb_users
phpbb_user_group
phpbb_warnings
phpbb_words
phpbb_zebra
Comment #6
amh5514 CreditAttribution: amh5514 commentedComment #7
amh5514 CreditAttribution: amh5514 commented