I plan on moving my SMF board from my web site to someone else's web site. He can given me full permission to test everything before making the official switch.
We installed a fresh copy of SMF on his site and everything works fine. I made a backup of my board and imported it via his phpMyAdmin. I planned on adding mods and other things afterwards. But before I can do that, I get this error message on phpMyAdmin:
SQL query:
# -------------------------------------------------------- # # 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, 'post_new', 1), (0, 0, 'send_topic', 1), (2, 0, 'delete_own', 1), (2, 0, 'modify_replies', 1), (3, 0, 'modify_any', 1), (3, 0, 'modify_own', 1), (3, 0, 'remove_any', 1), (3, 0, 'remove_own', 1), (3, 0, 'remove_replies', 1), (3, 0, 'modify_replies', 1), (3, 0, 'post_reply_any', 1), (3, 0, 'post_reply_own', 1), (3, 0, 'delete_any', 1), (3, 0, 'delete_own', 1), (3, 0, 'lock_any', 1), (3, 0, 'lock_own', 1), (3, 0, 'move_any', 1), (3, 0, 'move_own', 1), (3, 0, 'make_sticky', 1), (3, 0, 'send_topic', 1), (3, 0, 'split_any', 1), (3, 0, 'merge_any', 1), (3, 0, 'post_new', 1), (3, 0, 'moderate_board', 1), (3, 0, 'post_attachment', 1), (3, 0, 'view_attachments', 1), (3, 0, 'mark_notify', 1), (3, 0, 'ma[...]
MySQL said:
#1062 - Duplicate entry '-1-0-poll_view' for key 'PRIMARY'
I am not well versed in this and have no idea what any of this means. I was hoping someone could give me a direction as to what the problem is. I did a backup of my board from the admin panel and from phpMyAdmin and neither will work.
Have you tried simply going to your site's CPanel and repairing the database?
It didn't work the first time. But I made another backup, did a repair of the table, and that finally worked. Thanks.
WooHoo! :)