|
After migration from 5.5 to 10.0
Activating SQL ERROR plugin , i get a bunch of SQL errors
http://pastebin.com/mrCksMrW
The offending query look like this
$req='SELECT p.num_ville,p.logo_global_simple as LOGO, v.x as long_dec,v.y as lat_dec FROM '.$this->latable_previ.' p INNER JOIN ville_coordonnees v ON v.num_ville=p.num_ville WHERE MBRContains(geomfromtext("POLYGON(('.round($oPoint_bg->x,2).' '.round($oPoint_bg->y,2).','.round($oPoint_hd->x,2).' '.round($oPoint_bg->y,2).','.round($oPoint_hd->x,2).' '.round($oPoint_hd->y,2).','.round($oPoint_hd->x,2).' '.round($oPoint_bg->y,2).','.round($oPoint_bg->x,2).' '.round($oPoint_bg->y,2).'))"),v.coord) and v.num_zoom_carto & '.$this->letypezoom.' ='.$this->letypezoom.' and p.date_heure ="'.$this->lecheance.'" and v.num_pays='.$this->num_pays;
|
i created the table following
CREATE TABLE geometry_columns (
|
`F_TABLE_CATALOG` varchar(256) DEFAULT NULL,
|
`F_TABLE_SCHEMA` varchar(256) DEFAULT NULL,
|
`F_TABLE_NAME` varchar(256) NOT NULL,
|
`F_GEOMETRY_COLUMN` varchar(256) NOT NULL,
|
`COORD_DIMENSION` int(11) DEFAULT NULL,
|
`SRID` int(11) DEFAULT NULL,
|
`TYPE` varchar(256) NOT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
Found from this blog entry http://sickel.net/blogg/?p=665
This trick calm down the error log but is that enough i don't really know ?
Any idea if this is a bug or a feature ?
|