Post-hack error - forums: "SQL Error : 1062 Duplicate e

New Member Joined: Jun 26, 2006 Posts: 7

I recently had to restore my nuke_bb tables after an exploit and the hackers messed with nuke_bbconfig. Everything else on my phpnuke installation is working as it did normally now, except for the ability to post on the forums. Now my users cannot post because the following error comes up:

"Error in posting

DEBUG MODE

SQL Error : 1062 Duplicate entry '0' for key 1

INSERT INTO nuke_bbposts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES (4067, 1, 11, '', 1151423477, '46f78801', 1, 1, 1, 0)

Line : 241
File : functions_post.php"

I tried doing a repair on the nuke_bbposts table from phpmyadmin but that didnt work. Any suggestions appreciated. Thanks.

Paul

Posted: Tue Jun 27, 2006 10:02 am

Can you post the table structure for me please.

Posted: Tue Jun 27, 2006 10:30 am

--
-- Table structure for table `nuke_bbposts`
--

DROP TABLE IF EXISTS `nuke_bbposts`;
CREATE TABLE `nuke_bbposts` (
`post_id` mediumint( Cool

unsigned NOT NULL default '0',
`topic_id` mediumint( Cool

unsigned NOT NULL default '0',
`forum_id` smallint(5) unsigned NOT NULL default '0',
`poster_id` mediumint( Cool

NOT NULL default '0',
`post_time` int(11) NOT NULL default '0',
`poster_ip` varchar( Cool

NOT NULL default '',
`post_username` varchar(25) default NULL,
`enable_bbcode` tinyint(1) NOT NULL default '1',
`enable_html` tinyint(1) NOT NULL default '0',
`enable_smilies` tinyint(1) NOT NULL default '1',
`enable_sig` tinyint(1) NOT NULL default '1',
`post_edit_time` int(11) default NULL,
`post_edit_count` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`post_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_id` (`topic_id`),
KEY `poster_id` (`poster_id`),
KEY `post_time` (`post_time`)
) TYPE=MyISAM;