Installation of category module fails with following err msg: user warning: BLOB/TEXT column 'description' can't have a default value query: CREATE TABLE category ( cid int(10) unsigned NOT NULL default '0', cnid int(10) unsigned NOT NULL default '0', description longtext NOT NULL default '', weight tinyint(4) NOT NULL default '0', depth tinyint(4) NOT NULL default '0', PRIMARY KEY (cid), KEY tid (cnid), KEY weight (weight) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\drupal-5.1\includes\database.mysql.inc on line 172.

OS: Win XP/SP2
DB: MySQL 5.0.27 win 32
Drupal: 5.1

Upon googling some, I found out that this is not the only module failing this way.... maybe MySQL changed some default behavior? ie. forbidding default values for some data types?

Anyway the "bug" is easily worked around by manually creating the table without default val f0r description, however now you have to be careful to fill a description for new categories, or else the creation of such will fail (because the field is marked as NON NULL)