Last modified: 2010-05-15 15:42:48 UTC
Summary: Installation fails on WinXP/Apache2.2.2/MySQL5.0.22/PHP5.2.0-dev due to
1. Query Empty errors: Installation proceeds correctly to the "Creating
tables..." on config/index.php (805). The first query for creating table user
fails with a "Query was empty" error. Commenting out lines 615-619 in
Database.php removes the problem.
2. ipblocks Table Incorrect Sub Part Key Length: After commenting out the
logging function in database.php in #1 above, the installation fails again when
creating the ipblocks table. The MySQL error returned is "Incorrect sub part
key; the used key part isn't a string, the used length is longer than the key
part, or the storage engine doesn't support unique sub key.". Line 606 in
mysql5/tables.sql specifies a length of 255 for ipb_address, which is defined as
length 40 in line 568. Changing line 605 to length of 40 eliminates the error.
Installation proceeded correctly from this point forward.
Does this problem still occur with 1.9.0?
No response in a long time, assuming these are working in the latest versions
with updates to the installer and table defs.