When converting a forum with 7873 messages, I get 1126 errors like this one :
- Code: Select all
Error while processing INSERT query
» SQL:INSERT INTO posts (post_id, topic_id, forum_id, poster_id, icon_id, poster_ip, post_time, enable_bbcode, enable_smilies, enable_sig, enable_magic_url, post_username, post_subject, post_attachment, post_edit_time, post_edit_count, post_edit_reason, post_edit_user, bbcode_uid, post_text, bbcode_bitfield, post_checksum) VALUES ('1639', '62', '9', '8', 0, '193.52.32.157', '1133805480', '1', '1', '1', 1, '', '', 0, 0, '0', '', '8', 'c30fe', 'certains considérerait la chose comme de l''art !! d''où droit d''auteur !!', 'EA==', '')
Array ( [message] => ERROR: duplicate key violates unique constraint "posts_pkey" [code] => )
After conversion ends, statistics say I only have 6748 messages on my new forum (so I've lost about 1126 messages).
But when adding number of posts of all the categories, I get 7881.
When analysing table phpbb_post, there is a difference of 1126 entries between phpBB2 and phpBB3 forums.
phpBB2 :
- number of messages (bottom of the page) : 7873
- number of messages (addition of categories' number) : 7873
- number of rows in phpbb_post : 7874
phpBB3 :
- number of messages (bottom of the page) : 6748
- number of messages (addition of categories' number) : 7881
- number of rows in phpbb_post : 6748
