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

spinicrus’s picture

hi
try "float(10,6)", for the latitude & longitude fields in nodemap's table. also, you might try reading the mysql online manual ;)

10x,
cheers!

spinicrus’s picture

Status: Active » Closed (fixed)