Skip navigation links

MySQL Forums :: GIS :: Moving from one server to another - GIS functionality disabled?


Advanced Search

Moving from one server to another - GIS functionality disabled?
Posted by: Stuart Harrison ()
Date: May 26, 2010 07:45AM

Hi,

I've recently moved hosts. My old host used version 5.0.77 and my query worked fine. My new host uses 5.0.45 and the GIS functionality doesn't seem to work. The structure of my table is as follows:

CREATE TABLE `county_electoral_division_region` (
`ID` int(11) NOT NULL,
`NAME` varchar(255) default NULL,
`AREA_CODE` varchar(255) default NULL,
`DESCRIPTIO` varchar(255) default NULL,
`FILE_NAME` varchar(255) default NULL,
`NUMBER` bigint(20) default NULL,
`NUMBER0` bigint(20) default NULL,
`POLYGON_ID` bigint(20) default NULL,
`UNIT_ID` bigint(20) default NULL,
`CODE` varchar(255) default NULL,
`HECTARES` double default NULL,
`AREA` double default NULL,
`TYPE_CODE` varchar(255) default NULL,
`DESCRIPT0` varchar(255) default NULL,
`TYPE_COD0` varchar(255) default NULL,
`DESCRIPT1` varchar(255) default NULL,
`ogc_geom` geometry default NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

And the query I'm trying to use is:

SELECT *, AsText(ogc_geom) AS myPolygon FROM `county_electoral_division_region` WHERE Contains(`ogc_geom`, GeomFromText('Point(412615.70121431 308884.54965959)'))

In phpmyadmin, I get the error "FUNCTION AsText does not exist", although if I repeat the query in a script, I get no errors, but no results. Any ideas where I might be going wrong?

Cheers

Options: ReplyQuote


Subject Views Written By Posted
Moving from one server to another - GIS functionality disabled? 2178 Stuart Harrison 05/26/2010 07:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.