Converting topics...Unsuccessful!

[Ada]

SMF Version: SMF 1.1
PHPBB: 2.0.21
Using: smf_1-1_phpbb2_converter.tar.gz

Hello I'm trying to convert my PHPBB forum to SMF but I keep getting a duplicate entry error. As you can see I have quite a few entries, so is there an easy way to fix this? (Edited to truncate some of the code)

Code Select Expand


Converting...
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

INSERT INTO `smf`.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 ('21045', '0', '147923', '147975', '2559', '2559', '100', '', '0', '3', '78'),
('21046', '0', '147924', '147978', '3585', '2484', '79', '', '0', '6', '99'),
('21047', '0', '147938', '147938', '3039', '3039', '114', '', '0', '0', '12'),
('21048', '1', '147942', '150320', '3035', '3035', '82', '', '1', '1', '124'),
('21050', '0', '147965', '147965', '21', '21', '129', '', '0', '0', '163'),
('21051', '0', '147974', '148017', '1721', '3587', '109', '', '0', '1', '47'),
('21052', '0', '147980', '147996', '696', '2654', '38', '', '0', '3', '147'),
('21054', '0', '147995', '148052', '3766', '3677', '129', '', '0', '2', '207'),
('21055', '0', '147999', '148002', '3363', '2204', '38', '', '0', '1', '112'),
('21057', '0', '148006', '150484', '59', '59', '38', '', '0', '23', '1516'),
('21059', '0', '148020', '148022', '3777', '3035', '81', '', '1', '2', '264'),
('21060', '0', '148023', '148492', '2335', '3186', '119', '', '0', '23', '82'),
('21061', '0', '148024', '148772', '2572', '2853', '79', '', '0', '27', '472'),
('21062', '0', '148029', '149739', '3778', '3186', '117', '', '0', '11', '644'),
('21063', '0', '148032', '148838', '3196', '2698', '1', '', '0', '10', '612'),
('21065', '0', '148049', '148049', '1327', '1327', '38', '', '0', '0', '105'),
('21066', '0', '148055', '150029', '2358', '3532', '63', '', '0', '32', '2066'),
('21068', '0', '148072', '148215', '3660', '2834', '46', '', '0', '9', '149'),
('21069', '0', '148075', '151899', '3587', '3587', '109', '', '0', '9', '120'),
('21070', '0', '148077', '148088', '2841', '2862', '48', '489', '0', '2', '14'),
('21071', '0', '148078', '148087', '2841', '2862', '48', '490', '0', '2', '14'),
('21072', '0', '148085', '148089', '2559', '2862', '48', '', '0', '1', '15'),
('21073', '0', '148105', '148105', '2123', '2123', '112', '', '0', '0', '47'),
('21074', '0', '148106', '148784', '2841', '3196', '112', '', '0', '8', '117'),
('21075', '0', '148107', '148789', '2841', '2698', '112', '', '0', '22', '207'),
('21081', '0', '148131', '148176', '3039', '994', '79', '', '0', '5', '108'),
('21082', '0', '148141', '148141', '2572', '2572', '104', '', '0', '0', '42'),
('21083', '0', '148143', '148167', '1707', '1707', '100', '', '0', '2', '50'),
('21084', '0', '148148', '148161', '3758', '1719', '123', '', '0', '1', '180'),
('21085', '0', '148152', '150795', '3781', '3781', '81', '', '0', '6', '679'),
('21086', '0', '148154', '149207', '2183', '2710', '38', '', '0', '4', '169'),
...
     ('21813', '0', '152874', '153258', '1719', '3313', '122', '', '0', '2', '47'),
    ('21814', '0', '152884', '153082', '3035', '2075', '138', '', '0', '17', '200'),
    ('21815', '0', '152893', '152971', '2841', '2841', '48', '', '0', '6', '35'),
    ('21816', '0', '152900', '152900', '2611', '2611', '102', '', '0', '0', '10'),
    ('21818', '0', '152920', '153071', '2420', '2841', '46', '', '0', '6', '126'),
    ('21825', '0', '152939', '153419', '2183', '2183', '1', '', '0', '17', '1199'),
    ('21826', '0', '152951', '153058', '2385', '2698', '2', '', '0', '10', '83'),
    ('21829', '0', '152970', '153063', '2841', '2710', '112', '', '0', '4', '126'),
    ('21830', '0', '152977', '153102', '2862', '1610', '112', '509', '0', '15', '237'),
    ('21831', '0', '152980', '153051', '2747', '108', '63', '', '0', '12', '640'),
    ('21832', '0', '152999', '152999', '1775', '1775', '79', '', '0', '0', '50'),
    ('21833', '0', '153000', '153242', '1219', '3313', '122', '', '0', '2', '30'),
    ('21834', '0', '153005', '153007', '3196', '108', '38', '', '0', '1', '138'),
    ('21835', '0', '153020', '153020', '2484', '2484', '79', '', '0', '0', '66'),
    ('21837', '0', '153042', '153283', '3363', '108', '38', '', '0', '2', '213'),
    ('21840', '0', '153070', '153107', '2696', '1707', '46', '', '0', '1', '57'),
    ('21841', '0', '153098', '156884', '3726', '3793', '130', '', '0', '11', '102'),
    ('21842', '0', '153100', '153277', '1040', '2710', '38', '', '0', '17', '924'),
    ('21843', '0', '153116', '153263', '2484', '2183', '38', '', '0', '8', '386'),
    ('21844', '0', '153121', '153284', '3196', '2183', '38', '', '0', '4', '186'),
    ('21845', '0', '153123', '153259', '3363', '3103', '96', '', '0', '4', '112');

Caused the error:

    Duplicate entry '135241-46' for key 3


[Oldiesmann]

Try this one.

[starenka]

thx bro. this is helpfull. good job

[Analogiker]

THX!!!

converted a phpBB 2.0.19 plusxl20 to SMF_1-1-2

[A_Lua]

i use this one it worcks ok but  it give many times outs, so i delet all tabels from phpbb, and only put them as the convert asck, but i have a problem, wen i put phpbb_banlist in my sql it brocks and i cant conver any more... convert asck for

Converting banned users... Unsuccessful!
This query:
SELECT ban_id, ban_userid, ban_ip, ban_email
FROM `microluso_com_1`.phpbb_banlist
LIMIT 0, 250;

im my sql backup i have

DROP TABLE IF EXISTS phpbb_banlist;
CREATE TABLE phpbb_banlist(
   ban_id mediumint( unsigned NOT NULL auto_increment,
   ban_userid mediumint( NOT NULL,
   ban_ip varchar( NOT NULL,
   ban_email varchar(255),
   ban_until int(11) NOT NULL,
   ban_reason varchar(255) NOT NULL,
   PRIMARY KEY (ban_id),
   KEY ban_ip_user_id (ban_ip, ban_userid)
);


But if i usse this setings it gives me time out 

any help?

ty

[JayBachatero]

Is this issue solved?