Error Converting from phpBB to SMF

[Cougra]

I'm trying to convert from a phpBB forum and I'm getting this 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.

The error MySQL gave was: Access denied for user: 'dbo15xxxx038@%' to database 'db15xxxx306'

I'm assuming that this is because I need to have the same database user on both the phpBB database and the SMF database however I do NOT have the ability to do that with the host that I'm using as they assign the database names and the database user names.

Is there ANY way that I can alter the coding in files or anything to get around this issue?

[H]

The problem is that the SMF database user does not have MySQL permissions to access the phpbb database.

That should solve your problem.

[Fizzy]

You could try reading your phpbb DB connection and password details from the config.php file in phpbb and then use that as the connection detail for SMF.
That will install SMF in to the same DB as your phpbb.
Just make sure that you set the SMF table Prefix to smf_ and you should be able to set up and run SMF alongside phpbb and also convert without any problems

[Cougra]

Sorry it took so long to reply.  Anyway, I've finally gotten around to attempting to convert the files once again.  I have a SMF forum running on the same database as the phpBB forum howver when I attempted to run the converter I got this error:

Code Select Expand

Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `db152412306`.smf_messages
(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, posterEmail, subject, posterName, smileysEnabled, modifiedTime, posterIP, body, ID_BOARD)
VALUES ('17901', '1099', '1096151819', '28', '[email protected]', 'Eragon', 'LadyDeath', '1', '', '68.136.80.184', 'That\'s nice.....yeah I think he will mature with his writing as he gets older.
<br />

...

<br />I did say that as a little bit of a joke but yes historically I think the Scottish were more puritanical not sure why. The English had a few to Oliver Cromwell being one of the noteable ones.', '9');
Caused the error:

Duplicate entry '17901' for key 1

Any idea what this means?

[Fizzy]

Basically it's saying that it is trying to add Message 17901 but it can't because it already exists. The convertor will stop if there is a duplicate Message number because every Message should be unique.

Can you check in the phpbb Message tables and see if there are two entries with that same Message ID number. If so, you could try renumbering the Message to something like 917901, run the convertor again (hopefully successfully) and then use SMF Admin Panel's Forum Maintenance options to correct the Message with index 917901.