Hi,
I have a location table with columns lat, 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 geohash column.
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 NULL.
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.