This bug may be because phpMyAdmin does not support the
spatial extension to MySQL at all yet. If so, it would
be nice to support it soon.
When I try this query using phpMyAdmin:
SELECT AsText(g) FROM `geom`;
I get this error:
#1305 - FUNCTION liveugli-locations.AsText does not exist
This error does not come up on the mysql command line.
Here is the table creation and insert SQL queries:
CREATE TABLE geom (g GEOMETRY);
INSERT INTO `geom` (`g`) VALUES (GeomFromText('POINT(0
0)'));
Logged In: YES
user_id=192186
Support for spatial extgension is for long in feature
request tracker. Unfortunately none of developer use it, so
it is very low priority. In fact best would be if some user
of it would write or help with writing it.