MySQL Forums
Forum List  »  GIS

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?
3404
May 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.