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

madsph’s picture

This is still a problem.

Jorrit’s picture

It still is.

Anonymous’s picture

Still 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