Hi, i wanted to convert YaBB 2.1 to SMF and i've got error:
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:
INSERT INTO `autobusi_smf1`.smf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE)
VALUES ('2', '0', '3'),
('2', '2', '2'),
('2', '0', '4'),
('2', '0', '4'),
('2', '108', '2'),
('2', '84', '0'),
('2', '0', '4'),
('2', '0', '4'),
('2', '0', '1'),
('2', '0', '4'),
('2', '0', '4'),
('2', '0', '4'),
('2', '23', '3'),
('2', '0', '5'),
('2', '0', '7'),
('2', '0', '3'),
('2', '0', '7'),
('2', '0', '5'),
('2', '0', '3'),
('2', '0', '0'),
('2', '0', '5'),
('2', '0', '0'),
('2', '0', '4'),
('2', '0', '4'),
('2', '0', '2'),
('2', '22', '1'),
('2', '0', '2'),
('2', '0', '0'),
('2', '109', '4'),
('2', '81', '7'),
('2', '95', '4'),
('2', '73', '4'),
('2', '49', '0'),
('3', '73', '7'),
('3', '22', '2'),
('3', '59', '3'),
('3', '62', '5'),
('3', '68', '3'),
('3', '83', '6'),
('3', '49', '0'),
('5', '53', '1'),
('5', '47', '3'),
('5', '29', '0'),
('5', '95', '0'),
('5', '78', '0'),
('5', '82', '1'),
('5', '49', '4'),
('13', '22', '2'),
('13', '62', '3'),
('13', '81', '4'),
('13', '73', '0'),
('13', '83', '2'),
('13', '49', '5');
Caused the error:
Duplicate entry '2-0-4' for key 1
I've found somewhere that I need to empty something in phpMyadmin, but i couldn't find it there..
Can someone help me?
well besides SMF not doing guest posting.. there is a bunch of guest posts.
The only way to get around this would be to remove the guest posts.
I know yabb runs flat file so I don't got any fancy queries to remove the guest posts sadly :(
I don't have any guest post. It was disabled, even guest viewing of forum.. :-\
Sorry I meant guest polls, a typo on my part.
From the query above it tells me that there is polls that guests are posting in.
Try the converter in the sticky on this board.
I'm having the same issue. Any ideas on how to resolve?
I appreciate the assistance and I look forward to running my SMF board!
Converting poll votes... Unsuccessful!
This query:
INSERT INTO `abibitum_smf1`.smf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE)
VALUES ('13', '71', '0,4'),
('13', '39', '0,4'),
('13', '42', '2'),
('13', '126', '2'),
('13', '128', '0,1'),
('9', '0', '0'),
('9', '0', '0'),
('9', '96', '0'),
('9', '0', '0'),
('9', '71', '0'),
('9', '256', '0'),
('9', '10', '0'),
('9', '91', '0'),
('9', '2', '0'),
('14', '324', '0'),
('14', '0', '0'),
('14', '42', '0'),
('14', '2', '0'),
('26', '136', '2'),
('26', '239', '2'),
('26', '2', '2'),
('26', '28', '2'),
('26', '42', '1'),
('26', '117', '2'),
('26', '10', '2'),
('26', '0', '2'),
('35', '7', '5,6'),
('35', '256', '0,1,4'),
('35', '2', '0,1,5'),
('35', '10', '0,5'),
('35', '71', '5'),
('35', '239', '1,2,5'),
('15', '6', '0'),
('15', '0', '0'),
('15', '0', '0'),
('15', '10', '0'),
('15', '2', '0'),
('4', '7', '2'),
('4', '200', '8'),
('4', '245', '7'),
('4', '10', '1'),
('4', '6', '2'),
('4', '57', '7'),
('4', '71', '1'),
('4', '239', '5,7'),
('17', '7', '0,1,3'),
('17', '254', '0'),
('17', '10', '0,2,4,7'),
('17', '256', '0,1,2,3,4,5,6'),
('17', '69', '0'),
('17', '0', '0'),
('17', '0', '0,2'),
('17', '200', '5'),
('17', '71', '0,3'),
('17', '2', '0,1,2,3,4,5,6,7'),
('17', '239', '0');
Caused the error:
Duplicate entry '13-71-0' for key 1
Which converter are you using?