MySQL 5 (strict mode) not detected during installation
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	• bzimport
	Dec 27 2006, 9:35 AM

Description

Author: emddudley

Description:
Installation fails with no error message for MediaWiki 1.8.2 on a Windows XP
system with Apache 2.2.3, PHP 5.2.0, and MySQL 5.0.27.

Last item on the installation screen is:

Creating tables... using MySQL 4 table defs...Query "long query was here" failed
with error code "BLOB/TEXT column 'user_password' can't have a default value
(localhost)

(query omitted for brevity)

Two problems: The installer detected MySQL 4 instead of 5, and it choked on
default values in the query.

There are two work-arounds, one of which is described at the provided URL (it
involves modifying the installer query to remove the default values). The other
is to disable MySQL strict mode.

Version: 1.8.x
Severity: normal
OS: Windows XP
Platform: PC
URL: http://www.mwusers.com/forums/showthread.php?t=2889

Details

Reference: bz8398

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:33 PM

• bzimport added a project: MediaWiki-Installer.

• bzimport set Reference to bz8398.

• bzimport added a subscriber: Unknown Object (MLST).

• bzimport created this task.Dec 27 2006, 9:35 AM

This bug has been marked as a duplicate of 7669 ***

robchur wrote:

I'd just like to briefly point out that MediaWiki didn't detect MySQL 4, per se;
rather, it used MySQL 4 table definitions, because you selected
"backwards-compatible UTF-8 handling" in the installer (or failed to select the
experimental mode). This is actually nothing to worry about.

MySQL 5 (strict mode) not detected during installationClosed, ResolvedPublicActions

Description

Details

Event Timeline

MySQL 5 (strict mode) not detected during installation
Closed, ResolvedPublic
Actions