New to Drupal and Cookbook

When trying to enable Cookbook I get the following Error:

user warning: BLOB/TEXT column 'ingredients' can't have a default value query: CREATE TABLE drupal_cookbook_recipes ( `nid` INT unsigned NOT NULL, `vid` INT unsigned NOT NULL, `ingredients` TEXT DEFAULT '', `steps` TEXT DEFAULT '', `history` TEXT DEFAULT '', `video` TEXT DEFAULT '', `servings` INT unsigned NOT NULL, `partial_nid` INT unsigned DEFAULT NULL, `partial_pos` INT unsigned DEFAULT NULL, PRIMARY KEY (vid), INDEX nid (nid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\inetpub\Drupal\includes\database.inc on line 551.

Brand new installation and I had enabled Taxonomy Image before enabling Cookbook

Using a Windows Server 2008 with IIS 7.0 and a MySQL Server 5.5
Drupal 6.24
Cookbook 6x-1.6
Taxonomy Image 6x-1.6

Comments

daninino’s picture

daninino commented
Assigned: daninino » Unassigned
icc’s picture

icc commented
Component: Miscellaneous » Code
Assigned: Unassigned » icc
Priority: Normal » Minor
Status: Active » Fixed

It seems some versions of MySQL Server gives a warning when settings default value to blank. The default values has been removed in commit 2258787.

Thank you for reporting this issue.

Status: Fixed » Closed (fixed)

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