RC2 - error at saving and recreating data?

[Wissi]

Hey,
I was just playing around with saving and recreating data in the MySQL-database. The data I saved was without the table structure. I installed a new SMF and uploaded the sql-file. There I got following error:

SQL-Befehl:

# --------------------------------------------------------
#
# Dumping data in `smf_board_permissions`
#
INSERT INTO `smf_board_permissions` (
`ID_GROUP` ,
`ID_BOARD` ,
`permission` ,
`addDeny`
)
VALUES (
-1, 0, 'poll_view', 1
), ( 0, 0, 'poll_view', 1 ) , ( 0, 0, 'poll_post', 1 ) , ( 0, 0, 'poll_add_own', 1 ) , ( 0, 0, 'modify_own', 1 ) , ( 0, 0, 'mark_notify', 1 ) , ( 2, 0, 'modify_own', 1 ) , ( 2, 0, 'delete_any', 1 ) , ( 2, 0, 'lock_any', 1 ) , ( 2, 0, 'remove_any', 1 ) , ( 2, 0, 'post_reply_own', 1 ) , ( 2, 0, 'post_reply_any', 1 ) , ( 2, 0, 'delete_own', 1 ) , ( 2, 0, 'merge_any', 1 ) , ( 2, 0, 'post_new', 1 ) , ( 2, 0, 'modify_any', 1 ) , ( 2, 0, 'split_any', 1 ) , ( 2, 0, 'make_sticky', 1 ) , ( 2, 0, 'move_any', 1 ) , ( 2, 0, 'lock_own', 1 ) , ( 2, 0, 'moderate_board', 1 ) , ( 3, 0, 'delete_any', 1 ) , ( 3, 0, 'delete_own', 1 ) , ( 3, 0, 'lock_any', 1 ) , ( 3, 0, 'remove_any', 1 ) , ( 3, 0, 'post_reply_own', 1 ) , ( 3, 0, 'post_reply_any', 1 ) , ( 3, 0, 'merge_any', 1 ) , ( 3, 0, 'post_new', 1 ) , ( 3, 0, 'modify_own', 1 ) , ( 3, 0, 'split_any', 1 ) , ( 3, 0, 'make_sticky', 1 ) , ( 3, 0, 'move_any', 1 ) , ( 3, 0, 'lock_own', 1 ) , ( 3, 0, 'moderate_board', 1 ) , (
-1, 2, 'post_new', 1
), ( 0, 2, 'post_new', 1 ) , ( 0, 2, 'post_reply_own', 1 ) , ( 0, 2, 'post_reply_any', 1 ) , ( 0, 2, 'poll_post', 1 ) , ( 0, 2, 'poll_view', 1 ) , ( 0, 2, 'poll_vote', 1 ) , ( 0, 2, 'poll_add_own', 1 ) , ( 0, 2, 'report_any', 1 ) , ( 0, 2, 'lock_own', 1 ) , ( 0, 2, 'send_topics', 1 ) , ( 0, 2, 'mark_any_notify', 1 ) , ( 0, 2, 'mark_notify', 1 ) , ( 0, 2, 'delete_own', 1 ) , ( 0, 2, 'modify_own', 1 ) , ( 2, 2, 'moderate_board', 1 ) , ( 2, 2, 'post_new', 1 ) , ( 2, 2, 'post_reply_own', 1 ) , ( 2, 2, 'post_reply_any', 1 ) , ( 2, 2, 'poll_post', 1 ) , ( 2, 2, 'poll_add_any', 1 ) , ( 2, 2, 'poll_view', 1 ) , ( 2, 2, 'poll_vote', 1 ) , ( 2, 2, 'poll_edit_any', 1 ) , ( 2, 2, 'report_any', 1 ) , ( 2, 2, 'lock_own', 1 ) , ( 2, 2, 'send_topics', 1 ) , ( 2, 2, 'mark_any_notify', 1 ) , ( 2, 2, 'mark_notify', 1 ) , ( 2, 2, 'delete_own', 1 ) , ( 2, 2, 'modify_own', 1 ) , ( 2, 2, 'make_sticky', 1 ) , ( 2, 2, 'lock_any', 1 ) , ( 2, 2, 'remove_any', 1 ) , ( 2, 2, 'move_any', 1 ) , ( 2, 2, 'merge_any', 1 ) , ( 2, 2, 'split_any', 1 ) , ( 2, 2, 'delete_any', 1 ) , ( 2, 2, 'modify_any', 1 ) , ( 3, 2, 'moderate_board', 1 ) , ( 3, 2, 'post_new', 1 ) , ( 3, 2, 'post_reply_own', 1 ) , ( 3, 2, 'post_reply_any', 1 ) , ( 3, 2, 'poll_post', 1 ) , ( 3, 2, 'poll_add_own', 1 ) , ( 3, 2, 'poll_view', 1 ) , ( 3, 2, 'poll_vote', 1 ) , ( 3, 2, 'report_any', 1 ) , ( 3, 2, 'lock_own', 1 ) , ( 3, 2, 'send_topics', 1 ) , ( 3, 2, 'mark_any_notify', 1 ) , ( 3, 2, 'mark_notify', 1 ) , ( 3, 2, 'delete_own', 1 ) , ( 3, 2, 'modify_own', 1 ) , ( 3, 2, 'make_sticky', 1 ) , ( 3, 2, 'lock_any', 1 ) , ( 3, 2, 'remove_any', 1 ) , ( 3, 2, 'move_any', 1 ) , ( 3, 2, 'merge_any', 1 ) , ( 3, 2, 'split_any', 1 ) , ( 3, 2, 'delete_any', 1 ) , ( 3, 2, 'modify_any', 1 ) , (
-1, 2, 'post_reply_own', 1
), (
-1, 2, 'post_reply_any', 1
), (
-1, 2, 'delete_own', 1
), (
-1, 2, 'modify_own', 1
), (
-1, 2, 'poll_view', 1
), ( 14, 0, 'poll_post', 1 ) , ( 14, 0, 'poll_view', 1 ) , ( 14, 0, 'poll_vote', 1 ) , ( 10, 0, 'poll_edit_any', 1 ) , ( 10, 0, 'poll_add_any', 1 ) , ( 10, 0, 'poll_post', 1 ) , ( 10, 0, 'poll_vote', 1 ) , ( 10, 0, 'poll_view', 1 ) , ( 10, 0, 'report_any', 1 ) , ( 10, 0, 'modify_any', 1 ) , ( 10, 0, 'modify_own', 1 ) , ( 10, 0, 'delete_any', 1 ) , ( 10, 0, 'delete_own', 1 ) , ( 10, 0, 'post_reply_any', 1 ) , ( 10, 0, 'post_reply_own', 1 ) , ( 10, 0, 'remove_any', 1 ) , ( 10, 0, 'lock_any', 1 ) , ( 10, 0, 'lock_own', 1 ) , ( 10, 0, 'move_any', 1 ) , ( 10, 0, 'make_sticky', 1 ) , ( 10, 0, 'split_any', 1 ) , ( 10, 0, 'merge_any', 1 ) , ( 10, 0, 'post_new', 1 ) , ( 10, 0, 'moderate_board', 1 ) , ( 10, 2, 'remove_any', 1 ) , ( 10, 2, 'lock_any', 1 ) , ( 10, 2, 'lock_own', 1 ) , ( 10, 2, 'make_sticky', 1 ) , ( 10, 2, 'mark_any_notify', 1 ) , ( 10, 2, 'mark_notify', 1 ) , ( 10, 2, 'merge_any', 1 ) , ( 10, 2, 'moderate_board', 1 ) , ( 10, 2, 'modify_any', 1 ) , ( 10, 2, 'modify_own', 1 ) , ( 10, 2, 'move_any', 1 ) , ( 10, 2, 'poll_add_any', 1 ) , ( 10, 2, 'poll_edit_any', 1 ) , ( 10, 2, 'poll_post', 1 ) , ( 10, 2, 'poll_view', 1 ) , ( 10, 2, 'poll_vote', 1 ) , ( 10, 2, 'post_new', 1 ) , ( 10, 2, 'post_reply_any', 1 ) , ( 10, 2, 'post_reply_own', 1 ) , ( 10, 2, 'delete_any', 1 ) , ( 10, 2, 'delete_own', 1 ) , ( 10, 2, 'report_any', 1 ) , ( 10, 2, 'send_topics', 1 ) , ( 10, 2, 'split_any', 1 ) , ( 14, 0, 'send_topic', 1 ) , ( 14, 0, 'report_any', 1 ) , ( 14, 0, 'post_reply_own', 1 ) , ( 14, 0, 'post_reply_any', 1 ) , ( 14, 0, 'post_new', 1 ) , ( 14, 0, 'modify_own', 1 ) , (
-1, 0, 'view_attachments', 1
), ( 0, 0, 'poll_vote', 1 ) , ( 0, 0, 'post_attachment', 1 ) , ( 0, 0, 'poll_lock_own', 1 ) , ( 2, 0, 'report_any', 1 ) , ( 2, 0, 'poll_view', 1 ) , ( 2, 0, 'poll_vote', 1 ) , ( 2, 0, 'poll_post', 1 ) , ( 2, 0, 'poll_add_any', 1 ) , ( 2, 0, 'poll_edit_any', 1 ) , ( 2, 0, 'mark_any_notify', 1 ) , ( 2, 0, 'mark_notify', 1 ) , ( 2, 0, 'view_attachments', 1 ) , ( 3, 0, 'modify_any', 1 ) , ( 3, 0, 'report_any', 1 ) , ( 3, 0, 'poll_view', 1 ) , ( 3, 0, 'poll_vote', 1 ) , ( 3, 0, 'poll_post', 1 ) , ( 3, 0, 'poll_add_own', 1 ) , ( 3, 0, 'mark_any_notify', 1 ) , ( 3, 0, 'mark_notify', 1 ) , ( 3, 0, 'view_attachments', 1 ) , ( 10, 0, 'mark_any_notify', 1 ) , ( 10, 0, 'mark_notify', 1 ) , ( 10, 0, 'view_attachments', 1 ) , ( 8, 0, 'post_reply_own', 1 ) , ( 14, 0, 'post_attachment', 1 ) , ( 14, 0, 'poll_add_own', 1 ) , ( 4, 0, 'poll_post', 1 ) , ( 14, 0, 'mark_notify', 1 ) , ( 14, 0, 'mark_any_notify', 1 ) , ( 8, 0, 'view_attachments', 1 ) , ( 8, 0, 'send_topic', 1 ) , ( 8, 0, 'report_any', 1 ) , ( 8, 0, 'post_new', 1 ) , ( 8, 0, 'post_reply_any', 1 ) , ( 8, 0, 'post_attachment', 1 ) , ( 0, 0, 'post_new', 1 ) , ( 0, 0, 'mark_any_notify', 1 ) , ( 4, 0, 'poll_add_own', 1 ) , ( 4, 0, 'modify_own', 1 ) , ( 4, 0, 'report_any', 1 ) , ( 4, 0, 'poll_view', 1 ) , ( 4, 0, 'poll_vote', 1 ) , ( 4, 0, 'send_topic', 1 ) , ( 4, 0, 'post_reply_own', 1 ) , ( 4, 0, 'post_reply_any', 1 ) , ( 8, 0, 'poll_vote', 1 ) , ( 8, 0, 'poll_view', 1 ) , ( 8, 0, 'poll_post', 1 ) , ( 8, 0, 'poll_add_own', 1 ) , ( 8, 0, 'modify_own', 1 ) , ( 8, 0, 'mark_notify', 1 ) , ( 8, 0, 'mark_any_notify', 1 ) , ( 15, 0, 'view_attachments', 1 ) , ( 15, 0, 'send_topic', 1 ) , ( 15, 0, 'report_any', 1 ) , ( 15, 0, 'post_reply_own', 1 ) , ( 15, 0, 'post_reply_any', 1 ) , ( 15, 0, 'post_new', 1 ) , ( 15, 0, 'post_attachment', 1 ) , ( 15, 0, 'poll_vote', 1 ) , ( 15, 0, 'poll_view', 1 ) , ( 15, 0, 'poll_post', 1 ) , ( 15, 0, 'poll_add_own', 1 ) , ( 15, 0, 'modify_own', 1 ) , ( 15, 0, 'mark_notify', 1 ) , ( 15, 0, 'mark_any_notify', 1 ) , ( 12, 0, 'view_attachments', 1 ) , ( 12, 0, 'send_topic', 1 ) , ( 12, 0, 'report_any', 1 ) , ( 12, 0, 'post_reply_own', 1 ) , ( 12, 0, 'post_reply_any', 1 ) , ( 12, 0, 'post_new', 1 ) , ( 12, 0, 'post_attachment', 1 ) , ( 12, 0, 'poll_vote', 1 ) , ( 12, 0, 'poll_view', 1 ) , ( 12, 0, 'poll_post', 1 ) , ( 12, 0, 'poll_add_own', 1 ) , ( 12, 0, 'modify_own', 1 ) , ( 12, 0, 'mark_notify', 1 ) , ( 12, 0, 'mark_any_notify', 1 ) , ( 16, 0, 'view_attachments', 1 ) , ( 16, 0, 'send_topic', 1 ) , ( 16, 0, 'report_any', 1 ) , ( 16, 0, 'post_reply_own', 1 ) , ( 16, 0, 'post_reply_any', 1 ) , ( 16, 0, 'post_new', 1 ) , ( 16, 0, 'post_attachment', 1 ) , ( 16, 0, 'poll_vote', 1 ) , ( 16, 0, 'poll_view', 1 ) , ( 16, 0, 'poll_post', 1 ) , ( 16, 0, 'poll_add_own', 1 ) , ( 16, 0, 'modify_own', 1 )

MySQL meldet: Dokumentation
#1062 - Duplicate entry '-1-0-poll_view' for key 1

When I save it with the table structure and upload it into an empty database, SMF works perfectly.

Is this a bug or am I doing something wrong?
The database is about 3MB and the phpinfo is here (PHP Version 4.3.1/MySQL 3.23.55)