creof/doctrine2-spatial

GeomFromText does not exist

r8or0pz opened this issue · 2 comments

r8or0pz commented

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

Related to #193 and #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

  • 👍1
bradroc commented

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

  • 👍1