Converting from phpBB2, located on a different server

[jockel]

Hi,
as other users do, trying to convert from phpBB2 to SMF I run into the very problem
while having phpBB2 in one database/dbuser and the new SMF in an other
database/dbuser, ending up with an error message:
Sorry, the database connection information used in the specified installation
of SMF cannot access the installation of phpBB2. This may either mean that the
installation doesn't exist, or that the MySQL account used does not have permissions
to access it.
Certainly there may be some workaround as already outlined, suitable for more experienced
users. But I would like to know if there will be a conversion script, which is able
to do the migration even in this case, where databases/users/PW of phpBB2 and SMF
are different ?

Best regards
Jockel

[xenovanis]

For as far as I know you'll need both install in the same database or at least have the same users for accessing it.

[jockel]

Yes, I saw this from the message text of the converter. But I think it is quite unlikely for the
average migration, that both forums reside in the same database. Not residing in the same
database also means with my provider that there is another dbuser, as there is a differente
dbuser per database.
I think this is a standard situation! Testing different forum softwares right now, always
requiring to import my old phpbb boards, I found a competitor handling this situation
without a problem and importing from one database/user "A" to database/user "B" without
a problem.

[Grudge]

jockel,

We could modify the converter to do this but it would over complicate things for the user. All you have to do is grant permission for the SMF user to see the phpBB database - cPanel achieves this easily - and if it's not cPanel there *will* be a way. If you're really stuck just backup your phpBB database and import it into your SMF one.

[jockel]

hi grudge,

- I inserted the phpbb2 tables to the same database as my new smf
- modified the config.php so it points to this database
- I installed a fresh phpbb2 and modified all settings so they point to this fresh
installation and to this "common" database

conversion process screen proceeds nicely wihtout any visible errors.
However, nothing is realy inserted into smf?
The only strange thing I noticed, all section in the conversion log screen that
referr to actions like insert, delete, replace, update... are labeled : "database query: (skipped)"

Is there any modification I have to apply to the sdript, so the conversion/import realy takes place ?

[Grudge]

Is it a conversion for 1.1? It sounds like you have debugging on? Did you enable it somehow? (Dubugging doesn't actually do the queries IIRC)

[Trekkie101]

Is it a conversion for 1.1? It sounds like you have debugging on? Did you enable it somehow? (Dubugging doesn't actually do the queries IIRC)

One uploaded copy of convert.php had it on, I believe [Unknown] posted the newer (un-debug-mode) version and attached it.

[jockel]

Hi,

its not that easy to determine the converter version in use, as there is no indication
on when it was last modified. Anyway, I downloaded again and it was working now properly.
Thank you !

Jo