BLOB/TEXT column 'nodemap_serialized' can't have a default value query
dkopecek - May 5, 2009 - 22:53
| Project: | Node Map |
| Version: | 6.x-1.3 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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.
#1
This is still a problem.
#2
It still is.