When I tried to convert mybb 1.4 to smf 1.1.11.
It gave the following error:-
Converting poll votes... Unsuccessful!
This query:
INSERT INTO `promasry_mybb`.smf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE)
VALUES ('0', '1', '3'),
('0', '11', '4'),
('0', '20', '1'),
('0', '20', '2'),
('0', '20', '4'),
('0', '20', '5'),
('0', '1', '3'),
('0', '20', '1'),
('0', '1', '1'),
('0', '11', '2'),
('0', '1', '0'),
('0', '1', '1'),
('0', '1', '2'),
('0', '11', '2'),
('0', '11', '4'),
('0', '11', '6'),
('0', '20', '3'),
('0', '20', '4'),
('0', '20', '9'),
('0', '1', '0'),
('0', '1', '4'),
('0', '1', '5'),
('0', '1', '10'),
('0', '11', '4'),
('0', '11', '5'),
('0', '11', '11'),
('0', '11', '12'),
('0', '20', '0'),
('0', '20', '5'),
('0', '20', '10'),
('0', '20', '11'),
('0', '1', '0'),
('0', '20', '0'),
('0', '11', '4'),
('0', '11', '7'),
('0', '20', '0'),
('0', '20', '1'),
('0', '20', '7'),
('0', '73', '2'),
('0', '1', '1'),
('0', '20', '0'),
('0', '1', '2'),
('0', '11', '2'),
('0', '20', '1'),
('0', '1', '0'),
('0', '20', '0'),
('0', '1', '0'),
('0', '20', '2'),
('0', '1', '1'),
('0', '11', '14'),
('0', '17', '31'),
('0', '20', '1'),
('0', '1', '0'),
('0', '7', '0'),
('0', '11', '3'),
('0', '20', '3'),
('0', '61', '5'),
('0', '1', '4'),
('0', '11', '2'),
('0', '20', '2'),
('0', '1', '0'),
('0', '11', '0'),
('0', '13', '0'),
('0', '20', '0'),
('0', '62', '0'),
('0', '63', '0'),
('0', '1', '1'),
('0', '11', '0'),
('0', '20', '0'),
('0', '1', '4'),
('0', '11', '1');
Caused the error:
Duplicate entry '0-1-3' for key 1
Please help!
Thank you in advance :)
This is the wrong board for help with conversions etc. The correct topic it should be moved to is this one: SMF Conveter MyBB 1.4 (http://www.simplemachines.org/community/index.php?topic=256073.0)
Looks like a member voted twice or was recorded twice for the same vote
('0', '1', '3'),
One of those should be removed does seem like a bug in the convertor though or something i