Moving from one server to another - GIS functionality disabled?

[Stuart Harrison]

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