I'm trying to create a field which uses the MySQL Spatial/Geometry fields.. however I got stuck on insertion to the Database. Symphony by default 'cleans' up the Insert values by enclosing it within single quotes.

However this is giving me an issue with Spatial/Geometry types since I would need to define GeomFromText outside of these quotes. I know I could possibly do a manual insert in a single Query but I don't think it would be safe as it would probably create the field in database with potentially another field raising an error thus having an 'incorrect' entry in database.

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details