CMS MADE SIMPLE FORGE

Company Directory

 
Back Back to List

[#11249] Bug in search module (radius search)

avatar
Created By: Martijn (mebots)
Date Submitted: Tue Dec 27 18:03:56 -0500 2016

Assigned To: Robert Campbell (calguy1000)
Version: 1.23.3
CMSMS Version: 2.1.6
Severity: Major
Resolution: Invalid
State: Open
Summary:
Bug in search module (radius search)
Detailed Description:
Bug in search module:

Debug: (0,19247) - (usage: 4464328) - (peak: 6112072)

(mysqli): SELECT COUNT(DISTINCT C.id) AS count,(SELECT 3959 *
acos(cos(radians(52,03722))
                 * cos(radians(C.latitude))
                 * cos(radians(C.longitude) - radians(5,65299))
                 + sin(radians(52,03722))
* sin(radians(C.latitude)))) AS distance FROM
pso2_module_compdir_companies C WHERE (C.status = 'published') HAVING distance
<= 25 LIMIT  1
Error (1582): Incorrect parameter count in the call to native function 'radians'

It's on a dutch system, so point is a comma.

See post from yann lamy, he have the same problem.

The distance is also incorrect, put it on "km" with a radius of 25, if I look in
the source code, te radius must be 25 * 0.621371192 = 15.5342798

Please correct this bugs.

Your modules are very useful.

Thank you,

Martijn


History

Comments
avatar 
Date: 2017-02-21 10:57
Posted By: Robert Campbell (calguy1000)

duplicate
Updates

Updated: 2017-02-21 10:57
resolution_id: 5 => 9

Updated: 2016-12-27 18:18
description: Bug in search module: Debug: (0,19247) - (usage: 4464328) - (peak: 6112072) (mysqli): SELECT COUNT(DISTINCT C.id) AS count,(SELECT 3959 * acos(cos(radians(52,03722)) * cos(radians(C.latitude)) * cos(radians(C.long => Bug in search module: Debug: (0,19247) - (usage: 4464328) - (peak: 6112072) (mysqli): SELECT COUNT(DISTINCT C.id) AS count,(SELECT 3959 * acos(cos(radians(52,03722)) * cos(radians(C.latitude)) * cos(radians(C.long

Updated: 2016-12-27 18:17
description: Bug in search module: Debug: (0,19247) - (usage: 4464328) - (peak: 6112072) (mysqli): SELECT COUNT(DISTINCT C.id) AS count,(SELECT 3959 * acos(cos(radians(52,03722)) * cos(radians(C.latitude)) * cos(radians(C.long => Bug in search module: Debug: (0,19247) - (usage: 4464328) - (peak: 6112072) (mysqli): SELECT COUNT(DISTINCT C.id) AS count,(SELECT 3959 * acos(cos(radians(52,03722)) * cos(radians(C.latitude)) * cos(radians(C.long
resolution_id: => 5