Topic on Project:Support desk

[RESOLVED] Upgrading from 1.16.4 to 1.19.2 - rc_timestamp error

14
81.144.199.142 (talkcontribs)

Hi,

I've been trying to update my version of mediawiki, when I go through the command prompt I am getting this error.

I'm doing this at work and don't know a huge amount about this so any help would be appreciated. To help I found a forum where someone has had the same error and posted the error messages, I think they found a solution but I couldn't make any sense of it.

Link to forum: http://www.gossamer-threads.com/lists/wiki/mediawiki/283414

Thanks in advance!

MarkAHershberger (talkcontribs)

Could you post the output of what you're seeing? If that post has your error, could you add

 $wgShowExceptionDetails = true;

to the end of your LocalSettings.php file and try again?

81.144.199.142 (talkcontribs)

Hi Mark,

Thanks for your swift response, the output I am getting now:

Missing rc_timestamp field of recentchanges table. Should not happen.
Backtrace:
#0 [internal function]: MysqlUpdater->doIndexUpdate()
#1 C:\xampp\htdocs\millipedia\includes\installer\DatabaseUpdater.php(281): call_
user_func_array(Array, Array)
#2 C:\xampp\htdocs\millipedia\includes\installer\DatabaseUpdater.php(244): Datab
aseUpdater->runUpdates(Array, false)
#3 C:\xampp\htdocs\millipedia\maintenance\update.php(121): DatabaseUpdater->doUp
dates(Array)
#4 C:\xampp\htdocs\millipedia\maintenance\doMaintenance.php(105): UpdateMediaWik
i->execute()
#5 C:\xampp\htdocs\millipedia\maintenance\update.php(151): require_once('C:\xamp
p\htdocs...')
#6 {main}

Hope this helps.

Ta

MarkAHershberger (talkcontribs)

I'll try an upgrade from 1.16.4 myself, but I think that should work.

Since you're using XAMPP, could you paste the create the structure of the recentchanges table that you see in in phpmyadmin?

81.144.199.141 (talkcontribs)

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

MarkAHershberger (talkcontribs)

weird. The error is "Missing rc_timestamp field of recentchanges table" and yet, there it is:

CREATE TABLE `tda_recentchanges` (
 `rc_id` int(11) NOT NULL auto_increment,
 `rc_timestamp` varbinary(14) NOT NULL default 

That is strange. What versions do you have of php, mysql and mediawiki?

What OS is this mediawiki running on?

88.130.95.173 (talkcontribs)

And apart from Mark's questions: Are you really, really sure that for the table structure you have checked the same database as the one which MediaWiki uses?

81.144.199.141 (talkcontribs)

Hi Mark,

Just to confirm I am using the correct database.

Also the versions are:

PHP: 5.4.4
mySQL: 5.5.25a
Apache: 2.4.2

Just to add a bit more information, the database that millipedia is currently looking at is the old database version that we are trying to update aswell.

Ta

MarkAHershberger (talkcontribs)

You didn't give the OS, but I'll assume it is some sort of linux.

Could you paste your $wgDB* (except the pasword) settings from LocalSettings.php?

81.144.199.141 (talkcontribs)

Apologies, my OS is Windows 7 pro

db settings: ## Database settings

$wgDBtype           = "mysql";
$wgDBserver         = "localhost";
$wgDBname           = "milliwikidb2";
$wgDBuser           = "root";

Ta

MarkAHershberger (talkcontribs)

hrm... I don't see a $wgDBprefix but you clearly need one.

If you add

 $wgDBprefix = "tda_";

to your LocalSettings.php does that solve the problem?

81.144.199.141 (talkcontribs)

Hi Mark!

I did in fact have a $wgDBprefix var but it was an empty string. So I added that and it went through update process perfectly.

Thank you very much for your help.

174.125.89.129 (talkcontribs)

I had to add the underscore to the "tda_" in LocalSettings.php

Kghbln (talkcontribs)

Another potential reason for getting this is if you try to update a non-existing database. See task T236671.

Reply to "[RESOLVED] Upgrading from 1.16.4 to 1.19.2 - rc_timestamp error"