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

allie micka’s picture

Component: Code » Geo API
Status: Active » Postponed (maintainer needs more info)

A 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!

allie micka’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)

Without 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 :)

plopesc’s picture

Hi!

This is an old issue and now this error has gone away...

Thanks and sorry for not to close old issues