[SMF Converter] phpBB - 2.0.19+

[JayBachatero]

It's convert.php.

[Ricky.]

well.. my conversion is running from last few hours and I think not possible to change that now, I miss understood that as .sql file instead of convert.php

I have that there is option to recalculate board stats in admin panel.. so I guess I can do that later.. isnt' ?

PS: Sorry to divert but I am facing a problem in conversion which I have stated here , your some input may be useful.

http://www.simplemachines.org/community/index.php?topic=207760.0

[lunameyer]

how do i convert?

i just downloaded the files... but i simply don´t know what do...

cause i´m a noob xD

please someone can help me?

[JayBachatero]

download te .sql file from this topic and the convert.php.  Then upload them to your SMF dir and point your browser to convert.php.

[lunameyer]

in first place, thanx.

i did what u said

but this error is occuring

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: SELECT command denied to user 'wowbra_smf2'@'localhost' for table 'phpbb_users'

My phpbb forum is on: http://wow-bra.com/azerothbr [nofollow]

and my smf is on: http://wow-bra.com/azerothbrasil [nofollow]

what can be going wrong?

[JayBachatero]

Common conversion errors.

[Ricky.]

Lunermayer :

To access a database, you need to have administrative rights on it. In order to convert phpBB to SMF, both the database must hv common user which can access both data so that convertor can read from phpBB database and write to SMF database.

So
Create a User who can access both database and use its password while it ask for password.

[Tokufriends]

Greetings people.

Well, please forgive my question, a little different from the main discussion, but i need one answer

The situation:

1) I have a PHPBB2 forum in one server.
2) I've downloaded the backup SQL file from PHPBB2.
3) I want all my archives to be in my new SMF forum in other server.
4) As i do not found any "upload arquive" button in SMF forum, can i upload the SQL file in any place through my server installed smf? Where do i have to place this SQL file, if i can do it?

Sorry for the questions, but if anyone can help me, it will be much appreciated ^^

[SleePy]

There is no way to upload an archive from within SMF.

To complete the conversion you need a phpbb database setup and working.
Then a conf.php for the conversion script to find and use to convert the Database to SMF

[imrich]

Thanks for these updated covert files!

I was converting from PHPBB 2.0.22 that had some mods (even some that included database changes) and had no real problems.

I did have to CHOMOD my ../Smileys/default directory to 777 to get this to work as I was receiving a lot of 'unable to access' errors. My PHPBB had a bunch of extra smileys in it.  Afterward doing this, the convert went without errors, except for a couple of 'unable to copy' because some files such as 'wink.gif' already existed so it wouldn't allow them to be over written.

If these new convert files were on the top level smf phpbb converter download page, I probably wouldn't have even had to come to this board to look for help. So why aren't the fixed files located at http://www.simplemachines.org/download/?converters ??

Thanks again!

[dilsiam]

Thanks for the new ppbb2_to_smf file, I did the conversion and it worked like a charm.

dilsiam

[Daniel Santos]

[ERROR]

Which software are you using?
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!
After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.

Help?

[JayBachatero]

Do you have a .sql file?  If not get the one from this topic.

[dratte]

