Last modified: 2010-05-15 15:42:46 UTC
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
(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.
*** This bug has been marked as a duplicate of 7669 ***
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.