News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

phpBB2 to SMF Converter

Started by koyboy, August 14, 2005, 12:49:24 PM

Previous topic - Next topic

koyboy

I am getting the following error when I trying to convert my php message board to SMF:

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.

[Unknown]

Try installing SMF and phpBB in the same database with the same MySQL account.

-[Unknown]

Vaidy

Hi,

I converted successfully but a particular new topic, which I actually moved in phpBB to a different location, is not getting converted successfully. I am getting this message:

QuoteConverting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `animatio`.smf_topics
(ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
VALUES ('3', '0', '4', '4', '2', '2', '1', '', '0', '0', '61'),
('2', '0', '2', '3', '2', '2', '2', '', '0', '1', '21'),
('4', '0', '5', '5', '2', '2', '4', '', '0', '0', '118'),
('5', '0', '6', '6', '2', '2', '4', '', '0', '0', '57'),
('7', '0', '8', '8', '2', '2', '17', '', '0', '0', '20'),
('18', '0', '21', '21', '2', '2', '25', '', '0', '0', '21'),
('19', '0', '22', '34', '42', '26', '13', '', '0', '1', '37'),
('10', '0', '11', '11', '2', '2', '11', '', '0', '0', '23'),
('11', '0', '12', '12', '2', '2', '3', '', '0', '0', '21'),
('20', '0', '23', '23', '2', '2', '25', '', '0', '0', '31'),
('14', '0', '15', '15', '2', '2', '8', '', '0', '0', '9'),
('17', '0', '18', '30', '2', '2', '24', '', '0', '2', '74'),
('16', '0', '17', '17', '2', '2', '23', '', '0', '0', '16'),
('21', '0', '24', '24', '40', '40', '24', '', '0', '0', '26'),
('22', '0', '25', '35', '2', '63', '24', '1', '0', '2', '52'),
('23', '0', '26', '26', '26', '26', '24', '', '0', '0', '12'),
('27', '0', '32', '32', '2', '2', '26', '', '0', '0', '21'),
('26', '0', '31', '31', '2', '2', '25', '', '0', '0', '14'),
('28', '0', '33', '33', '2', '2', '27', '', '0', '0', '24'),
('29', '0', '36', '36', '2', '2', '28', '', '0', '0', '11'),
('30', '0', '37', '40', '2', '48', '28', '2', '0', '1', '32'),
('31', '0', '38', '44', '40', '4', '25', '', '0', '2', '40'),
('32', '0', '41', '41', '2', '2', '29', '', '0', '0', '10'),
('33', '0', '42', '47', '7', '2', '27', '', '0', '2', '24'),
('34', '0', '45', '45', '40', '40', '25', '', '0', '0', '15'),
('35', '0', '46', '52', '40', '2', '25', '', '0', '2', '34'),
('36', '0', '49', '51', '2', '2', '29', '', '0', '1', '15'),
('37', '0', '50', '50', '25', '25', '13', '', '0', '0', '40'),
('38', '0', '50', '50', '25', '25', '7', '', '0', '0', '7'),
('39', '0', '50', '50', '25', '25', '13', '', '0', '0', '14'),
('40', '0', '50', '50', '25', '25', '13', '', '0', '0', '32');
Caused the error:

Duplicate entry '50-13' for key 3

Please help. Thanks.

[Unknown]

SMF doesn't work if multiple topics contain the same posts, which is what's happening there.

Topics 37, 38, 39, and 40 all have post 50 as their first and last post.

-[Unknown]

Vaidy

Thanks mate. Now, if I delete the topic and posts in question, will it help?

If yes, where and how do I delete the topics and posts? Should it be enough to do it on the phpBB or should I go to the database and do it?

npereira

this happened to me aswell, I just continued on and put a message on the board saying some post where lost in the transition, and we where VERY sorry.... ;D


[Unknown]

Quote from: Vaidy on September 07, 2005, 09:07:47 AM
Thanks mate. Now, if I delete the topic and posts in question, will it help?

If yes, where and how do I delete the topics and posts? Should it be enough to do it on the phpBB or should I go to the database and do it?

That, or just post a reply to each of those topics.

-[Unknown]

Quinn

#7
Quote from: koyboy on August 14, 2005, 12:49:24 PM
I am getting the following error when I trying to convert my php message board to SMF:

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.


I get the same message even after importing the SMF database into the phpBB database, as suggested. 

phpBB - 2.0.17
SMF - 1.0.5

This might be interesting should the converter finally run... there are 5 phpbb boards in one database... all tables are specific to the install ie: phpbb, phpbb1, phpbb2 etc.
Except the users, groups, user_groups, sessions, ranks, confirmation tables have no prefix_


DispatcherEMTB

Good luck I have Rich Text Editor and Attachment mod installed on my phpBB .17 and its been trying to convert all my stuff for the 1.1 beta 3.

and its not working, still i even tried the converter and sql file that [unknown] posted for me to use. :(

[Unknown]

Quote from: Quinn on September 07, 2005, 04:07:14 PM
This might be interesting should the converter finally run... there are 5 phpbb boards in one database... all tables are specific to the install ie: phpbb, phpbb1, phpbb2 etc.
Except the users, groups, user_groups, sessions, ranks, confirmation tables have no prefix_

This might be why you are getting the message.  The converter was not designed for that; it expects the users table to have the prefix specified in config.php (or, the configuration file, if that's not right.)

Are you mainly interested in the members, or one of the forums?  Or are you trying to convert them all?

-[Unknown]

Quinn

Great thanks for pointing me in the right direction...

I will rename the phpbb_tables for the users then and see how it goes...I want the main phpbb_users, phpbb_ groups anyway since they are the same for the other 4..

I can rework them easily if this is all it wants. Gotta love myphpadmin!

I converted another phpbb site over last nite and no problems with the attachments, it went beautifully and only took about 20 minutes to do it all!


Quinn

#11
Thanks for the insight, [Unknown] that worked like a charm... ;)

I re-added the table prefix_ and did a almost perfect migration. I have a signature that uses the bbc
tag that didn't make  the conversion but a very minor problem considering everything else came over un-molested

Vaidy

Quote from: [Unknown] on September 07, 2005, 12:02:07 PM
That, or just post a reply to each of those topics. [Unknown]

Thanks again mate. It works like a dream!

DispatcherEMTB

so can anyone help me figure out why mine is not migrating? i have a topic posted [unknown] was in contact now suddenly he hasn't had anymore contact.

Advertisement: