I have one installation where the quick radius map and list map are not working.
The API is good because it plots the address I put in and the test is sucessful
Also, all addresses are geocoded.
However, when I run a list or a map no accounts are selected and I get a query error. I canāt paste it in here, because it thinks they are links and wonāt save.
Iām on 7.8.12 LTS and I have this feature working on other installations. Iām puzzled? Anyone can point me in the right direction?
I suppose you can paste it inside the forumās ācodeā tags, thereās a button on the toolbar to make it easier. Anyway, I often post links and they are allowedā¦
Is that query error you mention on-screen? Do you get any further errors in your logs?
AND jt0.deleted=0 LEFT JOIN users jt1 ON accounts.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON accounts.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN accounts jt3 ON accounts.parent_id=jt3.id AND jt3.deleted=0
AND jt3.deleted=0 LEFT JOIN campaigns jt4 ON accounts.campaign_id=jt4.id AND jt4.deleted=0
AND jt4.deleted=0 LEFT JOIN users jt5 ON accounts_cstm.user_id_c = jt5.id AND jt5.deleted=0 where ((accounts_cstm.jjwg_maps_lat_c != 0 OR accounts_cstm.jjwg_maps_lng_c != 0) AND (accounts_cstm.jjwg_maps_geocode_status_c = āOKā) AND (SQRT((69.1*((accounts_cstm.jjwg_maps_lat_c)-()))(69.1((accounts_cstm.jjwg_maps_lat_c)-()))+(53.0*((accounts_cstm.jjwg_maps_lng_c)-()) * COS(()/57.1))(53.0((accounts_cstm.jjwg_maps_lng_c)-()) * COS(()/57.1))) < 150.0000)) AND accounts.deleted=0 LIMIT 0,1000: MySQL error 1064: 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 ā)))(69.1((accounts_cstm.jjwg_maps_lat_c)-()))+(53.0*((accounts_cstm.jjwg_maps_ā at line 1
Sorry had to do it in two posts, I couldnāt submit it in one.
I have another installation generating the same kind of error, however, it works in the other installation. So Iām not sure thatās whatās causing this particular problem.
Those variables seem to be empty, when they shouldnāt. Your map needs a ācenterā but doesnāt have one. I donāt know what this means, Iām just observing from a quick view at the code.
I would look for an eariler problem, an error just before that one (even if it looks less serious). For some reason the data the map needs isnāt ready when it gets to that point in the codeā¦