This looks similar to this closed issue: http://drupal.org/node/299203, but it seems to be still occuring.
Site is on drupal 6.10
Received this error on install:
user warning: BLOB/TEXT column 'nodemap_serialized' can't have a default value query: CREATE TABLE nodemap ( `nodemap_nid` INT unsigned NOT NULL, `nodemap_latitude` FLOAT(10, 6) NOT NULL DEFAULT '0.000000', `nodemap_longitude` FLOAT(10, 6) NOT NULL DEFAULT '0.000000', `nodemap_address` VARCHAR(255) DEFAULT '', `nodemap_serialized` TEXT DEFAULT '', UNIQUE KEY nodemap_nid (nodemap_nid), INDEX nodemap_lat_lon_index (nodemap_latitude, nodemap_longitude) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\www\xxxxx\includes\database.inc on line 515.
In nodemap.install, I changed this:
'nodemap_serialized' => array (
'description' => t('The serialized data field.'),
'type' => 'text',
'size' => 'normal',
'default' => ''
)
To this:
'nodemap_serialized' => array (
'description' => t('The serialized data field.'),
'type' => 'text',
'size' => 'normal'
)
And resolved the problem.
Comments
Comment #1
madsph commentedThis is still a problem.
Comment #2
Jorrit commentedIt still is.
Comment #3
Anonymous (not verified) commentedStill is a problem - and actually breaks the installation since the nodemap table is NOT being created, although the module is marked as installed. Throws a bunch of error messages later when the modules tries to access the nodemap table