News:

Want to get involved in developing SMF? Why not lend a hand on our GitHub!

Main Menu

Convert Phpbb 2.0.21 to Smf 1.1 final

Started by Arcana, December 18, 2006, 07:14:18 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Arcana

December 18, 2006, 07:14:18 AM
SMF Version: SMF 1.1 Final
Phbb version: 2.0.21

Hello,

I decieded to try convert my forum phpbb to SMF 

But when trying to convert my current db, it just gives me different errors.


Code Select
Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members...
Warning: copy(/home/web/www.discontinuivvfmarche.it/website/images/avatars/131094726452c0fed52d8d.gif) [function.copy]: failed to open stream: No such file or directory in /home/web/www.discontinuivvfmarche.it/website/smf/convert.php(816) : eval()'d code on line 35
Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    INSERT INTO `discontinuivvfmarche`.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 ('5', '0', '6', '113', '4', '33', '11', '', '0', '8', '145'),
    ('7', '0', '10', '402', '2', '4', '5', '', '0', '9', '194'),
    ('9', '0', '19', '21', '2', '4', '4', '', '0', '2', '24'),
    ('11', '0', '23', '23', '2', '2', '1', '', '0', '0', '262'),
    ('12', '0', '26', '26', '2', '2', '4', '', '0', '0', '35'),
    ('13', '0', '27', '247', '2', '4', '4', '', '0', '12', '68'),
    ('14', '0', '30', '203', '9', '9', '2', '', '0', '11', '90'),
    ('16', '0', '42', '224', '4', '4', '11', '', '0', '4', '97'),
    ('17', '0', '45', '640', '10', '74', '3', '', '0', '25', '347'),
    ('20', '0', '62', '857', '4', '74', '5', '', '0', '39', '507'),
    ('21', '0', '67', '67', '2', '2', '9', '', '0', '0', '183'),
    ('22', '0', '68', '516', '2', '2', '9', '', '0', '5', '170'),
    ('23', '0', '71', '352', '-1', '15', '3', '', '0', '8', '156'),
    ('25', '0', '75', '231', '22', '10', '3', '', '0', '8', '132'),
    ('26', '0', '79', '526', '14', '14', '8', '', '0', '26', '240'),
    ('28', '0', '108', '754', '4', '79', '3', '', '0', '16', '206'),
    ('29', '0', '120', '979', '4', '61', '10', '', '0', '11', '88'),
    ('30', '0', '121', '223', '14', '4', '8', '', '0', '1', '61'),
    ('32', '0', '154', '1012', '13', '4', '5', '', '0', '91', '995'),
    ('33', '0', '161', '208', '2', '2', '11', '', '0', '4', '47'),
    ('34', '0', '163', '676', '-1', '2', '9', '', '0', '15', '220'),
    ('36', '0', '194', '372', '2', '4', '4', '', '0', '8', '35'),
    ('38', '0', '204', '286', '44', '2', '3', '', '0', '18', '340'),
    ('42', '0', '212', '596', '17', '17', '3', '', '0', '22', '353'),
    ('43', '0', '220', '313', '2', '10', '11', '', '0', '8', '118'),
    ('45', '0', '204', '226', '44', '', '3', '', '0', '10', '100'),
    ('47', '0', '251', '254', '2', '4', '4', '', '0', '1', '14'),
    ('51', '0', '264', '575', '7', '15', '3', '', '0', '29', '362'),
    ('53', '0', '296', '753', '10', '61', '5', '', '0', '10', '102'),
    ('58', '0', '321', '445', '10', '62', '3', '', '0', '5', '112'),
    ('59', '0', '323', '324', '38', '2', '2', '', '0', '1', '20'),
    ('60', '0', '325', '478', '22', '10', '3', '', '0', '9', '139'),
    ('62', '0', '338', '353', '2', '15', '11', '', '0', '4', '55'),
    ('63', '0', '343', '490', '10', '2', '5', '', '0', '6', '129'),
    ('64', '0', '347', '360', '4', '2', '11', '', '0', '1', '79'),
    ('65', '0', '348', '740', '44', '62', '3', '', '0', '18', '265'),
    ('67', '0', '363', '545', '2', '2', '3', '', '0', '9', '130'),
    ('69', '0', '376', '379', '-1', '10', '9', '', '0', '2', '58'),
    ('70', '0', '393', '416', '15', '61', '10', '', '0', '7', '49'),
    ('71', '0', '419', '594', '15', '61', '10', '', '0', '16', '132'),
    ('72', '0', '424', '531', '22', '4', '3', '', '0', '13', '229'),
    ('73', '0', '438', '442', '4', '4', '4', '', '0', '2', '14'),
    ('75', '0', '464', '858', '63', '2', '6', '', '0', '11', '133'),
    ('78', '0', '508', '561', '14', '63', '8', '', '0', '9', '94'),
    ('79', '0', '510', '510', '-1', '-1', '9', '', '0', '0', '33'),
    ('81', '0', '518', '568', '4', '4', '3', '', '0', '5', '142'),
    ('82', '0', '538', '566', '45', '61', '3', '', '0', '7', '151'),
    ('84', '0', '547', '864', '15', '61', '10', '', '0', '12', '152'),
    ('85', '0', '572', '585', '4', '4', '4', '', '0', '7', '16'),
    ('86', '0', '579', '680', '4', '15', '5', '', '0', '7', '162'),
    ('87', '0', '597', '681', '63', '15', '6', '', '0', '2', '36'),
    ('89', '0', '604', '604', '68', '68', '8', '', '0', '0', '22'),
    ('91', '0', '608', '716', '2', '2', '3', '', '0', '2', '79'),
    ('92', '0', '609', '609', '2', '2', '2', '', '0', '0', '20'),
    ('93', '0', '610', '610', '2', '2', '4', '', '0', '0', '5'),
    ('94', '0', '616', '886', '68', '62', '2', '', '0', '6', '62'),
    ('95', '0', '643', '899', '68', '2', '3', '', '0', '5', '87'),
    ('96', '0', '650', '650', '79', '79', '11', '', '0', '0', '20'),
    ('97', '0', '658', '661', '68', '68', '13', '', '0', '2', '33'),
    ('98', '0', '659', '728', '68', '68', '8', '', '0', '10', '83'),
    ('99', '0', '668', '808', '4', '92', '3', '', '0', '28', '290'),
    ('100', '0', '682', '749', '22', '15', '3', '', '0', '7', '111'),
    ('101', '0', '687', '687', '14', '14', '5', '', '0', '0', '30'),
    ('102', '0', '710', '710', '68', '68', '8', '', '0', '0', '14'),
    ('103', '0', '713', '734', '86', '86', '7', '', '0', '3', '61'),
    ('104', '0', '724', '725', '68', '2', '3', '', '0', '1', '41'),
    ('105', '0', '729', '849', '68', '68', '13', '', '0', '6', '60'),
    ('106', '0', '733', '733', '22', '22', '3', '', '0', '0', '34'),
    ('107', '0', '879', '981', '86', '63', '7', '', '0', '1', '40'),
    ('108', '0', '744', '781', '4', '2', '5', '', '0', '7', '77'),
    ('109', '0', '745', '776', '4', '61', '8', '', '0', '3', '66'),
    ('111', '0', '785', '872', '74', '68', '5', '', '0', '22', '160'),
    ('112', '0', '791', '885', '4', '62', '5', '', '0', '7', '91'),
    ('113', '0', '796', '797', '61', '61', '10', '', '0', '1', '9'),
    ('114', '0', '801', '833', '4', '61', '5', '', '0', '2', '47'),
    ('115', '0', '802', '1002', '2', '15', '3', '', '0', '9', '114'),
    ('116', '0', '803', '815', '92', '92', '3', '', '0', '3', '51'),
    ('117', '0', '826', '877', '74', '86', '5', '', '0', '5', '109'),
    ('118', '0', '836', '850', '68', '68', '13', '', '0', '2', '24'),
    ('119', '0', '841', '878', '4', '86', '3', '', '0', '1', '131'),
    ('120', '0', '848', '848', '-1', '-1', '11', '', '0', '0', '20'),
    ('121', '0', '868', '1006', '27', '68', '3', '', '0', '13', '98'),
    ('122', '0', '869', '890', '2', '4', '4', '', '0', '3', '9'),
    ('123', '0', '901', '914', '4', '61', '5', '', '0', '5', '140'),
    ('124', '0', '902', '916', '94', '2', '3', '', '0', '5', '45'),
    ('125', '0', '913', '913', '61', '61', '10', '', '0', '0', '6'),
    ('126', '0', '926', '936', '32', '4', '5', '', '0', '5', '41'),
    ('127', '0', '930', '1013', '45', '27', '3', '', '0', '10', '161'),
    ('128', '0', '941', '958', '4', '4', '5', '', '0', '5', '84'),
    ('129', '0', '949', '1004', '108', '86', '12', '', '0', '6', '48'),
    ('130', '0', '952', '1000', '4', '5', '5', '', '0', '22', '120'),
    ('132', '0', '959', '959', '2', '2', '1', '', '0', '0', '45'),
    ('133', '0', '960', '963', '2', '4', '3', '', '0', '1', '54'),
    ('134', '0', '969', '975', '4', '2', '4', '', '0', '3', '10'),
    ('135', '0', '996', '999', '32', '4', '5', '', '0', '2', '18'),
    ('137', '0', '1001', '1011', '68', '68', '13', '', '0', '3', '22');

