I'm trying to migrate my phpBB2 forums to Drupal. I've got a brand new Drupal 6.17 running as well as all the needed modules installed. Drupal & the PhpBB forum are both off-line as per the installation instructions.

When I am trying to Configure the Migration I'm good till I get to "Location of phpBB2". "Phpbb is on the same database as drupal" is checked

It's telling me:

* Table phpbb_categories does not exist!
* Table phpbb_forums does not exist!
* Table phpbb_posts does not exist!
* Table phpbb_posts_text does not exist!
* Table phpbb_topics does not exist!
* Table phpbb_users does not exist!

These tables do exist (else my phpbb2 forum wouldn't be working), and are on the same DB, but I guess a different schema, but I am not sure how to make this module see them. If I uncheck "Phpbb is on the same database as drupal" then I get a path that makes no sense to me at all:

mysql://quocco_drpl1:Qqmy4V2qwEjJ@localhost/quocco_drpl1

And if I change anything in this path the migration fails until I clear the drupal cache.

Can anyone please help me out?

Comments

naheemsays’s picture

naheemsays commented

if you use phpmyadmin to brose to the database, are all those tables shown there?

I would assume you have a different database with your phpbb database. the format of that string is:

"mysql://username:password@localhost/databasename"

(so your first post is showing vital information. if that is anything but a test site, I would advise you to change the username, password etc)

You need to edit it to make sure that the username, password, database name all are for the phpbb database there.

websupportguy’s picture

websupportguy commented

Have you checked the table prefixes in your PHPBB database? Mine are "phpbb2_" by default. Yours might be too. You can probably check this from your phpbb2 config file if it's easier.

In any case, you cannot convert from PHPBB2 to Drupal with the 2.1x converter. You have to use the 1.5x converter and I think it only works with Drupal 5. What I did was to convert to PHPBB3 first, then to Drupal forums.

The converter works OK once you configure correctly - a few things to be wary of:

(1) If the conversion fails for any reason, you may have nowhere to go. So make sure you have a full backup of your Drupal site and database before you start converting so you can roll back and try again if necessary. Can't stress this too much.

(2) There seems to be a problem with the conversion of dates. First time round both my post dates and my member creation dates were reset to the date of conversion. Second time round, with the date converter activated, post dates were OK but member creation dates are 40 years ago. Just can't seem to get it right!

(3) Drupal seems to convert the BB Code to span tags with formatting inside them, which Drupal then strips out. So your converted forum posts will probably end up as single paragraphs with no line breaks or formatting. Mine did. Still working on that.

Tony

naheemsays’s picture

naheemsays commented

@2 - you should only use the date option in there if your newest member joined over 30 years ago (so its not really a useful option). I am not sure why you are getting the error you are with the date conversions however.

@3 - you can choose to have the bbcode tags not converted too, and then you can use the bbcode filter to show the text properly on display.

The 1.x converter also works with drupal 6 (and when I did use this module myself right near when drupal 6 was released, this was the version I used.)

Otherwise, full of good advice.

JeremyFrench’s picture

JeremyFrench commented
Status: Active » Closed (won't fix)

Mass close of D6 issues for this module as won't fix. Please see #1854186: Support for the 6.x branch.