Posted by Dave Kopecek on May 5, 2009 at 10:53pm
Jump to:
| Project: | Node Map |
| Version: | 6.x-1.3 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
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
#1
This is still a problem.
#2
It still is.
#3
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