Caused the error:

    Duplicate entry '204-3' for key 3

After.. "try again"

Code Select
Converting...
Converting topics... Unsuccessful!
This query:

    INSERT INTO `discontinuivvfmarche`.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 ('5', '0', '6', '113', '4', '33', '11', '', '0', '8', '145'),
    ('7', '0', '10', '402', '2', '4', '5', '', '0', '9', '194'),
    ('9', '0', '19', '21', '2', '4', '4', '', '0', '2', '24'),
    ('11', '0', '23', '23', '2', '2', '1', '', '0', '0', '262'),
    ('12', '0', '26', '26', '2', '2', '4', '', '0', '0', '35'),
    ('13', '0', '27', '247', '2', '4', '4', '', '0', '12', '68'),
    ('14', '0', '30', '203', '9', '9', '2', '', '0', '11', '90'),
    ('16', '0', '42', '224', '4', '4', '11', '', '0', '4', '97'),
    ('17', '0', '45', '640', '10', '74', '3', '', '0', '25', '347'),
    ('20', '0', '62', '857', '4', '74', '5', '', '0', '39', '507'),
    ('21', '0', '67', '67', '2', '2', '9', '', '0', '0', '183'),
    ('22', '0', '68', '516', '2', '2', '9', '', '0', '5', '170'),
    ('23', '0', '71', '352', '-1', '15', '3', '', '0', '8', '156'),
    ('25', '0', '75', '231', '22', '10', '3', '', '0', '8', '132'),
    ('26', '0', '79', '526', '14', '14', '8', '', '0', '26', '240'),
    ('28', '0', '108', '754', '4', '79', '3', '', '0', '16', '206'),
    ('29', '0', '120', '979', '4', '61', '10', '', '0', '11', '88'),
    ('30', '0', '121', '223', '14', '4', '8', '', '0', '1', '61'),
    ('32', '0', '154', '1012', '13', '4', '5', '', '0', '91', '995'),
    ('33', '0', '161', '208', '2', '2', '11', '', '0', '4', '47'),
    ('34', '0', '163', '676', '-1', '2', '9', '', '0', '15', '220'),
    ('36', '0', '194', '372', '2', '4', '4', '', '0', '8', '35'),
    ('38', '0', '204', '286', '44', '2', '3', '', '0', '18', '340'),
    ('42', '0', '212', '596', '17', '17', '3', '', '0', '22', '353'),
    ('43', '0', '220', '313', '2', '10', '11', '', '0', '8', '118'),
    ('45', '0', '204', '226', '44', '', '3', '', '0', '10', '100'),
    ('47', '0', '251', '254', '2', '4', '4', '', '0', '1', '14'),
    ('51', '0', '264', '575', '7', '15', '3', '', '0', '29', '362'),
    ('53', '0', '296', '753', '10', '61', '5', '', '0', '10', '102'),
    ('58', '0', '321', '445', '10', '62', '3', '', '0', '5', '112'),
    ('59', '0', '323', '324', '38', '2', '2', '', '0', '1', '20'),
    ('60', '0', '325', '478', '22', '10', '3', '', '0', '9', '139'),
    ('62', '0', '338', '353', '2', '15', '11', '', '0', '4', '55'),
    ('63', '0', '343', '490', '10', '2', '5', '', '0', '6', '129'),
    ('64', '0', '347', '360', '4', '2', '11', '', '0', '1', '79'),
    ('65', '0', '348', '740', '44', '62', '3', '', '0', '18', '265'),
    ('67', '0', '363', '545', '2', '2', '3', '', '0', '9', '130'),
    ('69', '0', '376', '379', '-1', '10', '9', '', '0', '2', '58'),
    ('70', '0', '393', '416', '15', '61', '10', '', '0', '7', '49'),
    ('71', '0', '419', '594', '15', '61', '10', '', '0', '16', '132'),
    ('72', '0', '424', '531', '22', '4', '3', '', '0', '13', '229'),
    ('73', '0', '438', '442', '4', '4', '4', '', '0', '2', '14'),
    ('75', '0', '464', '858', '63', '2', '6', '', '0', '11', '133'),
    ('78', '0', '508', '561', '14', '63', '8', '', '0', '9', '94'),
    ('79', '0', '510', '510', '-1', '-1', '9', '', '0', '0', '33'),
    ('81', '0', '518', '568', '4', '4', '3', '', '0', '5', '142'),
    ('82', '0', '538', '566', '45', '61', '3', '', '0', '7', '151'),
    ('84', '0', '547', '864', '15', '61', '10', '', '0', '12', '152'),
    ('85', '0', '572', '585', '4', '4', '4', '', '0', '7', '16'),
    ('86', '0', '579', '680', '4', '15', '5', '', '0', '7', '162'),
    ('87', '0', '597', '681', '63', '15', '6', '', '0', '2', '36'),
    ('89', '0', '604', '604', '68', '68', '8', '', '0', '0', '22'),
    ('91', '0', '608', '716', '2', '2', '3', '', '0', '2', '79'),
    ('92', '0', '609', '609', '2', '2', '2', '', '0', '0', '20'),
    ('93', '0', '610', '610', '2', '2', '4', '', '0', '0', '5'),
    ('94', '0', '616', '886', '68', '62', '2', '', '0', '6', '62'),
    ('95', '0', '643', '899', '68', '2', '3', '', '0', '5', '87'),
    ('96', '0', '650', '650', '79', '79', '11', '', '0', '0', '20'),
    ('97', '0', '658', '661', '68', '68', '13', '', '0', '2', '33'),
    ('98', '0', '659', '728', '68', '68', '8', '', '0', '10', '83'),
    ('99', '0', '668', '808', '4', '92', '3', '', '0', '28', '290'),
    ('100', '0', '682', '749', '22', '15', '3', '', '0', '7', '111'),
    ('101', '0', '687', '687', '14', '14', '5', '', '0', '0', '30'),
    ('102', '0', '710', '710', '68', '68', '8', '', '0', '0', '14'),
    ('103', '0', '713', '734', '86', '86', '7', '', '0', '3', '61'),
    ('104', '0', '724', '725', '68', '2', '3', '', '0', '1', '41'),
    ('105', '0', '729', '849', '68', '68', '13', '', '0', '6', '60'),
    ('106', '0', '733', '733', '22', '22', '3', '', '0', '0', '34'),
    ('107', '0', '879', '981', '86', '63', '7', '', '0', '1', '40'),
    ('108', '0', '744', '781', '4', '2', '5', '', '0', '7', '77'),
    ('109', '0', '745', '776', '4', '61', '8', '', '0', '3', '66'),
    ('111', '0', '785', '872', '74', '68', '5', '', '0', '22', '160'),
    ('112', '0', '791', '885', '4', '62', '5', '', '0', '7', '91'),
    ('113', '0', '796', '797', '61', '61', '10', '', '0', '1', '9'),
    ('114', '0', '801', '833', '4', '61', '5', '', '0', '2', '47'),
    ('115', '0', '802', '1002', '2', '15', '3', '', '0', '9', '114'),
    ('116', '0', '803', '815', '92', '92', '3', '', '0', '3', '51'),
    ('117', '0', '826', '877', '74', '86', '5', '', '0', '5', '109'),
    ('118', '0', '836', '850', '68', '68', '13', '', '0', '2', '24'),
    ('119', '0', '841', '878', '4', '86', '3', '', '0', '1', '131'),
    ('120', '0', '848', '848', '-1', '-1', '11', '', '0', '0', '20'),
    ('121', '0', '868', '1006', '27', '68', '3', '', '0', '13', '98'),
    ('122', '0', '869', '890', '2', '4', '4', '', '0', '3', '9'),
    ('123', '0', '901', '914', '4', '61', '5', '', '0', '5', '140'),
    ('124', '0', '902', '916', '94', '2', '3', '', '0', '5', '45'),
    ('125', '0', '913', '913', '61', '61', '10', '', '0', '0', '6'),
    ('126', '0', '926', '936', '32', '4', '5', '', '0', '5', '41'),
    ('127', '0', '930', '1013', '45', '27', '3', '', '0', '10', '161'),
    ('128', '0', '941', '958', '4', '4', '5', '', '0', '5', '84'),
    ('129', '0', '949', '1004', '108', '86', '12', '', '0', '6', '48'),
    ('130', '0', '952', '1000', '4', '5', '5', '', '0', '22', '120'),
    ('132', '0', '959', '959', '2', '2', '1', '', '0', '0', '45'),
    ('133', '0', '960', '963', '2', '4', '3', '', '0', '1', '54'),
    ('134', '0', '969', '975', '4', '2', '4', '', '0', '3', '10'),
    ('135', '0', '996', '999', '32', '4', '5', '', '0', '2', '18'),
    ('137', '0', '1001', '1011', '68', '68', '13', '', '0', '3', '22');

