I have a
location table with columns
lng and the
geohash of the point, and associated
Location Phalcon model.
In MySQL I have a
before insert type trigger function that automatically generates the geohash (as a VARCHAR) when a location row is added, so if I put in the SQL:
INSERT INTO location (lat, lng) VALUES (100, 100);
the geohash for (100,100) is duly inserted in into the
However if I user phalcon like this ...
$location = new Location(); $location->lat = 100; $location->lng = 100; $location->save();
... the trigger is ignored (or perhaps the value it writes is overwritten) to
Am I missing something? Has anyone else had simillar isses with MySQL triggers vs. Phalcon. Would like to know why this is happening. Any ideas much appreciated.