Hello!

The phpBB2Drupal is thoroughly broken when using postgresql. Two issues arose while I was playing with this:

1. If the phpBB installation is MySQL and the Drupal installation is postgresql, there is a failure as soon as one specifies that phpbb is at another db address (with URL). This is a drupal issue, and people are trying to Allow both postgresql and mysql database connections from within the same site.

2. If the phpBB and Drupal installations both use postgresql, the program fails at the point where it begins migration, since it cannot properly create the temporary tables.

Any advice on how to proceed?

tarek : )

Comments

beginner’s picture

beginner commented

I'd be happy to commit a working patch if you can provide one.

On your first point, since it is a Drupal core issue, there's little we can do about it. The user would have to find another way to import the whole phpBB database from mysql to postgresql or vice versa before attempting the migration. That's something to put in the documentation.

On your second point, there are four CREATE TABLE statements. If you give me the proper syntax, I'm sure we can patch this together.

beginner’s picture

beginner commented

I updated today so that the CREATE TABLE statement is not within the module, but in a separate install file. If you give me the proper postgresql syntax to create the tables, I'll add it. With that, phpBB/postgresql -> Drupal/postgresql should work.

tarek’s picture

tarek commented

Thank you.

Will submit asap.

tarek : )

beginner’s picture

beginner commented
Status: Active » Fixed

just updated the install file, but I cannot test it.
Tarek, when you get some time, can you check if it works? Thanks.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
Virtya’s picture

Virtya commented
Title: Does not work when Drupal uses Postgresql » Does not work when Drupal uses mySQL
Version: master » 6.x-1.0
Assigned: Unassigned » Virtya
Category: bug » feature
Status: Closed (fixed) » Postponed (maintainer needs more info)

how do I fix this?
Note that due to a limitation within Drupal core, we cannot import messages from one database type to another database type. E.g, we cannot import phpBB from a myqsl DB, to a postgresql DB. You need to import the data into the same type of database first (import all the phpBB data, as is, from mysql to postgresql.

naheemsays’s picture

naheemsays commented
Title: Does not work when Drupal uses mySQL » phpBB2Drupal does not work with multiple database types
Status: Postponed (maintainer needs more info) » Closed (won't fix)

This module uses drupal to manage the connections. Currently, Drupal can only connect to one type of database.

This *may* change with Drupal 7, which is quite a long time to wait.

In the mean time, it would be easier to either:

1. Use Drupal on the same database type as the phpBB forum.
2. convert the data from one database type to the other so that both are on the same database type.

This issue IMO is not in scope of this module.