Caused the error:

    Duplicate entry '5' for key 1

I try to delete post locked,moved,with poll and change sticky to nomal post but error remain.

I try run sql querry http://www.simplemachines.org/community/index.php?topic=84659.15
Code Select
select topic_id, user_id, count(*) as n
from phpbb_topics_watch
group by topic_id, user_id
having  n > 1;

but no change.  :-\


Sorry for my poor english...but i hope you understand.  :-X

Tupsi

#1
December 27, 2006, 04:51:18 AM
Hello

had the some problem, tried some fixes mentioned here on the forums but they all dont work. Until I found the workaround with the old converter, which worked for me.



1) Install 1.0.9
2) convert phpbb2 with old converter to smf 1.0.9
3) upgrade smf 1.0.9 to 1.1.1

So it seems the new converter still has issues the old one has no trouble at all with.

Anyway it worked so I am happy :-)

Good new year!

Davidlig

#2
December 28, 2006, 11:55:28 PM
thanks :D
hxxp:www.warrock.es [nonactive] / hxxp:www.k2warrock.es [nonactive]

Gavin Chatt

#3
December 29, 2006, 11:12:33 AM
Common issue and not much help around, for me anyway "lol"

I'm trying to convert phpnuke however like a loads of others have the topics issues mentioned here. I'll try anything at this point, cheers for the suggestion :)

Regards
Gavin Chatt
Austeam Founder
http://austeamracing.com.au
Print
Go Up Pages1
User actions
Advertisement: