I just tried to install Alchemy rc6 and got the following:

BLOB/TEXT column 'data' can't have a default value query: CREATE TABLE alchemy_cache ( `nid` INT unsigned NOT NULL DEFAULT 0, `path` TEXT DEFAULT NULL, `created` INT unsigned NOT NULL DEFAULT 0, `command` TEXT DEFAULT NULL, `data` TEXT NOT NULL DEFAULT '', INDEX nid (nid), INDEX path (path(18)) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in [My Path]\Drupal6\includes\database.inc on line 551.

Alchemy: 6.x=1.0 rc6
Drupal Version: 6.20
PHP: 5.3.5
MySQL 5.1.5
Apache 2.2

Comments

TomDude48’s picture

TomDude48 commented
Status: Active » Needs review

This is a bug in certain versions of MySQL. I did go ahead and remove the DEFAULT '' that it is complaining about anyways.

Go ahead and install the dev branch (after it updates). That should work.

WideGlide94’s picture

WideGlide94 commented

Just wanted you to know that the dev version installed without a hitch. Thanks!

TomDude48’s picture

TomDude48 commented
Status: Needs review » Fixed

cool

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.