My punbb subscriptions table has begun rejecting inserts, the error it throws is:
Duplicate entry '526-841' for key 1
However, in browsing through the database there's no entry of (user_id)526 (topic_id)841.
Doing a mysql structure dump on the table shows it's set up like this:
CREATE TABLE `pun_subscriptions` (
`user_id` int(10) unsigned NOT NULL default '0',
`topic_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`user_id`,`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Anyone have any suggestions for me? I saw something similar on another post:
http://punbb.org/forums/viewtopic.php?id=13126
Where he was instructed to just drop/recreate the table... I'd hate to lose my current subscriptions though.
Thanks in advance,
Ben
