arnaudcoquelet / fusionpbx

Automatically exported from code.google.com/p/fusionpbx
0 stars 0 forks source link

SQL query to get ring groups has error #825

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.Open /app/ring_groups/ring_groups.php
2.Look at postgresql log file

What is the expected output? What do you see instead?
2015-01-28 11:09:49 EST [45082-1] fusionpbxadmin@fusionpbx ERROR:  column 
"v_ring_groups.ring_group_name" must appear in the GROUP BY clause or be used 
in an aggregate function at character 116
2015-01-28 11:09:49 EST [45082-2] fusionpbxadmin@fusionpbx STATEMENT:  select 
count(*) as num_rows from v_ring_groups where domain_uuid = 
'41b4f79b-2c47-42ab-8356-a0beca120d9f' order by ring_group_name, 
ring_group_extension asc  

Please provide any additional information below.

Please delete rows 71-76 from /app/ring_groups/ring_groups.php. They are not 
needed here.

        if (strlen($order_by) == 0) {
            $sql .= "order by ring_group_name, ring_group_extension asc ";
        }
        else {
            $sql .= "order by $order_by $order ";
        }

Original issue reported on code.google.com by Sergey.M...@gmail.com on 28 Jan 2015 at 4:20

GoogleCodeExporter commented 9 years ago
This has been fixed thanks for reporting it.

Original comment by markjcrane@gmail.com on 29 Jan 2015 at 7:15