I assume this is a gmap.module function rather than a location.module one because it accepts co-ordinates rather than post codes ;)

  1. Enabling the filter shows a completely blank Gmap - no navigation controls or anything.
  2. On Submitting the view, the co-ordinates I enter into the filter settings vanish and I get the following 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 '1 WHERE cid = 'views_tables'' at line 1 query: DELETE FROM 1 WHERE cid = 'views_tables' in .../includes/database.mysql.inc on line 172.
  3. naturally enough exposing the filter doesn't really work ... It centres itself on some place in Rwanda at maximum (= unsupported ;) zoom ...
CommentFileSizeAuthor
#12 location_cache.patch744 bytestemujin9
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

jamesJonas’s picture

jamesJonas CreditAttribution: jamesJonas commented

Same error. I have not been able to track down its cause.

WHERE cid = 'views_tables'

cid - this may be inside the table 'cache_views'
I do have an entry for cid = 'views_tables:en'

This looks like an attempt to clear part of the cache.

Hope this helps.

bdragon’s picture

bdragon CreditAttribution: bdragon commented
Project: GMap Module » Location Views
Version: 5.x-1.x-dev »

Nope, it's a location_views problem.

Specifically, location_views_pre_view() isn't being nice.

wolfderby’s picture

wolfderby CreditAttribution: wolfderby commented

Same Error

csc4’s picture

csc4 CreditAttribution: csc4 commented

Same error here - anyone found a fix?

Tpainton-1’s picture

Tpainton-1 CreditAttribution: Tpainton-1 commented

SAME ERROR. This is too bad. I really need to implement this.

I am basically filtering frontpage content based on proximity to users zipcode.

fatfish’s picture

fatfish CreditAttribution: fatfish commented

Same issue. Any solutions yet ?

eggthing’s picture

eggthing CreditAttribution: eggthing commented

Yup. Same here.

rup3rt’s picture

rup3rt CreditAttribution: rup3rt commented

CVS looks close, will test

ehtesham’s picture

ehtesham CreditAttribution: ehtesham commented

I got the same problem while trying to list contents based on proximity map.

Turkish Delight’s picture

Turkish Delight CreditAttribution: Turkish Delight commented

Same error

tom_o_t’s picture

tom_o_t CreditAttribution: tom_o_t commented

Same problem on a site with:

location modules 5.x-1.x-dev
gmap modules 5.x-1.x-dev

But don't get this error with similar configuration on another site using:

location 5.x-3.x-dev
gmap 5.x-1.x-dev

So upgrading should fix this - just be careful as the upgrade path is not always always smooth - backup!

temujin9’s picture

temujin9 CreditAttribution: temujin9 commented
Status: Active » Needs review
FileSize
location_cache.patch744 bytes

Problem was a bad invocation of cache_clear_all in location_views.module, corrected in the attached patch.