Closed (fixed)
Project:
Geo
Component:
Geo API
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
2 Mar 2009 at 17:35 UTC
Updated:
11 Jan 2010 at 14:42 UTC
When I'm trying to create a view using an exposed filter, I have seen this error:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 0, 10' at line 7 query: SELECT node.nid AS nid, users.name AS users_name, users.uid AS users_uid FROM drupal6_node node LEFT JOIN drupal6_content_field_geo3 node_data_field_geo3 ON node.vid = node_data_field_geo3.vid INNER JOIN drupal6_users users ON node.uid = users.uid WHERE NOT Equals(GeomFromText('POINT(10 10)', 4326), ) LIMIT 0, 10 in C:\xampp\htdocs\drupal\6\modules\views\includes\view.inc on line 731.
Reading this error, we can see that there isn't any column before NOT Equals, testing in my own MySQL Server, I have put 'field_geo3_wkt' brfore not Equals and it shows a different error,which I have solved writing '!=' instead of 'NOT Equals'.
This error is a bug or I'm doing something wrong when I create the view?
Thanks
Comments
Comment #1
allie mickaA great deal has changed in Geo since this report, including the non-existence of the wkt field. Can you confirm that this is no longer an issue and/or provide specific details on how the view is created (including a dump of the view, if possible)
Thanks!
Comment #2
allie mickaWithout feedback, I'm going to go ahead and close this. A lot has changed in Views support. I presume this error has gone away, but fear not: you'll have plenty of new bugs to report on :)
Comment #3
plopescHi!
This is an old issue and now this error has gone away...
Thanks and sorry for not to close old issues