Listing Display
Bug Id ?
171
Reporter ?
Andrew Petersen
Product/Version ?
Bugdar / 1.2.3
Status ?
Unconfirmed
Severity ?
Critical
Duplicate Of ?
- none -
Fixed in Revision ?
Mstone ?
Summary ?
SQL Error in table collation setting during INSTALL
Report Time ?
May 29, 2009 04:00 AM
Assignment ?
Robert
Resolution ?
Open
Priority ?
Normal
Dependencies ?
- none -
Mstone (old) ?


Votes
For: 0 (0%)
Against: 0 (0%)
Total: 0

May 29, 2009 04:00 AM Andrew Petersen
Line 128 of install/install.php:

$db->query("ALTER DATABASE $database COLLATE $COLLATION");

In my install, I changed it to:

$db->query("ALTER DATABASE `$database` COLLATE $COLLATION");

Notice the backticks around $database. Without them, my install failed, as my database had a dash in the name: ita-bugdar. Luckily, easily fixed!