The Schema module reports a mismatch between the actual DB tables created with install and the ones specified.
Here are the error messages:
* nodemap.nodemap_latitude is type float but its default 0.000000 is PHP type string
* nodemap.nodemap_longitude is type float but its default 0.000000 is PHP type string
* nodemap.nodemap_serialized is type text and may not have a default value
*
nodemap
o column nodemap_latitude:
declared: array('type' => 'float', 'not null' => TRUE, 'default' => '0.000000', 'precision' => 10, 'scale' => 6)
actual: array('type' => 'float', 'not null' => TRUE, 'default' => 0, 'disp-width' => '10')
o column nodemap_latitude:
declared: array('type' => 'float', 'not null' => TRUE, 'default' => '0.000000', 'precision' => 10, 'scale' => 6)
actual: array('type' => 'float', 'not null' => TRUE, 'default' => 0, 'disp-width' => '10')
o column nodemap_latitude:
declared: array('type' => 'float', 'not null' => TRUE, 'default' => '0.000000', 'precision' => 10, 'scale' => 6)
actual: array('type' => 'float', 'not null' => TRUE, 'default' => 0, 'disp-width' => '10')
o column nodemap_longitude:
declared: array('type' => 'float', 'not null' => TRUE, 'default' => '0.000000', 'precision' => 10, 'scale' => 6)
actual: array('type' => 'float', 'not null' => TRUE, 'default' => 0, 'disp-width' => '10')
o column nodemap_longitude:
declared: array('type' => 'float', 'not null' => TRUE, 'default' => '0.000000', 'precision' => 10, 'scale' => 6)
actual: array('type' => 'float', 'not null' => TRUE, 'default' => 0, 'disp-width' => '10')
o column nodemap_longitude:
declared: array('type' => 'float', 'not null' => TRUE, 'default' => '0.000000', 'precision' => 10, 'scale' => 6)
actual: array('type' => 'float', 'not null' => TRUE, 'default' => 0, 'disp-width' => '10')
o column nodemap_address:
declared: array('type' => 'varchar', 'length' => 255, 'default' => '')
actual: array('type' => 'varchar', 'length' => '255', 'not null' => FALSE)
o column nodemap_serialized:
declared: array('type' => 'text', 'default' => '')
actual: array('type' => 'text', 'not null' => FALSE)
o column nodemap_address: key 'not null' not set, ignoring inspected default value
o column nodemap_serialized: key 'not null' not set, ignoring inspected default value
It is not clear to me if I want to change the DB or the declarations in the install page.
MySQL = Server version: 5.0.51b
Mac OS 10.5
Don't see how to edit the SQL in PHPMyAdmin to have a 'precision' => 10, 'scale' => 6.
The length => 10,6 which I assume is the same.
I'd like to get Schema to stop reporting errors.
Suggestions?
Comments
Comment #1
spinicrus commentedhi
try "float(10,6)", for the latitude & longitude fields in nodemap's table. also, you might try reading the mysql online manual ;)
10x,
cheers!
Comment #2
spinicrus commented