I posted my request here because it seems close to other one with same problem. I have a large forum in phpbb 2.0.22 I have finally been able to partially transfer with phpbb 2.0.19 converter a part of my 220 meg of data but none of the topics have been transfered. The message error is this:

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members...
Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/152881486346915ab73f82d.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(827) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/277534624624fefce0e71.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(827) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/894098117466bc5c30c164.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(827) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/167087873744edf3abeea88.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(827) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/49408317845e57e23949d2.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(827) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/106034477544e0538319b90.gif) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(827) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/184058254644f5ae78aa2f9.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(827) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/15528890494581d55dd8370.gif) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(827) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/644319414714b0854bc42.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(827) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/594697068474d7e080cb05.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(827) : 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 `dogstory_smf1`.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 ('577', '0', '5636', '8173', '209', '209', '3', '', '0', '84', '7792'),
('579', '0', '5646', '5879', '39', '5', '2', '', '0', '6', '957'),
('581', '0', '5672', '5680', '199', '4', '6', '', '0', '2', '437'),
('582', '0', '5729', '5912', '210', '40', '25', '', '0', '17', '114'),
('583', '0', '5732', '6045', '210', '12', '3', '', '0', '3', '441'),
('584', '0', '5733', '9895', '210', '239', '15', '', '0', '4', '688'),
('585', '0', '5754', '8228', '4', '-1', '25', '', '0', '14', '89'),
('586', '0', '5769', '6074', '3', '50', '15', '', '0', '9', '711'),
('587', '0', '5778', '6044', '199', '19', '2', '', '0', '6', '488'),
('588', '0', '5807', '7208', '-1', '74', '69', '', '0', '18', '2996'),
('589', '0', '5810', '7695', '74', '5', '15', '', '0', '32', '1581'),
('590', '0', '5825', '7974', '4', '7', '15', '', '0', '66', '7237'),
('591', '0', '5889', '6032', '211', '19', '3', '', '0', '3', '346'),
('592', '1', '5896', '68967', '56', '1786', '10', '', '0', '11', '2453'),
('593', '0', '5900', '5909', '44', '4', '10', '', '0', '2', '294'),
('594', '0', '5901', '6161', '132', '4', '3', '', '0', '6', '574'),
('595', '0', '5917', '6425', '4', '4', '2', '', '0', '14', '961'),
('596', '0', '5938', '5973', '212', '3', '2', '', '0', '5', '511'),
('597', '0', '5955', '6196', '4', '58', '15', '', '0', '12', '626'),
('598', '0', '5958', '6245', '4', '206', '14', '', '0', '6', '1412'),
('599', '0', '5991', '7321', '50', '3', '69', '', '0', '15', '2774'),
('600', '0', '6029', '6107', '97', '5', '15', '', '0', '7', '611'),
('601', '0', '6052', '6514', '213', '25', '2', '', '0', '29', '2421'),
('602', '0', '6056', '6331', '11', '31', '25', '', '0', '16', '102'),
('603', '0', '6061', '6538', '4', '40', '25', '', '0', '25', '229'),
('604', '0', '6076', '6792', '50', '4', '32', '', '0', '19', '1432'),
('606', '0', '6104', '6649', '58', '58', '25', '', '0', '52', '308'),
('607', '0', '6105', '6685', '13', '85', '25', '', '0', '16', '100'),
('609', '0', '6159', '7818', '4', '5', '15', '', '0', '6', '771'),
('610', '0', '6167', '6384', '3', '50', '25', '', '0', '16', '120'),
('612', '0', '6173', '9855', '-1', '203', '28', '', '0', '10', '1049'),
('613', '0', '6183', '12965', '210', '275', '10', '19', '0', '7', '618'),
('615', '0', '6231', '6518', '97', '97', '2', '', '0', '5', '425'),
('616', '0', '6247', '6337', '11', '31', '25', '', '0', '14', '101'),
('617', '0', '6254', '6386', '210', '5', '3', '', '0', '3', '376'),
('618', '0', '6259', '6700', '30', '7', '2', '', '0', '24', '1841'),
('620', '0', '6283', '6719', '30', '4', '25', '', '0', '18', '135'),
('621', '0', '6313', '6452', '203', '85', '25', '', '0', '13', '57'),
('622', '0', '6330', '6828', '4', '97', '19', '', '0', '10', '799'),
('623', '0', '6341', '6851', '4', '85', '2', '', '0', '10', '608'),
('624', '0', '6352', '10314', '4', '4', '25', '', '0', '128', '1047'),
('625', '0', '6372', '10897', '50', '282', '9', '', '0', '12', '3097'),
('626', '0', '6370', '40298', '50', '765', '9', '', '0', '26', '5755'),
('627', '0', '6417', '7110', '70', '70', '15', '', '0', '21', '1362'),
('628', '0', '6428', '6492', '56', '7', '7', '', '0', '3', '1130'),
('629', '0', '6437', '21663', '4', '4', '25', '', '0', '31', '212'),
('630', '0', '6468', '6632', '132', '132', '2', '', '0', '4', '458'),
('631', '0', '6479', '6630', '218', '218', '2', '', '0', '4', '385'),
('632', '0', '6494', '40485', '30', '849', '42', '', '0', '464', '30134'),
('633', '0', '6547', '9939', '30', '4', '25', '', '0', '12', '98'),
('635', '0', '6613', '6748', '4', '11', '25', '', '0', '7', '51'),
('636', '0', '6625', '6968', '219', '185', '2', '', '0', '9', '580'),
('637', '0', '6669', '6821', '199', '199', '2', '', '0', '4', '304'),
('641', '0', '6707', '7856', '4', '40', '10', '', '0', '23', '1357'),
('642', '0', '6733', '6818', '5', '7', '25', '', '0', '8', '43'),
('643', '0', '6744', '6790', '221', '4', '15', '', '0', '4', '320'),
('644', '0', '6803', '26815', '4', '4', '25', '', '0', '56', '256'),
('645', '0', '6815', '18995', '3', '533', '14', '', '0', '25', '5754'),
('647', '0', '6880', '7217', '4', '15', '25', '', '0', '26', '132'),
('648', '0', '6888', '8008', '7', '4', '25', '', '0', '137', '958'),
('649', '0', '6955', '71742', '4', '765', '23', '', '0', '250', '41066'),
('650', '0', '6978', '13536', '225', '225', '13', '', '0', '18', '3507'),
('651', '0', '6994', '7228', '50', '50', '2', '', '0', '7', '654'),
('653', '0', '7024', '11262', '6', '70', '25', '', '0', '13', '108'),
('654', '0', '7028', '7811', '4', '237', '2', '', '0', '18', '1406'),
('655', '0', '7050', '7291', '228', '3', '2', '', '0', '18', '1176'),
('656', '0', '7093', '9203', '11', '259', '3', '', '0', '16', '1023'),
('658', '0', '7176', '10965', '-1', '4', '28', '', '0', '7', '824'),
('659', '0', '7185', '7263', '74', '70', '25', '', '0', '1', '39'),
('660', '0', '7190', '8181', '4', '4', '5', '', '0', '6', '1408'),
('661', '0', '7211', '7354', '225', '13', '2', '', '0', '13', '669'),
('662', '0', '7238', '14405', '50', '-1', '31', '', '0', '28', '6486'),
('663', '0', '7251', '7337', '231', '210', '2', '', '0', '3', '333'),
('664', '0', '7272', '7290', '228', '225', '10', '', '0', '3', '336'),
('665', '0', '7285', '7344', '228', '225', '2', '', '0', '3', '344'),
('666', '0', '7296', '56485', '5', '733', '6', '', '0', '74', '10081'),
('667', '0', '7315', '8574', '3', '-1', '32', '', '0', '6', '700'),
('668', '0', '7324', '10474', '13', '42', '10', '', '0', '3', '411'),
('669', '0', '7328', '7383', '224', '3', '10', '', '0', '3', '357'),
('670', '0', '7331', '9614', '7', '70', '25', '', '0', '19', '132'),
('671', '0', '7353', '7736', '225', '3', '6', '', '0', '6', '736'),
('672', '0', '7360', '8315', '233', '233', '3', '', '0', '5', '626'),
('673', '0', '7406', '8580', '199', '-1', '8', '', '0', '5', '892'),
('674', '0', '7411', '7553', '234', '203', '2', '', '0', '7', '554'),
('675', '0', '7485', '11499', '7', '7', '10', '', '0', '22', '1966'),
('676', '0', '7533', '7942', '206', '55', '3', '', '0', '15', '787'),
('677', '0', '7548', '7841', '39', '40', '2', '', '0', '10', '693'),
('678', '0', '7572', '7714', '4', '30', '25', '', '0', '17', '123'),
('679', '0', '7578', '8083', '56', '52', '3', '', '0', '30', '2966'),
('680', '0', '7580', '8059', '235', '56', '3', '', '0', '2', '243'),
('681', '0', '7595', '7595', '44', '44', '6', '', '0', '0', '416'),
('682', '0', '7599', '7720', '74', '-1', '25', '', '0', '5', '36'),
('683', '0', '7609', '9560', '236', '6', '10', '', '0', '21', '1732'),
('684', '0', '7611', '7699', '74', '74', '25', '', '0', '6', '38'),
('685', '0', '7640', '7886', '110', '201', '63', '', '0', '20', '3585'),
('689', '0', '7724', '7743', '50', '50', '15', '', '0', '3', '322'),
('690', '0', '7763', '7909', '4', '15', '25', '', '0', '8', '52'),
('691', '0', '7777', '9529', '-1', '-1', '25', '', '0', '33', '315'),
('692', '0', '7778', '8542', '228', '39', '3', '', '0', '17', '1294'),
('693', '0', '7809', '16243', '29', '29', '20', '', '0', '15', '2964'),
('694', '0', '7822', '10235', '4', '45', '25', '20', '0', '28', '241'),
('695', '0', '7837', '8234', '4', '5', '25', '', '0', '11', '55'),
('696', '0', '7845', '7913', '5', '203', '2', '', '0', '4', '323'),
('698', '0', '7898', '8219', '4', '179', '3', '', '0', '43', '4666'),
('699', '0', '7910', '8422', '7', '7', '15', '', '0', '21', '1982'),
('700', '0', '7928', '9918', '132', '286', '6', '', '0', '3', '602'),
('701', '0', '7984', '8191', '-1', '15', '25', '', '0', '8', '76'),
('703', '0', '8018', '8037', '240', '4', '6', '', '0', '3', '518'),
('704', '0', '8049', '8066', '211', '4', '3', '', '0', '2', '303'),
('705', '0', '8074', '31005', '11', '4', '32', '', '0', '23', '3102'),
('706', '0', '8080', '8529', '4', '4', '15', '', '0', '12', '1045'),
('707', '0', '8081', '8202', '11', '-1', '25', '', '0', '11', '79'),
('708', '0', '8095', '8418', '43', '43', '2', '', '0', '22', '1703'),
('709', '0', '8102', '15942', '241', '241', '63', '', '0', '27', '5328'),
('710', '0', '8116', '10064', '68', '288', '4', '', '0', '7', '1135'),
('711', '0', '8119', '16347', '-1', '70', '22', '', '0', '36', '8431'),
('712', '0', '8122', '13510', '43', '3', '28', '', '0', '12', '1117'),
('715', '0', '8220', '13216', '155', '4', '19', '', '0', '8', '987'),
('716', '0', '8221', '8221', '5', '5', '15', '', '0', '0', '367'),
('717', '0', '8229', '9026', '-1', '-1', '19', '', '0', '44', '5546'),
('718', '0', '8232', '8406', '43', '15', '25', '', '0', '8', '53'),
('719', '0', '8236', '8450', '58', '58', '6', '', '0', '2', '450'),
('721', '0', '8240', '9024', '244', '244', '3', '', '0', '26', '2315'),
('722', '0', '8263', '8511', '7', '206', '25', '', '0', '13', '88'),
('723', '0', '8265', '15328', '6', '85', '2', '', '0', '16', '1888'),
('724', '0', '8284', '8416', '246', '246', '15', '', '0', '14', '1120'),
('725', '0', '8295', '8611', '46', '179', '15', '', '0', '7', '518'),
('726', '0', '8320', '9119', '233', '210', '3', '', '0', '14', '1089'),
('727', '0', '8328', '8486', '163', '11', '25', '', '0', '5', '39'),
('728', '0', '8332', '8591', '249', '56', '2', '', '0', '7', '653'),
('729', '0', '8335', '8335', '163', '163', '2', '', '0', '0', '267'),
('730', '0', '8339', '10627', '70', '70', '15', '', '0', '42', '2468'),
('731', '0', '8342', '8820', '163', '206', '3', '', '0', '3', '432'),
('732', '0', '8347', '10834', '163', '42', '8', '', '0', '4', '802'),
('733', '0', '8355', '8737', '250', '3', '2', '', '0', '10', '723'),
('734', '0', '8359', '8866', '251', '251', '2', '', '0', '17', '1338'),
('735', '0', '8372', '8447', '252', '252', '25', '', '0', '4', '27'),
('736', '0', '8397', '53694', '31', '85', '25', '', '0', '20', '88'),
('737', '0', '8421', '10305', '13', '50', '25', '', '0', '3', '53'),
('738', '0', '8458', '10065', '50', '288', '4', '', '0', '1', '623'),
('739', '0', '8461', '9038', '7', '54', '25', '', '0', '28', '217'),
('740', '0', '8462', '8607', '252', '179', '6', '', '0', '3', '593'),
('741', '0', '8495', '8546', '58', '-1', '25', '', '0', '5', '57'),
('742', '0', '8512', '8907', '254', '206', '2', '', '0', '7', '508'),
('743', '0', '8519', '8567', '210', '43', '25', '', '0', '2', '32'),
('744', '0', '8537', '10909', '25', '241', '2', '', '0', '72', '8600'),
('745', '0', '8538', '9756', '43', '43', '3', '', '0', '16', '966'),
('746', '0', '8563', '8745', '3', '5', '25', '', '0', '11', '68'),
('747', '0', '8566', '57265', '43', '43', '7', '', '0', '8', '1697'),
('748', '0', '8606', '8606', '255', '255', '3', '', '0', '0', '251'),
('749', '0', '8609', '14713', '2', '-1', '24', '', '0', '22', '4875'),
('750', '0', '8621', '8906', '256', '97', '15', '', '0', '21', '2032'),
('751', '0', '8623', '8818', '171', '206', '2', '', '0', '1', '246'),
('752', '0', '8655', '14663', '7', '7', '6', '', '0', '14', '1521'),
('754', '0', '8686', '9970', '-1', '275', '2', '', '0', '5', '581'),
('755', '0', '8693', '8780', '179', '4', '25', '', '0', '4', '23'),
('757', '0', '8740', '12628', '31', '40', '25', '', '0', '52', '318'),
('758', '0', '8761', '8887', '55', '30', '15', '', '0', '9', '536'),
('759', '0', '8799', '9848', '259', '259', '2', '', '0', '19', '1407'),
('760', '0', '8817', '8971', '7', '256', '15', '', '0', '19', '1417'),
('762', '0', '8847', '8993', '7', '50', '25', '', '0', '15', '82'),
('763', '0', '8854', '9176', '7', '70', '6', '', '0', '3', '776'),
('764', '0', '8891', '9343', '99', '239', '2', '', '0', '26', '2490'),
('765', '0', '8943', '9001', '263', '4', '2', '', '0', '3', '243'),
('766', '0', '8954', '9077', '27', '27', '2', '', '0', '6', '349'),
('767', '0', '8956', '9300', '85', '30', '25', '', '0', '19', '83'),
('768', '0', '8960', '9017', '97', '97', '15', '', '0', '6', '288'),
('769', '0', '8966', '9134', '54', '-1', '25', '', '0', '8', '68'),
('770', '0', '8967', '9008', '55', '55', '15', '', '0', '4', '227'),
('772', '0', '9015', '9195', '4', '-1', '25', '', '0', '22', '92'),
('773', '0', '9021', '9718', '206', '206', '15', '', '0', '29', '2926'),
('774', '0', '9023', '9069', '265', '3', '2', '', '0', '8', '388'),
('775', '0', '9064', '9208', '7', '45', '2', '', '0', '8', '593'),
('776', '0', '9096', '11017', '-1', '311', '15', '', '0', '5', '479'),
('777', '0', '9111', '9646', '4', '50', '19', '', '0', '6', '879'),
('778', '0', '9137', '15012', '2', '288', '4', '', '0', '10', '1422'),
('780', '0', '9140', '9158', '97', '15', '10', '', '0', '3', '371'),
('781', '0', '9163', '9996', '5', '5', '25', '', '0', '5', '59'),
('782', '0', '9168', '9777', '266', '27', '3', '', '0', '15', '2324'),
('783', '0', '9170', '9789', '97', '97', '2', '', '0', '3', '222'),
('784', '0', '9172', '15192', '58', '58', '8', '', '0', '26', '5026'),
('786', '0', '9201', '23219', '-1', '43', '23', '', '0', '9', '2005'),
('787', '0', '9211', '9330', '97', '81', '2', '', '0', '5', '520'),
('788', '0', '9213', '9232', '7', '7', '4', '', '0', '4', '856'),
('789', '0', '9214', '9406', '171', '-1', '25', '', '0', '9', '55'),
('790', '0', '9215', '9623', '148', '74', '15', '', '0', '14', '715'),
('792', '0', '9246', '9505', '-1', '7', '17', '21', '0', '18', '3258'),
('793', '0', '9252', '14618', '5', '-1', '34', '', '0', '74', '12591'),
('794', '0', '9284', '9672', '267', '81', '2', '', '0', '6', '415'),
('795', '0', '9311', '14758', '94', '3', '28', '', '0', '5', '623'),
('796', '0', '9375', '9447', '272', '272', '25', '', '0', '8', '53'),
('798', '0', '9380', '9386', '-1', '4', '6', '', '0', '2', '389'),
('799', '0', '9382', '9435', '4', '4', '2', '', '0', '3', '371'),
('800', '0', '9395', '9466', '55', '40', '32', '', '0', '1', '297'),
('801', '0', '9396', '12135', '55', '7', '25', '', '0', '8', '62'),
('802', '0', '9398', '9465', '11', '206', '25', '', '0', '3', '36'),
('803', '0', '9449', '9472', '272', '259', '2', '', '0', '1', '251'),
('804', '0', '9462', '9626', '182', '182', '3', '', '0', '6', '501'),
('805', '0', '9467', '9520', '-1', '31', '6', '', '0', '2', '497'),
('806', '0', '9468', '9705', '248', '206', '15', '', '0', '4', '431'),
('807', '0', '9473', '10746', '259', '44', '28', '', '0', '32', '3424'),
('808', '0', '9478', '10365', '137', '137', '2', '', '0', '6', '448'),
('809', '0', '9497', '9584', '97', '97', '10', '', '0', '7', '447'),
('810', '0', '9506', '9615', '-1', '70', '25', '', '0', '19', '100'),
('812', '0', '9538', '9618', '-1', '-1', '25', '', '0', '5', '56'),
('813', '0', '9552', '9662', '4', '46', '15', '', '0', '9', '540'),
('814', '0', '9572', '9658', '31', '127', '2', '', '0', '1', '214'),
('815', '0', '9580', '9644', '58', '50', '25', '', '0', '4', '53'),
('816', '0', '9581', '9819', '4', '203', '25', '', '0', '20', '135'),
('817', '0', '9600', '10452', '58', '-1', '14', '', '0', '7', '1537'),
('818', '0', '9666', '9860', '275', '275', '3', '', '0', '4', '819'),
('819', '0', '9667', '11301', '276', '42', '3', '', '0', '21', '2089'),
('820', '0', '9679', '10711', '217', '120', '2', '', '0', '3', '548'),
('821', '0', '9685', '9797', '278', '68', '2', '', '0', '6', '473'),
('822', '0', '9689', '9795', '7', '-1', '25', '', '0', '16', '88'),
('823', '0', '9696', '16065', '7', '7', '6', '', '0', '3', '863'),
('824', '0', '9719', '11169', '4', '50', '10', '', '0', '7', '650'),
('825', '0', '9723', '12240', '6', '6', '2', '', '0', '13', '1050'),
('826', '0', '9733', '10532', '4', '7', '15', '', '0', '4', '388'),
('827', '0', '9734', '14566', '58', '175', '6', '', '0', '6', '929'),
('829', '0', '9738', '10670', '279', '19', '3', '', '0', '6', '555'),
('830', '0', '9740', '9741', '279', '11', '6', '', '0', '1', '361'),
('831', '0', '9754', '9897', '68', '-1', '10', '', '0', '5', '336'),
('832', '0', '9768', '10378', '43', '43', '3', '', '0', '7', '563'),
('833', '0', '9772', '32555', '43', '43', '21', '', '0', '14', '2904'),
('834', '0', '9785', '9785', '14', '14', '4', '', '0', '0', '621'),
('835', '0', '9787', '38350', '259', '842', '42', '', '0', '8', '1189'),
('838', '0', '9811', '9833', '281', '206', '3', '', '0', '4', '592'),
('839', '0', '9813', '9955', '42', '4', '25', '', '0', '6', '55'),
('840', '0', '9814', '50498', '55', '29', '10', '', '0', '13', '1082'),
('841', '0', '9822', '9881', '-1', '282', '10', '', '0', '6', '393'),
('842', '0', '9824', '9997', '26', '3', '2', '', '0', '7', '683'),
('843', '0', '9858', '10043', '284', '284', '2', '', '0', '10', '1462'),
('844', '0', '9867', '75868', '4', '1523', '10', '', '0', '360', '28431'),
('845', '0', '9892', '10649', '-1', '-1', '20', '', '0', '11', '2364'),
('846', '0', '9894', '10215', '285', '40', '15', '', '0', '3', '251'),
('847', '0', '9904', '21301', '-1', '-1', '10', '', '0', '13', '923'),
('848', '0', '9916', '10766', '-1', '40', '2', '', '0', '19', '2239'),
('849', '0', '9924', '15226', '-1', '434', '42', '', '0', '9', '870'),
('854', '0', '9945', '10281', '58', '2', '4', '', '0', '6', '1128'),
('857', '0', '9956', '14439', '50', '-1', '34', '', '0', '7', '1101'),
('858', '0', '9961', '10671', '4', '70', '25', '', '0', '33', '201'),
('859', '0', '9962', '10138', '274', '274', '2', '', '0', '2', '402'),
('860', '0', '9964', '10683', '288', '50', '25', '', '0', '31', '154'),
('861', '0', '9986', '10358', '275', '30', '25', '', '0', '9', '47'),
('862', '0', '10007', '24806', '199', '397', '32', '', '0', '10', '1291'),
('863', '0', '10014', '80323', '5', '55', '8', '', '0', '32', '5582'),
('865', '0', '10036', '10436', '182', '56', '2', '', '0', '24', '2121'),
('866', '0', '10038', '33797', '-1', '571', '8', '', '0', '14', '2424'),
('867', '0', '10042', '10321', '291', '50', '28', '', '0', '5', '528'),
('868', '0', '10042', '10042', '291', '291', '25', '', '0', '0', '2'),
('869', '0', '10089', '10652', '70', '31', '25', '', '0', '18', '89'),
('870', '0', '10098', '10108', '54', '50', '6', '', '0', '1', '362'),
('871', '0', '10114', '10174', '58', '50', '32', '', '0', '1', '350'),
('872', '0', '10115', '10127', '58', '4', '32', '', '0', '1', '287'),
('873', '0', '10117', '10983', '45', '6', '3', '', '0', '11', '831'),
('875', '0', '10148', '11699', '293', '31', '15', '', '0', '7', '440'),
('876', '0', '10149', '10457', '294', '-1', '15', '', '0', '5', '376'),
('877', '0', '10181', '10884', '58', '6', '25', '', '0', '16', '81'),
('878', '0', '10182', '10194', '46', '50', '25', '', '0', '4', '35'),
('879', '0', '10205', '11821', '4', '58', '40', '', '0', '52', '5325'),
('880', '0', '10228', '10377', '-1', '206', '10', '', '0', '8', '699'),
('881', '0', '10231', '10272', '211', '4', '3', '', '0', '5', '561'),
('882', '0', '10244', '10273', '4', '4', '31', '', '0', '6', '1194'),
('883', '0', '10285', '11143', '298', '298', '13', '', '0', '30', '5934'),
('884', '0', '10286', '12500', '-1', '210', '32', '', '0', '12', '1329'),
('885', '0', '10304', '10444', '4', '99', '15', '', '0', '3', '269'),
('886', '0', '10338', '12248', '275', '275', '3', '', '0', '16', '1397'),
('1176', '0', '13696', '14988', '-1', '85', '25', '', '0', '44', '376'),
('1177', '0', '13713', '22913', '236', '236', '2', '', '0', '8', '1786'); an on an on.....

