Re: GIS functions not available?

[Joe Giordano]

I have a similar issue and have not figured out how to resolve it.

In PHPMyAdmin 2.8.2.4, in one case the functions seem to work, and in another case it does not.

case that seems to work:
--------------------------------------------------------
SET @g = 'LineString(1 1,2 2,3 3)';
SELECT AsText(GeomFromText(@g));

returns:
+--------------------------+
| AsText(GeomFromText(@g)) |
+--------------------------+
| LINESTRING(1 1,2 2,3 3) |
+--------------------------+


case that does not seem to work:
--------------------------------------------------------
SELECT AsText(ogc_geom) FROM my_spatial_table WHERE id = 1

returns error "#1305 - FUNCTION mydb.AsText does not exist"

(ogc_geom is type GEOMETRY)

row id=1 has the following (this insert also worked):
INSERT INTO my_spatial_table VALUES('1',GeometryFromText('MULTIPOLYGON(((-86.576391999999998 34.719791000000001 ,-86.577191999999997 34.719791000000001 ,-86.579059999999998 34.719779000000003 ,-86.585376999999994 34.719783000000000 ,-86.585391999999999 34.735590000000002 ,-86.575592000000000 34.735489999999999 ,-86.574492000000006 34.730690000000003 ,-86.573659000000006 34.719804000000003 ,-86.576391999999998 34.719791000000001 )))',-1) )