Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Incomplete
-
10.0.15
-
None
-
10.0.20
Description
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 ?