MyBB Community Forums

I get this error message after trying to delete this thread http://inu-sekai.com.ar/foros/tema-soy-dark-naraku.html

Moderator test user of that subforum(you can't see that forum if you are not loged in as a team member)
user:dark_naraku
pass:dark_naraku

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1062 - Duplicate entry '19' for key 1
Query:
INSERT INTO mybb_backup_threads (`tid`,`fid`,`subject`,`prefix`,`icon`,`poll`,`uid`,`username`,`dateline`,`firstpost`,`lastpost`,`lastposter`,`lastposteruid`,`views`,`replies`,`closed`,`sticky`,`numratings`,`totalratings`,`notes`,`visible`,`unapprovedposts`,`attachmentcount`,`deletetime`,`tyl_tnumtyls`) VALUES ('19','28','Soy Dark Naraku!!!','0','8','0','3','Dark_Naraku','1302131569','17','1302131569','Dark_Naraku','3','4','0','0','0','0','0','','1','0','0','0','1')

That's not a default MyBB table, the error is being caused by a plugin - Undo Delete if I recall correctly.

Moved to plugin support.

Thanks, and yes it is undo delete plugin, any help.

It seems there exist already a backuped thread with ID 19, which is not possible because threads IDs are unique by default. Go to Admin CP > Tools & Maintenance > Undo Delete and delete the existing thread with ID 19 (or truncate the complete backup table).

It is solved now, but just to let you know before i truncate the table it give me out this error message.

CREATE TABLE `mybb_backup_threads` (
  `tid` int(10) unsigned NOT NULL auto_increment,
  `fid` smallint(5) unsigned NOT NULL default '0',
  `subject` varchar(120) NOT NULL default '',
  `prefix` smallint(5) unsigned NOT NULL default '0',
  `icon` smallint(5) unsigned NOT NULL default '0',
  `poll` int(10) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `username` varchar(80) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  `firstpost` int(10) unsigned NOT NULL default '0',
  `lastpost` bigint(30) NOT NULL default '0',
  `lastposter` varchar(120) NOT NULL default '',
  `lastposteruid` int(10) unsigned NOT NULL default '0',
  `views` int(100) NOT NULL default '0',
  `replies` int(100) NOT NULL default '0',
  `closed` varchar(30) NOT NULL default '',
  `sticky` int(1) NOT NULL default '0',
  `numratings` smallint(5) unsigned NOT NULL default '0',
  `totalratings` smallint(5) unsigned NOT NULL default '0',
  `notes` text NOT NULL,
  `visible` int(1) NOT NULL default '0',
  `unapprovedposts` int(10) unsigned NOT NULL default '0',
  `attachmentcount` int(10) unsigned NOT NULL default '0',
  `deletetime` int(10) unsigned NOT NULL default '0',
  `tyl_tnumtyls` int(100) NOT NULL default '0',
  `tw_id` varchar(20) NOT NULL default '0',
  `fb_id` varchar(50) NOT NULL default '0',
  `fb_uid` varchar(50) NOT NULL default '0',
  PRIMARY KEY  (`tid`),
  KEY `fid` (`fid`,`visible`,`sticky`),
  KEY `dateline` (`dateline`),
  KEY `lastpost` (`lastpost`,`fid`),
  KEY `firstpost` (`firstpost`),
  KEY `uid` (`uid`),
  FULLTEXT KEY `subject` (`subject`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Thank you for your help.