Following error has been returned

user warning: BLOB/TEXT column 'options' can't have a default value query: CREATE TABLE workflows ( `wid` INT NOT NULL auto_increment, `name` VARCHAR(255) NOT NULL DEFAULT '', `tab_roles` VARCHAR(60) NOT NULL DEFAULT '', `options` LONGTEXT DEFAULT '', PRIMARY KEY (wid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\KM.devns\includes\database.inc on line 515.

Look like a typo in your scheme declaration - you should remove 'default' => '' in line 32 in workflow.install file

Comments

lusid’s picture

lusid commented

This is a similar issue that the Video module had, and should be fixable just by removing the default value from the install script for that field: http://drupal.org/node/143881

Default values for BLOB and TEXT fields were removed sometime in MySQL v5.x. You can find it in the documentation here:
http://dev.mysql.com/doc/refman/5.0/en/blob.html

In most respects, you can regard a BLOB column as a VARBINARY column that can be as large as you like. Similarly, you can regard a TEXT column as a VARCHAR column. BLOB and TEXT differ from VARBINARY and VARCHAR in the following ways:

  • There is no trailing-space removal for BLOB and TEXT columns when values are stored or retrieved. Before MySQL 5.0.3, this differs from VARBINARY and VARCHAR, for which trailing spaces are removed when values are stored.
  • On comparisons, TEXT is space extended to fit the compared object, exactly like CHAR and VARCHAR.
  • For indexes on BLOB and TEXT columns, you must specify an index prefix length. For CHAR and VARCHAR, a prefix length is optional. See Section 7.4.3, “Column Indexes”.
  • BLOB and TEXT columns cannot have DEFAULT values.
jvandyk’s picture

jvandyk commented
Status: Active » Fixed

Committed; will appear in 6.x-1.1. Thanks!

Status: Fixed » Closed (fixed)

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