Caused the error:

Duplicate entry '10629-25' for key 3

PLEASE HELP
actual forum is here
http:forum.dogstory.net/forum and new with smf: http://www.dogstory.net/forum2 [nofollow]
with the size of this forum PHPBB is now totally instable and am loosing members every day!

Thanks for any help

Dan

[JayBachatero]

Give the converter in this topic a try.

[dratte]

Don't send be back to the converter that's exactly what I'm using! 2.0.19+
Where do you think I get this error message from? Well if this answer is for me...of course


Dan

[JayBachatero]

Yes that message was for you.  The first error is because some users have avatars that are missing so you get that error.  The second error you shouldn't be getting if you are using the updated .sql file and the updated convert.php file.

[dratte]

Ok Jay thanks

Actually i don't really care for the avatar.  User will be asked to update them later in the process.

About the updated converter I'm 98% sure that I'm using the good one . I took it directly from smf converter section 6 days ago.

NOw the tricky part is about the SQL update where can I check that.? I'm using cpanel, PhpmyAdmin 2.11.0 and MySQL 4.1.22 with utf8 setting but have no idea where to find update or make changes  if this is not actual. And like most user here, I'm Really not that familiar with all the data base stuff.

The error message talk about double topics. Anyway to get  rid of them?

Thanks

