search

creof / doctrine2-spatial

Doctrine2 multi-platform support for spatial types and functions.
MIT License
272 stars 174 forks source link

GeomFromText does not exist #201

Open r8or0pz opened 5 years ago

r8or0pz commented 5 years ago

Looks like MySQL 8 is not supported as there is no ST_ prefix in GeomFromText in default configuration, but according the doc it should work: https://github.com/creof/doctrine2-spatial/blob/master/doc/mysql.md

It is caused by https://github.com/creof/doctrine2-spatial/blob/master/lib/CrEOF/Spatial/DBAL/Platform/MySql.php#L72

How to enforce doctrine2-spatial to use ST_GeomFromText?

holtkamp commented 5 years ago

Related to https://github.com/creof/doctrine2-spatial/issues/193 and https://github.com/creof/doctrine2-spatial/pull/196

If really needed you can use this branch: https://github.com/holtkamp/doctrine2-spatial/tree/mysql-80-support

not for production use though: I might delete it when the PR gets merged.

@djlambert can you have a look at the PR? Been using it in production for 6 months now, works nicely

bradroc commented 1 year ago

Agree this would be really nice to have merged - we're running into the same issue