8 Posts
Taki
7 years ago
2
Topic

Hi,

I have created latitude, longitude, user_geocode and a dummy radius field. I followed the tutorial and also made sure the fields are unlocked.

I get the following error if I search with the radius search. I don't get the error without the radius. Search works file for results at the exact geo-cordinates. 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') HAVING distance < 25 ORDER BY t3.name ASC LIMIT 25' at line 7 SQL=SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias,(((acos(sin((-26.13755*pi()/180)) * sin((t1.latitude*pi()/180))+cos((-26.13755*pi()/180)) * cos((t1.latitude*pi()/180)) * cos(((28.0235- t1.longitude)*pi()/180))))*180/pi())*60*1.1515*1.609344) AS distance FROM `#__cck_core` AS t0 LEFT JOIN `#__cck_store_item_users` AS t1 ON t1.id = t0.pk LEFT JOIN `#__content` AS t2 ON t2.id = t0.pkb LEFT JOIN `#__users` AS t3 ON t3.id = t0.pk LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck WHERE t2.state = 1 AND t2.access IN (1,1) AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2017-04-24 13:01' ) AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2017-04-24 13:01' ) AND t0.storage_location = "joomla_user" AND () HAVING distance < 25 ORDER BY t3.name ASC LIMIT 25Text
Get a VIP membership
4229 Posts
Kadministrator
7 years ago
0
Level 1

"AND () HAVING distance < 25" - this indicates you did not set matching on radius field correctly

8 Posts
Taki
7 years ago
0
Level 1

I had the radius setup right.

What I cocked up was I by mistake removed the CCK field. Putting back and copying it's default settings from a different search app fixed the problem.

Thank You!!!

Get a VIP membership