Dan

[JayBachatero]

Best bet is to use these two files.

http://www.simplemachines.org/community/index.php?action=dlattach;topic=142124.0;attach=38548
http://www.simplemachines.org/community/index.php?action=dlattach;topic=140741.0;attach=44817

[dratte]

HI Jay thanks again for your help but still not working.

I have uploaded the file you told me about from your last answer convert.php and .sql in the rooth directory of the forum, but still only have partial tranfer of the file with the same message and bug at the exact same line:

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members...
Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/152881486346915ab73f82d.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(831) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/277534624624fefce0e71.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(831) : eval()'d code on line 35


Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/1314652842470ba51f112f7.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(831) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/6988056624721386582037.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(831) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/122688844947363b3c783b3.gif) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(831) : eval()'d code on line 35

Warning: copy(/home/dogstory/public_html/forum/forum/images/avatars/594697068474d7e080cb05.jpg) [function.copy]: failed to open stream: No such file or directory in /home/dogstory/public_html/forum2/convert.php(831) : 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 `dogstory_smf1`.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 ('577', '0', '5636', '8173', '209', '209', '3', '', '0', '84', '7814'),
('579', '0', '5646', '5879', '39', '5', '2', '', '0', '6', '957'),
('581', '0', '5672', '5680', '199', '4', '6', '', '0', '2', '438'),
('582', '0', '5729', '5912', '210', '40', '25', '', '0', '17', '114'),
('583', '0', '5732', '6045', '210', '12', '3', '', '0', '3', '441'),
('584', '0', '5733', '9895', '210', '239', '15', '', '0', '4', '688'),
('585', '0', '5754', '8228', '4', '-1', '25', '', '0', '14', '89'),
('586', '0', '5769', '6074', '3', '50', '15', '', '0', '9', '712'),
('587', '0', '5778', '6044', '199', '19', '2', '', '0', '6', '490'),
('588', '0', '5807', '7208', '-1', '74', '69', '', '0', '18', '2999'),
('589', '0', '5810', '7695', '74', '5', '15', '', '0', '32', '1581'),
('590', '0', '5825', '7974', '4', '7', '15', '', '0', '66', '7237'),
('591', '0', '5889', '6032', '211', '19', '3', '', '0', '3', '346'),
('592', '1', '5896', '68967', '56', '1786', '10', '', '0', '11', '2457'),
('593', '0', '5900', '5909', '44', '4', '10', '', '0', '2', '294'),
('594', '0', '5901', '6161', '132', '4', '3', '', '0', '6', '574'),
All the way down to:
('945', '0', '11078', '11441', '322', '322', '2', '', '0', '5', '469'),

A lot in between('1176', '0', '13696', '14988', '-1', '85', '25', '', '0', '44', '376'),
('1177', '0', '13713', '22913', '236', '236', '2', '', '0', '8', '1794');
Caused the error:

Duplicate entry '10629-25' for key 3

So what ever I do I'm still on square one... or two. Got a partial transfer but no messages transfer at all.
I even tried the solution from another post telling to changes permission of setting.php to 777 change my sql id-moved-topics to ''null'' instead of ''no null'' still nothing. Looks like I,m not the only one with that specific problem.

I really don't want to get phpbb3.0 and need to fix that smf asap. Data base is not that big only 75000 messages with 1850 members. Server seams to allow me all the time I need event if data base is 220 meg.

What should be the next step?

BEst Regard

Dan