Thread:Project:Support desk/Upgrading from 1.16.4 to 1.19.2 - rc timestamp error/reply (4)

Hi Mark,

This is the table structure from the database dump:

CREATE TABLE `tda_recentchanges` ( `rc_id` int(11) NOT NULL auto_increment,  `rc_timestamp` varbinary(14) NOT NULL default ,  `rc_cur_time` varbinary(14) NOT NULL default ,  `rc_user` int(10) unsigned NOT NULL default '0',  `rc_user_text` varbinary(255) NOT NULL,  `rc_namespace` int(11) NOT NULL default '0',  `rc_title` varbinary(255) NOT NULL default ,  `rc_comment` varbinary(255) NOT NULL default ,  `rc_minor` tinyint(3) unsigned NOT NULL default '0',  `rc_bot` tinyint(3) unsigned NOT NULL default '0',  `rc_new` tinyint(3) unsigned NOT NULL default '0',  `rc_cur_id` int(10) unsigned NOT NULL default '0',  `rc_this_oldid` int(10) unsigned NOT NULL default '0',  `rc_last_oldid` int(10) unsigned NOT NULL default '0',  `rc_type` tinyint(3) unsigned NOT NULL default '0',  `rc_moved_to_ns` tinyint(3) unsigned NOT NULL default '0',  `rc_moved_to_title` varbinary(255) NOT NULL default '', `rc_patrolled` tinyint(3) unsigned NOT NULL default '0', `rc_ip` varbinary(40) NOT NULL default '', `rc_old_len` int(11) default NULL, `rc_new_len` int(11) default NULL, `rc_deleted` tinyint(3) unsigned NOT NULL default '0', `rc_logid` int(10) unsigned NOT NULL default '0', `rc_log_type` varbinary(255) default NULL, `rc_log_action` varbinary(255) default NULL, `rc_params` blob, PRIMARY KEY (`rc_id`), KEY `rc_timestamp` (`rc_timestamp`), KEY `rc_namespace_title` (`rc_namespace`,`rc_title`), KEY `rc_cur_id` (`rc_cur_id`), KEY `new_name_timestamp` (`rc_new`,`rc_namespace`,`rc_timestamp`), KEY `rc_ip` (`rc_ip`), KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`), KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`) ) ENGINE=InnoDB AUTO_INCREMENT=56828 DEFAULT CHARSET=binary;

Hope that helps.

Ta