News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

phpBB .11 to SMF 2.0.5: Got error "Duplicate entry '4934' for key 'PRIMARY'

Started by unternico, December 20, 2013, 12:29:12 PM

Previous topic - Next topic

unternico

Hi folks.

Im triying to convert an old phpbb to the new smf on my own server and doesnt work.
Its quite a nightmare, we got always error like this ones -> Duplicate entry '4934' for key 'PRIMARY'
I got it first with 4931, deleted. 4932, deleted. 4934, again deleted. Need i to delete the whole old posts? damm!.

What i should do? im using the right converter from this website, i thought it should be more easy, isnt?

Thanks!

Oldiesmann

This happens sometimes, though I don't know if anyone knows exactly why.

To fix it, open up phpbb3_to_smf.sql

Find
TRUNCATE {$to_prefix}messages;

---* {$to_prefix}messages 200
---{


Replace
TRUNCATE {$to_prefix}messages;

---* {$to_prefix}messages 200
---{
$ignore = true;


That will cause the converter to ignore the "Duplicate entry" errors.
Michael Eshom
Christian Metal Fans

Advertisement: