Hi,
i am trying to convert a PHPBB 3.0.12 on a MySQL(i) 5.5.34-MariaDB-cll-lve to a SMF 2.0.8.
I started the conversion process using smf_2-0_phpbb3_converter, and the first duplicate key i was able to resolve. (purge users with 0 posts) After that, everything went fine untill converting posts:
Converting...
Converting posts...
Duplicate entry '3581' for key 'PRIMARY'
What can i do to resolve this? Is there a SQL statement for me to identify? (When i run SELECT * FROM `phpbb_posts` where post_id = '3581' i get only 1 hit.)
Grtzzzzz bellie
Can you try this converter here: http://www.simplemachines.org/community/index.php?topic=508551.0
Hi,
i started from the beginning, and got this with the ranks:
This query:
DELETE FROM `*username*_forum`.smf_membergroups
WHERE groupName LIKE 'phpBB %';
Caused the error:
Unknown column 'groupName' in 'where clause'
used the same convert.php, downloaded phpbb3_to_smf.sql from http://www.simplemachines.org/community/index.php?topic=508551.0 .
Oh, didn't see that coming :P
I need to check on the computer and be back ;)
Take your time!
maybe it has something to do with the fact that the first conversion run was ended half way, and this new script wants to begin from the start. I see all kind of _SMF tables in the PHPBB database, maybe delete that ones to start fresh?
hehe, dropped those conversion tables and i got:
Unsuccessful!
This query:
SELECT value
FROM `deb52898_forum`.smf_settings
WHERE variable = 'attachmentUploadDir'
LIMIT 1;
Caused the error:
Table 'deb52898_forum.smf_settings' doesn't exist
Guess the script does not auto restores itself..
No. You need to remove all SMF tables and reinstall it.
Later I'll explain how it works ;)
guess so, so i just did a new install of the basic forum.
got this one again:
Converting...
Converting ranks... Unsuccessful!
This query:
DELETE FROM `*username*_conv`.smf_membergroups
WHERE groupName LIKE 'phpBB %';
Caused the error:
Unknown column 'groupName' in 'where clause'
(the original version of the *.sql gets me untill the post section, this one does not like the ranks section :P )
Update: the script says groupName , and the column in the database says group_name, you are sure this is the correct version of the SQL corresponding with the latest version of SMF?
Yeah, I'm now looking at it and it seems this converter that I pointed you has several issues with column names, I'm sorry :( (It seems to use the names from 1.1.x)
So, back to the original converter :P
If you don't have more than 1 post with same ID, then I'm stomped, sorry. The easiest way to do that is to instruct the converter to ignore duplicates.
Find:
/******************************************************************************/
--- Converting posts...
/******************************************************************************/
TRUNCATE {$to_prefix}messages;
---* {$to_prefix}messages 200
---{
$ignore_slashes = true;
Add after:
$ignore = true;
that seems to work, thanks!
allthough it takes a while, 250.00 of 893.000 done after half an hour..
893.000 posts? :o Now that's something big ;)
Yeah, it will take a while. If you happen to have another issue that cause you to restart the converter, you can edit this line:
---* {$to_prefix}messages 200
And increase that "200". It will hammer your server a bit more but should make it faster ;)