Weird "Operand should contain 1 column(s)" error

[youradds]

Hi,

I'm a bit baffled by this error I get:

Operand should contain 1 column(s)

..with the following query:

SELECT *, ( 6371 * acos( cos( radians('43,7335') ) * cos( radians( latitude ) ) * cos( radians( longitude )
- radians('2,3985') ) + sin( radians('43,7335') ) * sin( radians( latitude ) ) ) ) AS distance
FROM hotels_PrioritySpots spot WHERE spot.latitude BETWEEN (43,7335-0.7) AND (43,7335+0.7) AND spot.longitude BETWEEN (2,3985-1.1) AND (2,3985+1.1) AND spot.link_id_fk != 2312 HAVING distance < 50 ORDER BY distance LIMIT 5

The same code works fine on another site... so why wouldn't it be working here? AFAIK the code is all fine.

TIA

Andy

 

[youradds]

Never mind - found it. Someone someone got a lat/lng value with commas into the system. We have new checks for that now, so they must have got in some time before that