Feed aggregator

Mysql inconsistency with install - user warning: BLOB/TEXT column 'data' can't have a default value

Accessible Content Issue Queue - Sat, 2012-04-14 18:07

Installing on a windows 7 computer (mysql 5.5.15) get the following error during install:

user warning: BLOB/TEXT column 'data' can't have a default value query: update_sql /* admin : update_sql */ CREATE TABLE accessible_content_node_totals ( `nid` INT unsigned NOT NULL, `vid` INT unsigned NOT NULL, `severe_total` INT DEFAULT NULL, `moderate_total` INT DEFAULT NULL, `suggestion_total` INT DEFAULT NULL, `data` TEXT DEFAULT '' ) /*!40100 DEFAULT CHARACTER SET utf8

took this line out at line 101

'default' => '',

and worked...

See this bug:
http://bugs.mysql.com/bug.php?id=19498