Author: bostoncello
Description:
Summary: Installation fails on WinXP/Apache2.2.2/MySQL5.0.22/PHP5.2.0-dev due to
two bugs:
- 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.
- 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.
Version: 1.8.x
Severity: critical
OS: Windows XP
Platform: PC