Proximities Table / Task Master
hey all,
Might have missed a sql update here - if so can you point me int he right direction. If not, to use the proximities in Task Master i've changed the proximities table to avoid the error
[Debug] [07.15.09 - 20:33:02] MySQL Error: Field 'minx' doesn't have a default value
DROP TABLE IF EXISTS `ax_classic`.`proximities`;
CREATE TABLE `ax_classic`.`proximities` (
`zoneid` int(10) unsigned NOT NULL,
`exploreid` int(10) unsigned NOT NULL,
`minx` float(14,6) NOT NULL DEFAULT '0.000000',
`maxx` float(14,6) NOT NULL DEFAULT '1.000000',
`miny` float(14,6) NOT NULL DEFAULT '0.000000',
`maxy` float(14,6) NOT NULL DEFAULT '1.000000',
`minz` float(14,6) NOT NULL DEFAULT '0.000000',
`maxz` float(14,6) NOT NULL DEFAULT '1.000000',
PRIMARY KEY (`zoneid`,`exploreid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|