I am using zend framework with MySQL. I am using Zend_Db_Table_Abstract to run queries. I have a spatial field in a table :
Country:
+------------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| region_id | int(5) | NO | | NULL | |
| coordinate | point | NO | MUL | NULL | |
+------------+---------+------+-----+---------+----------------+
Ben bu tabloda bir kayıt eklemek için çalışıyorum ama bir hata var:
Zend_Db_Statement_Exception: SQLSTATE[22003]: Numeric value out of range: 1416 Cannot get geometry object from data you send to the GEOMETRY field .
Bu by:
$this->insert(array('region_id'=>'1','coordinate'=>"GeomFromText( 'POINT(-12.461334 130.841904)'"));
Herkes yardımcı olabilir?