MyBB Community Forums

I am getting this error
during modifying undo delete plugin

There are outdated backup tables you have to modify.

CREATE TABLE `mybb_backup_posts` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `tid` int(10) unsigned NOT NULL default '0',
  `replyto` int(10) unsigned NOT NULL default '0',
  `fid` smallint(5) unsigned NOT NULL default '0',
  `subject` varchar(120) NOT NULL default '',
  `icon` smallint(5) 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',
  `message` text NOT NULL,
  `ipaddress` varchar(30) NOT NULL default '',
  `longipaddress` int(11) NOT NULL default '0',
  `includesig` int(1) NOT NULL default '0',
  `smilieoff` int(1) NOT NULL default '0',
  `edituid` int(10) unsigned NOT NULL default '0',
  `edittime` int(10) NOT NULL default '0',
  `visible` int(1) NOT NULL default '0',
  `posthash` varchar(32) NOT NULL default '',
  `pthx` int(10) NOT NULL default '0',
  `system` varchar(32) NOT NULL default 'icon_unknown_s',
  `browser` varchar(32) NOT NULL default 'icon_unknown_b',
  PRIMARY KEY  (`pid`),
  KEY `tid` (`tid`,`uid`),
  KEY `uid` (`uid`),
  KEY `visible` (`visible`),
  KEY `dateline` (`dateline`),
  KEY `longipaddress` (`longipaddress`),
  FULLTEXT KEY `message` (`message`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

I am still waiting for solution.

It seems you have modified the table mybb_posts since your installation of Undo Delete. Backup table of posts and 'nornal' posts table must have the same structure. Now there are 2 ways you can do:

1. You modify the backup table yourself (the plugin shows you the differences you have to modify)
2. You recreate the table (just a simple click on Undo Delete plugin overview) but will loose all data (all backuped posts)

Thanks
Problem solved