https://bugzilla.wikimedia.org/show_bug.cgi?id=39657
Web browser: ---
Bug #: 39657
Summary: Updating the database from 1.11 to 1.19 doesn't apply
patch-log_user_text.sql
Product: MediaWiki
Version: 1.19.0
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Mobile Platform: ---
I'll re-test (and update this ticket) tomorrow to be sure this isn't a problem
with my update schema-separation code, but updating from 1.11 to 1.19 didn't
apply this patch so that I have the indices it creates. "show create table"
looks like this:
CREATE TABLE `logging` (
`log_type` varbinary(32) NOT NULL,
`log_action` varbinary(32) NOT NULL,
`log_timestamp` binary(14) NOT NULL DEFAULT '19700101000000',
`log_user` int(10) unsigned NOT NULL DEFAULT '0',
`log_namespace` int(11) NOT NULL DEFAULT '0',
`log_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL
DEFAULT '',
`log_comment` varchar(255) NOT NULL DEFAULT '',
`log_params` blob NOT NULL,
`log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`log_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
`log_user_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL
DEFAULT '',
`log_page` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`log_id`),
KEY `type_time` (`log_type`,`log_timestamp`),
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`),
KEY `type_action` (`log_type`,`log_action`,`log_timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=12803 DEFAULT CHARSET=latin1
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
