I downloaded the new convert.php, result:
Converting group access... Unsuccessful!
This query:
INSERT INTO `lrt`.smf_lrt_board_permissions
(ID_GROUP, ID_BOARD, permission)
VALUES
(18, 17, 'post_new'),
(18, 17, 'mark_notify'),
(18, 17, 'mark_any_notify'),
(18, 17, 'post_reply_any'),
(18, 17, 'modify_own'),
(18, 17, 'remove_own'),
(18, 17, 'delete_own'),
(18, 17, 'make_sticky'),
(18, 17, 'announce_topic'),
(18, 17, 'poll_post'),
(18, 17, 'poll_add_own'),
(18, 17, 'poll_vote'),
(18, 17, 'poll_view'),
(18, 17, 'moderate_board'),
(18, 17, 'remove_any'),
(18, 17, 'lock_any'),
(18, 17, 'lock_own'),
(18, 17, 'merge_any'),
(18, 17, 'modify_any'),
(18, 17, 'modify_own'),
(18, 17, 'move_any'),
(18, 17, 'poll_add_any'),
(18, 17, 'poll_edit_any'),
(18, 17, 'poll_remove_any'),
(18, 17, 'post_reply_own'),
(18, 17, 'delete_any'),
(18, 17, 'report_any'),
(18, 17, 'send_topic'),
(18, 17, 'split_any');
Caused the error:
Duplicate entry '18-17-modify_own' for key 1
Whoops, I was indeed using the wrong convert.php :-X
Ok, used the right one now, I get this:
Converting...
Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `lrt`.smf_lrt_2_messages
(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, posterEmail, subject, posterName, smileysEnabled, modifiedTime, posterIP, body, ID_BOARD)
VALUES ('99948', '1982', '1119813073', '172', '[email protected]', 'Schijtprobleem', 'Jas', '1', '', '84.30.139.167', '[img]http://www.affichescinema.com/insc_g/great_fire.jpg[/img]
<br />Maar dan anders !', '9'),
Caused the error:
Duplicate entry '99948' for key 1
I manually checked the phpbb database, but there is only 1 entry for post_id 99948. I now deleted this entry from phpbb_posts and phpbb_posts_text and Im now running the conversion again.
EDIT: I also disabled the phpbb board now (With the previous tries I didnt shut it down) to make sure no-one can post while the conversion is going on.
Ok previous error is gone now, but after that i get the same old error again:
Converting...
Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Unsuccessful!
This query:
INSERT INTO `lrt`.smf_board_permissions
(ID_GROUP, ID_BOARD, permission)
VALUES
(18, 17, 'post_new'),
(18, 17, 'mark_notify'),
(18, 17, 'mark_any_notify'),
(18, 17, 'post_reply_any'),
(18, 17, 'modify_own'),
(18, 17, 'remove_own'),
(18, 17, 'delete_own'),
(18, 17, 'make_sticky'),
(18, 17, 'announce_topic'),
(18, 17, 'poll_post'),
(18, 17, 'poll_add_own'),
(18, 17, 'poll_vote'),
(18, 17, 'poll_view'),
(18, 17, 'moderate_board'),
(18, 17, 'remove_any'),
(18, 17, 'lock_any'),
(18, 17, 'lock_own'),
(18, 17, 'merge_any'),
(18, 17, 'modify_any'),
(18, 17, 'modify_own'),
(18, 17, 'move_any'),
(18, 17, 'poll_add_any'),
(18, 17, 'poll_edit_any'),
(18, 17, 'poll_remove_any'),
(18, 17, 'post_reply_own'),
(18, 17, 'delete_any'),
(18, 17, 'report_any'),
(18, 17, 'send_topic'),
(18, 17, 'split_any');
Caused the error:
Duplicate entry '18-17-modify_own' for key 1
EDIT:
This is in my phpbb_auth_access for forum_id 17:
group_id forum_id auth_view auth_read auth_post auth_reply auth_edit auth_delete auth_sticky auth_announce auth_vote auth_pollcreate auth_attachments auth_mod
48 17 0 0 0 0 0 0 0 0 0 0 0 1
300 17 1 1 1 1 1 0 1 1 1 1 0 0
Edit2:
When I look at my SMF installation Im missing tons of posts. In SMF: 467 posts, in phpbb: 101471 posts. This could be caused by the conversion error?
Quote from: VTX on July 07, 2005, 07:47:42 AM
Ok previous error is gone now, but after that i get the same old error again:
Edit2:
When I look at my SMF installation Im missing tons of posts. In SMF: 467 posts, in phpbb: 101471 posts. This could be caused by the conversion error?
this is what I am seeing. lots of posts are just dropping off. - trying to figure out why...
Yes, tell me when its updated and ill give it another try :)
Quote from: VTX on July 07, 2005, 01:31:32 PM
Yes, tell me when its updated and ill give it another try :)
Now ^_^.
-[Unknown]
Convert.php is now running. Ill update this post when its ready. (Thanks for this great support btw, I love your product!)
Same error:
Converting...
Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Unsuccessful!
This query:
INSERT INTO `lrt`.smf_lrt2_board_permissions
(ID_GROUP, ID_BOARD, permission)
VALUES
(18, 17, 'post_new'),
(18, 17, 'mark_notify'),
(18, 17, 'mark_any_notify'),
(18, 17, 'post_reply_any'),
(18, 17, 'modify_own'),
(18, 17, 'remove_own'),
(18, 17, 'delete_own'),
(18, 17, 'make_sticky'),
(18, 17, 'announce_topic'),
(18, 17, 'poll_post'),
(18, 17, 'poll_add_own'),
(18, 17, 'poll_vote'),
(18, 17, 'poll_view'),
(18, 17, 'moderate_board'),
(18, 17, 'remove_any'),
(18, 17, 'lock_any'),
(18, 17, 'lock_own'),
(18, 17, 'merge_any'),
(18, 17, 'modify_any'),
(18, 17, 'modify_own'),
(18, 17, 'move_any'),
(18, 17, 'poll_add_any'),
(18, 17, 'poll_edit_any'),
(18, 17, 'poll_remove_any'),
(18, 17, 'post_reply_own'),
(18, 17, 'delete_any'),
(18, 17, 'report_any'),
(18, 17, 'send_topic'),
(18, 17, 'split_any');
Caused the error:
Duplicate entry '18-17-modify_own' for key 1
In phpbb2_to_smf.sql, try finding:
foreach ($this_group as $perm)
And add just before that line:
$this_group = array_unique($this_group);
Does that help?
-[Unknown]
Conversion completed ok now.
But I only have 133 messages is my smf board, while i have more than 100000 messages in phpbb.
phpBB Board: http://www.limburgracingteam.nl
SMF: http://www.limburgracingteam.nl/smf
What mods do you have installed on your forum? Does a repair change anything at all?
It does indeed look like most posts aren't getting converted. If they're in the one database and not the other... the question is why.
The converter will only drop posts if the topic doesn't exist, or if the posts_text entry isn't there. Both are fine in your case, since phpBB works...
-[Unknown]
Quote from: [Unknown] on July 07, 2005, 03:54:37 PM
What mods do you have installed on your forum? Does a repair change anything at all?
It does indeed look like most posts aren't getting converted. If they're in the one database and not the other... the question is why.
The converter will only drop posts if the topic doesn't exist, or if the posts_text entry isn't there. Both are fine in your case, since phpBB works...
-[Unknown]
I've got tons of mods installed, and made some mods myself. But none of them affect thos tables in the database.
I get this huge error list:
The following errors are fouling up your forum (blank if none):
Topic 2 contains no messages
Topic 5 contains no messages
Topic 6 contains no messages
Topic 7 contains no messages
Topic 8 contains no messages
Topic 9 contains no messages
Topic 10 contains no messages
Topic 11 contains no messages
Topic 12 contains no messages
Topic 13 contains no messages
Topic 14 contains no messages
Topic 15 contains no messages
Topic 16 contains no messages
Topic 17 contains no messages
Topic 18 contains no messages
Topic 19 contains no messages
Topic 20 contains no messages
Topic 21 contains no messages
Topic 22 contains no messages
Topic 23 contains no messages
Topic 24 contains no messages
Topic 25 contains no messages
Topic 26 contains no messages
Topic 27 contains no messages
Topic 28 contains no messages
Topic 29 contains no messages
Topic 30 contains no messages
Topic 31 contains no messages
Topic 32 contains no messages
Topic 33 contains no messages
Topic 34 contains no messages
Topic 35 contains no messages
Topic 36 contains no messages
Topic 37 contains no messages
Topic 38 contains no messages
Topic 39 contains no messages
Topic 40 contains no messages
Topic 41 contains no messages
Topic 42 contains no messages
Topic 43 contains no messages
Topic 44 contains no messages
Topic 45 contains no messages
Topic 46 contains no messages
Topic 48 contains no messages
Topic 49 contains no messages
Topic 50 contains no messages
Topic 51 contains no messages
Topic 52 contains no messages
Topic 53 contains no messages
Topic 54 contains no messages
Topic 56 contains no messages
Topic 57 contains no messages
Topic 58 contains no messages
Topic 59 contains no messages
Topic 60 contains no messages
Topic 61 contains no messages
Topic 62 contains no messages
Topic 63 contains no messages
Topic 64 contains no messages
Topic 65 contains no messages
Topic 66 contains no messages
Topic 67 contains no messages
Topic 68 contains no messages
Topic 69 contains no messages
Topic 70 contains no messages
Topic 71 contains no messages
Topic 72 contains no messages
Topic 73 contains no messages
Topic 74 contains no messages
Topic 75 contains no messages
Topic 76 contains no messages
Topic 77 contains no messages
Topic 78 contains no messages
Topic 79 contains no messages
Topic 80 contains no messages
Topic 81 contains no messages
Topic 82 contains no messages
Topic 83 contains no messages
Topic 84 contains no messages
Topic 85 contains no messages
Topic 86 contains no messages
Topic 87 contains no messages
And that goes on for a while, it's too big to post.
Ok, that list was too huge to post..
Anyways, when i try to fix it:
1996 topic(s) without messages have been removed successfully
And that's not good :P
I get the exact same error as VTX, 294 posts in 50 topics on SMF while the original phpbb has 28807 posts in 2842 topics ..... The members converted over, but the forums and categories are in wrong order (no biggie). This is with a non-modded phpbb 2.0.16. to SMF 1.1 Beta 3. Running the newest 1.1 converter on the first post of this thread.
Tell me, then... if you run this query:
SELECT
t.topic_id AS ID_TOPIC, t.topic_type = 1 AS isSticky,
t.topic_first_post_id AS ID_FIRST_MSG, t.topic_last_post_id AS ID_LAST_MSG,
t.topic_poster AS ID_MEMBER_STARTED, p.poster_id AS ID_MEMBER_UPDATED,
t.forum_id AS ID_BOARD, v.vote_id AS ID_POLL, t.topic_status = 1 AS locked,
t.topic_replies AS numReplies, t.topic_views AS numViews
FROM phpbb_topics AS t
LEFT JOIN phpbb_posts AS p ON (p.post_id = t.topic_last_post_id)
LEFT JOIN phpbb_vote_desc AS v ON (v.topic_id = t.topic_id);
In phpMyAdmin or similar, how many rows does it return? What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
It's looking like I'm going to need live data to test this; is there any way I could use a backup from one of you, or just try to convert it there with an FTP account that goes to where teh converter is?
-[Unknown]
It returns 2009 rows.
I sended you a backup of the sql-tables via pm. Thanks.
Ok so the converter should now convert avatars from phpBB2 correct?
For smilies, thats really a problem as I have 352 smilies, which are heavenly used on the old forum, and i dont want to convert these by hand. Any chance on a converter which does handle the smilies?
Also, after converting I need to install a lot of hacks/addons and have to write some myself, to convert the old site as smooth as possible. What I really need is an option to convert new posts/members since the last conversion. After that I can shutdown the old site and launch the new one based on SMF. Or is there another(or better) way of doing this?
My phpbb2 conversion seems to be hanging very early on in converting posts (I have a submit button whose label is "Continue (0)", and pressing it seems to do nothing except reload the exact same page including the form values).
Any suggestions?
Quote from: krelin on July 13, 2005, 01:14:10 AM
My phpbb2 conversion seems to be hanging very early on in converting posts (I have a submit button whose label is "Continue (0)", and pressing it seems to do nothing except reload the exact same page including the form values).
Any suggestions?
Just let it, it will auto reload.
Its only converting a little at a time to avoid crashing the server.
How does it remember the state of the conversion process? I notice there is a "start" field in the form, which seems to be the post ID to start at... it never seems to increment, even after multiple reloads.
Does it remember where it's at from some data store in the DB, then?
If you run the converter again, it just deletes the SMF data, again.
Its just some cool javascript that remembers how often to continue. Im sure one of the developers will be able to explain it a bit better
Heheh same here, I really need my smilies and avatars to be converted. I already installed mkportal and i did some programming(well like 30+ hours lol) on things I need.When smilies and avatars are converted im almost ready to fully convert the old site over :D
Quote from: VTX on July 11, 2005, 05:08:51 AM
Also, after converting I need to install a lot of hacks/addons and have to write some myself, to convert the old site as smooth as possible. What I really need is an option to convert new posts/members since the last conversion. After that I can shutdown the old site and launch the new one based on SMF. Or is there another(or better) way of doing this?
I'm afraid there's no good way at this time. I'll see what I can do about the smileys...
Quote from: krelin on July 13, 2005, 01:14:10 AM
My phpbb2 conversion seems to be hanging very early on in converting posts (I have a submit button whose label is "Continue (0)", and pressing it seems to do nothing except reload the exact same page including the form values).
Any suggestions?
Don't press it once it hits zero! You'll have to start over. It's automatically done via JavaScript.
Quote from: krelin on July 13, 2005, 12:30:00 PM
How does it remember the state of the conversion process? I notice there is a "start" field in the form, which seems to be the post ID to start at... it never seems to increment, even after multiple reloads.
Does it remember where it's at from some data store in the DB, then?
Normally, that will increase. In some cases, the converter doesn't use it and instead keeps track just by what is done and what needs to be done.
-[Unknown]
Ok great, if you can get smilies to convert that would be really awesome! Im currenlty still working on some custom code, when that and the smilies are done I can switch to SMF! Great product & great support!
Quote from: [Unknown] on July 14, 2005, 03:41:27 AM
Quote from: krelin on July 13, 2005, 12:30:00 PM
How does it remember the state of the conversion process? I notice there is a "start" field in the form, which seems to be the post ID to start at... it never seems to increment, even after multiple reloads.
Does it remember where it's at from some data store in the DB, then?
Don't press it once it hits zero! You'll have to start over. It's automatically done via JavaScript.
Normally, that will increase. In some cases, the converter doesn't use it and instead keeps track just by what is done and what needs to be done.
-[Unknown]
I tried the newest converter posted recently and still have the same problem, the conversion loops while doing my posts and never finishes. I let it run overnight last night and it never finished, never incremented, and never seemed to add more posts to my database.
I suspected that my problem might be related to JS, so I switch from Mozilla to IE, but even IE doesn't work right, though the failure is much more obvious. After only a countdown or two, IE eventually issues a "The page cannot be displayed" error at this url:
http://blahblah/smf/convert.php?step=1&substep=15&start=9500
Is there a way to get more/better debug output from the script?
Thanks
-- Krelin
not sure what changed (been a around a week) since my last port but the latest version is giving me duplicate errors? They all made it over just fine last time.
QuoteConverting topics... Unsuccessful!
This query:
INSERT INTO `testdb_-_core`.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 ('5901', '0', '64246', '66368', '1339', '1339', '16', '', '0', '47', '833'),
('5902', '0', '64247', '67934', '2452', '694', '6', '', '0', '5', '610'),
('5903', '0', '64248', '64248', '1339', '1339', '16', '', '0', '0', '69'),
('5904', '0', '64249', '64251', '1339', '1339', '16', '', '0', '2', '76'),
('5905', '0', '64262', '64417', '1339', '2204', '8', '', '0', '3', '271'),
('5906', '0', '64264', '64265', '2447', '2447', '13', '', '0', '1', '165'),
-------removed lots of the same for the sake of the post ----------
('6408', '0', '71675', '71675', '1339', '1339', '16', '', '0', '0', '36'),
('6409', '0', '71720', '72012', '1339', '1339', '4', '', '0', '7', '307');
Caused the error:
Duplicate entry '0-10' for key 3
Any idea if something changed it the script that may have caused this?
Thanks!
It sounds like you have some errors in your database, s9jeremiah.
I might suggest trying the attached converter, which will ignore broken topics.
Krelin, could you also try this converter? In addition to making it ignore topics, I made it go over the data in smaller chunks ("more carefully" so to speak.)
Just use the same convert.php.
-[Unknown]
I converted my phpbb22 to smf. Everything seemed to convert properly, but now I cannot login in admin.
HELP!!!!
<please!>
Sally
Can you log in as anything else? As a temporary measure to get you into the admin panel can you:
1) Register a new account, called something like "admin_test"
2) Open up phpMyAdmin, and run this query on the smf database:
UPDATE smf_members SET ID_GROUP = 1 WHERE memberName="admin_test" LIMIT 1
That will give this test account admin rights. Using the test account login to your forum and make sure that all the old members were transferred over etc. Also, go to the admin centre and go "Maintenance => Fix and Repair all errors", and also "Recount all totals". Then, using this test account look at your "old" admin profile and check it actually exists - and that it is in the admin group.
Let me know how you get on :)
I'm not sure what's wrong with my transfer at all. I made sure I had the right converter files. But nothing at all appears to be converted.....
Quote from: tigerfaerie on July 24, 2005, 05:05:11 PM
I'm not sure what's wrong with my transfer at all. I made sure I had the right converter files. But nothing at all appears to be converted.....
Did you get any "debug" or "skipped" messages?
-[Unknown]
Quote from: [Unknown] on July 16, 2005, 11:01:52 PM
It sounds like you have some errors in your database, s9jeremiah.
I might suggest trying the attached converter, which will ignore broken topics.
Krelin, could you also try this converter? In addition to making it ignore topics, I made it go over the data in smaller chunks ("more carefully" so to speak.)
Just use the same convert.php.
-[Unknown]
Thank you! the port worked perfectly.
http://www.freakscene.net/smf
The problem appeared to be some old posts that lost their owners (from an old ubb -> phpbb conversion a few years back). I'm working on some update sql to apply a 'default' account to those.
Thanks again!
ALSO - you guys got a mention in this months Inc. Magazine (http://www.inc.com). The one with Paul Frank on the Cover. It mentions you guys on page 36 in an article about Nick Bradbury (http://www.bradsoft.com). Just incase you were interested :)
Quote from: Grudge on July 24, 2005, 12:53:39 PM
Can you log in as anything else? As a temporary measure to get you into the admin panel can you:
1) Register a new account, called something like "admin_test"
2) Open up phpMyAdmin, and run this query on the smf database:
UPDATE smf_members SET ID_GROUP = 1 WHERE memberName="admin_test" LIMIT 1
That will give this test account admin rights. Using the test account login to your forum and make sure that all the old members were transferred over etc. Also, go to the admin centre and go "Maintenance => Fix and Repair all errors", and also "Recount all totals". Then, using this test account look at your "old" admin profile and check it actually exists - and that it is in the admin group.
Let me know how you get on :)
Thanks.
HELP ! ! !
I Cannot convert at all.
I use this coverter (http://www.simplemachines.org/community/index.php?action=dlattach;topic=38966.0;attach=11024)
and this SQL (http://www.simplemachines.org/community/index.php?action=dlattach;topic=38966.0;attach=11043)
from this place (http://www.simplemachines.org/community/index.php?topic=38966.0)
but this is the result
QuoteConverting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members...
Warning: copy(/home/ldgtuhan/public_html/forum/images/avatars/50588344143cd0bba427f5.jpg): failed to open stream: No such file or directory in /home/ldgtuhan/public_html/komunitas/convert.php(814) : eval()'d code on line 35
Warning: copy(/home/ldgtuhan/public_html/forum/images/avatars/967916812441ba7057abc8.gif): failed to open stream: No such file or directory in /home/ldgtuhan/public_html/komunitas/convert.php(814) : eval()'d code on line 35
Warning: copy(/home/ldgtuhan/public_html/forum/images/avatars/77622236744280592b0f37.jpg): failed to open stream: No such file or directory in /home/ldgtuhan/public_html/komunitas/convert.php(814) : eval()'d code on line 35
Warning: copy(/home/ldgtuhan/public_html/forum/images/avatars/9374642824426ae9e2e056.gif): failed to open stream: No such file or directory in /home/ldgtuhan/public_html/komunitas/convert.php(814) : eval()'d code on line 35
Warning: copy(/home/ldgtuhan/public_html/forum/images/avatars/1431564150444f0dc7a2369.jpg): failed to open stream: No such file or directory in /home/ldgtuhan/public_html/komunitas/convert.php(814) : eval()'d code on line 35
Warning: copy(/home/ldgtuhan/public_html/forum/images/avatars/903610184444c56103e12f.jpg): failed to open stream: No such file or directory in /home/ldgtuhan/public_html/komunitas/convert.php(814) : eval()'d code on line 35
Warning: copy(/home/ldgtuhan/public_html/forum/images/avatars/8197335584476cd21e2161.jpg): failed to open stream: No such file or directory in /home/ldgtuhan/public_html/komunitas/convert.php(814) : eval()'d code on line 35
Warning: copy(/home/ldgtuhan/public_html/forum/images/avatars/9441196914471fe5eacbff.jpg): failed to open stream: No such file or directory in /home/ldgtuhan/public_html/komunitas/convert.php(814) : eval()'d code on line 35
Warning: copy(/home/ldgtuhan/public_html/forum/images/avatars/8153646354472eb7dac849.jpg): failed to open stream: No such file or directory in /home/ldgtuhan/public_html/komunitas/convert.php(814) : 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 `ldgtuhan_joomla`.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 ('519', '0', '1137', '4569', '2', '488', '5', '', '0', '3', '236'),
('520', '0', '1138', '1138', '2', '2', '5', '', '0', '0', '124'),
('521', '0', '16', '80', '3', '38', '44', '', '0', '2', '158'),
('522', '0', '44', '44', '6', '6', '44', '', '0', '0', '92'),
('524', '0', '144', '144', '-1', '-1', '44', '', '0', '0', '60'),
.
.
.
.
.
.
('1021', '0', '4061', '4061', '365', '365', '13', '', '0', '0', '59'),
('1022', '0', '4077', '4080', '213', '16', '30', '', '0', '1', '27'),
('1023', '0', '4087', '4087', '213', '213', '24', '', '0', '0', '150'),
('1024', '0', '4088', '4088', '213', '213', '24', '', '0', '0', '127'),
('1025', '0', '4089', '11330', '213', '719', '39', '', '0', '3', '110'),
('1026', '0', '4093', '4116', '213', '213', '39', '', '0', '2', '115'),
('1027', '0', '4094', '4094', '213', '213', '5', '', '0', '0', '59');
Caused the error:
Duplicate entry '80-44' for key 2
what should I do ????
after I click "try again"
this is what happened
[quote[Converting...
Converting topics... Unsuccessful!
This query:
INSERT INTO `ldgtuhan_joomla`.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 ('519', '0', '1137', '4569', '2', '488', '5', '', '0', '3', '236'),
('520', '0', '1138', '1138', '2', '2', '5', '', '0', '0', '124'),
('521', '0', '16', '80', '3', '38', '44', '', '0', '2', '158'),
('522', '0', '44', '44', '6', '6', '44', '', '0', '0', '92'),
('524', '0', '144', '144', '-1', '-1', '44', '', '0', '0', '60'),
('525', '0', '811', '811', '6', '6', '44', '', '0', '0', '21'),
('528', '0', '1149', '23090', '177', '817', '42', '', '0', '19', '354'),
.
.
.
.
.
.
.
.
('1023', '0', '4087', '4087', '213', '213', '24', '', '0', '0', '150'),
('1024', '0', '4088', '4088', '213', '213', '24', '', '0', '0', '127'),
('1025', '0', '4089', '11330', '213', '719', '39', '', '0', '3', '110'),
('1026', '0', '4093', '4116', '213', '213', '39', '', '0', '2', '115'),
('1027', '0', '4094', '4094', '213', '213', '5', '', '0', '0', '59');
Caused the error:
Duplicate entry '519' for key 1
[/quote]
I am frustrated
Try using the converter in this topic: phpBB 2.0.19+ (http://www.simplemachines.org/community/index.php?topic=142124)