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 (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.
*** 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.
