[IPB 2.0.1] Polls causing problems

[basvcds]

Hi Everyone

I was just converting my old IPB board, when i got a couple of syntax errors regarding the polls. Since i dont care too much for those i just flushed my ibf_polls and the conversion went on. However, ik still got the following duplicate error and cant figure out what to do (or delete ) Since i deleted all the polls i dont know what else to look for. Could anyone help me with this? Your help would be highly appriciated.

Code Select Expand

INSERT INTO `gsforum2`.smf_log_polls
(ID_POLL, ID_MEMBER)
VALUES ('', '19'),
('', '19'),
('', '12'),
('', '23'),
('', '3'),
('', '8'),
('', '14'),
('', '3'),
('', '5'),
('', '1'),
('', '6'),
('', '7'),
('', '23'),
('', '12'),
('', '26'),
('', '4'),
('', '34'),
('', '16'),
('', '13'),
('', '26'),
('', '10'),
('', '6'),
('', '4'),
('', '8'),
('', '15'),
('', '34'),
('', '14'),
('', '7'),
('', '9'),
('', '17'),
('', '32'),
('', '39'),
('', '37'),
('', '33'),
('', '30'),
('', '16'),
('', '40'),
('', '19'),
('', '36'),
('', '20'),
('', '10'),
('', '48'),
('', '66'),
('', '26'),
('', '9'),
('', '7'),
('', '23'),
('', '12'),
('', '6'),
('', '14'),
('', '5'),
('', '20'),
('', '3'),
('', '21'),
('', '23'),
('', '14'),
('', '10'),
('', '1'),
('', '16'),
('', '34'),
('', '19'),
('', '7'),
('', '9'),
('', '26'),
('', '6'),
('', '66'),
('', '14'),
('', '19'),
('', '9'),
('', '12'),
('', '66'),
('', '23'),
('', '67'),
('', '6'),
('', '34'),
('', '5'),
('', '16'),
('', '7'),
('', '67'),
('', '10'),
('', '4'),
('', '5'),
('', '3'),
('', '16'),
('', '20'),
('', '5'),
('', '66'),
('', '9'),
('', '4'),
('', '6'),
('', '23'),
('', '1'),
('', '3'),
('', '12'),
('', '14'),
('', '19'),
('', '10'),
('', '7'),
('', '12'),
('', '67'),
('', '57'),
('', '4'),
('', '14'),
('', '5'),
('', '3'),
('', '6'),
('', '23'),
('', '20'),
('', '10'),
('', '19'),
('', '66'),
('', '32'),
('', '1'),
('', '7'),
('', '12'),
('', '1'),
('', '66'),
('', '7'),
('', '14'),
('', '32'),
('', '16'),
('', '10'),
('', '5'),
('', '12'),
('', '6'),
('', '19'),
('', '30'),
('', '20'),
('', '20'),
('', '10'),
('', '32'),
('', '67'),
('', '19'),
('', '34'),
('', '23'),
('', '74'),
('', '3'),
('', '14'),
('', '66'),
('', '9'),
('', '4'),
('', '16'),
('', '5'),
('', '111'),
('', '1'),
('', '21'),
('', '6'),
('', '43'),
('', '13'),
('', '76'),
('', '15'),
('', '12'),
('', '23'),
('', '19'),
('', '74'),
('', '6'),
('', '10'),
('', '16'),
('', '3'),
('', '67'),
('', '13'),
('', '14'),
('', '1'),
('', '9'),
('', '5'),
('', '7'),
('', '15'),
('', '4'),
('', '3'),
('', '1'),
('', '74'),
('', '19'),
('', '34'),
('', '23'),
('', '32'),
('', '6'),
('', '5'),
('', '14'),
('', '4'),
('', '9'),
('', '21'),
('', '13'),
('', '16'),
('', '15'),
('', '76'),
('', '12'),
('', '14'),
('', '4'),
('', '16'),
('', '66'),
('', '9'),
('', '15'),
('', '19'),
('', '5'),
('', '6'),
('', '13'),
('', '3'),
('', '76'),
('', '23'),
('', '34'),
('', '32'),
('', '74'),
('', '14'),
('', '5'),
('', '6'),
('', '4'),
('', '55'),
('', '23'),
('', '19'),
('', '9'),
('', '12'),
('', '3'),
('', '16'),
('', '66'),
('', '32'),
('', '34'),
('', '10'),
('', '74'),
('', '1');
Caused the error:
Duplicate entry '0-19-0' for key 1

[Kirby]

For some reason, that information is broken...the Poll IDs are empty (''). You might want to prune for those if IPB offers the feature or run a search and delete in PhpMyAdmin

[JayBachatero]

Also try the converter on the sticky on this board.