Page MenuHomePhabricator

tables.sql MySQL Errors
Closed, ResolvedPublic

Description

Author: simon.mcfarlane

Description:
I encountered the following errors when running tables.sql from MediaWiki 1.10.0 against a MySQL v5.0 install on WindowsXP:

Line 848: "blob cannot have default"

old value: rc_params blob NOT NULL default '',
proposed new value: rc_params blob NOT NULL,

Line 1116: "error in SQL statement..."

old value: --- Used for storing page restrictions (i.e. protection levels)
proposed new value: -- Used for storing page restrictions (i.e. protection levels)

Minor annoyances, but thought I'd report them anyway.

Cheers,

Simon


Version: 1.10.x
Severity: minor

Details

Reference
bz10458

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:50 PM
bzimport set Reference to bz10458.
bzimport added a subscriber: Unknown Object (MLST).

This should be fixed in 1.10.1 and in 1.11.0, which I should be pushing out soonish.

If you can grab a 1.10 snapshot from SVN and test it that would be great:
http://svn.wikimedia.org/svnroot/mediawiki/branches/REL1_10/phase3

If you can't easily grab from SVN, I can make a temp snapshot for you.

robchur wrote:

Confirmed that the stable branch passes a standard installation under MySQL 5.0.27 in strict mode.