FusionPBX causing errors in Postgres error log

What steps will reproduce the problem?
1. Click on menu items such as Dialplan, Dialplan manager, or Apps, IVR menus, 
or Apps, queues
2.
3.
What is the expected output? What do you see instead?
No errors in log for queries or sets.
Errors appear as a result of many routine actions - clicking on links, etc. See 
below for example.

What version of the product are you using? On what operating system?

R2626 - Centos 6.2

Please provide any additional information below.

Example from the log files in /var/lib/pgsql/9.1/data/pg_log/

ERROR:  syntax error at or near "where" at character 50
STATEMENT:  update v_dialplans set dialplan_number = '*411', where domain_uuid 
= '980dde29-ed4c-4eb4-b9ed-ddc665c80e03' and dialplan_uuid = 
'c9c82253-0fce-4e12-a591-0afde2774f17'
ERROR:  syntax error at or near "where" at character 50
STATEMENT:  update v_dialplans set dialplan_number = '*925', where domain_uuid 
= '980dde29-ed4c-4eb4-b9ed-ddc665c80e03' and dialplan_uuid = 
'5a8cab66-6f06-426b-a9c7-0d60160b8f60'
ERROR:  syntax error at or near "where" at character 50
STATEMENT:  update v_dialplans set dialplan_number = '5900', where domain_uuid 
= '980dde29-ed4c-4eb4-b9ed-ddc665c80e03' and dialplan_uuid = 
'cf56f762-c857-4eda-b55e-adc7f1f2e18c'
ERROR:  syntax error at or near "where" at character 60
STATEMENT:  update v_dialplans set dialplan_number = '5901 5902 5903', where 
domain_uuid = '980dde29-ed4c-4eb4-b9ed-ddc665c80e03' and dialplan_uuid = 
'3c50f982-c045-4126-84cc-9b6d0d54ba22'
ERROR:  syntax error at or near "where" at character 60
STATEMENT:  update v_dialplans set dialplan_number = '5901 5902 5903', where 
domain_uuid = '980dde29-ed4c-4eb4-b9ed-ddc665c80e03' and dialplan_uuid = 
'044a5887-622d-423b-8bc0-62c2f804cb6a'
ERROR:  syntax error at or near "where" at character 48
STATEMENT:  update v_dialplans set dialplan_number = '27', where domain_uuid = 
'980dde29-ed4c-4eb4-b9ed-ddc665c80e03' and dialplan_uuid = 
'5b9c32d9-8089-41f3-9e6a-9620b7cdd59c'
ERROR:  syntax error at or near "=" at character 63
STATEMENT:  select count(*) as num_rows from v_ivr_menuswhere domain_uuid = 
'980dde29-ed4c-4eb4-b9ed-ddc665c80e03'
ERROR:  syntax error at or near "=" at character 63
STATEMENT:  select count(*) as num_rows from v_ivr_menuswhere domain_uuid = 
'980dde29-ed4c-4eb4-b9ed-ddc665c80e03'
ERROR:  column "v_dialplans.dialplan_order" must appear in the GROUP BY clause 
or be used in an aggregate function at character 170
STATEMENT:  select count(*) as num_rows from v_dialplans  where domain_uuid = 
'980dde29-ed4c-4eb4-b9ed-ddc665c80e03'  and app_uuid = 
'16589224-c876-aeb3-f59f-523a1c0801f7' order by dialplan_order, dialplan_name 
asc
ERROR:  column "v_dialplans.dialplan_order" must appear in the GROUP BY clause 
or be used in an aggregate function at character 170
STATEMENT:  select count(*) as num_rows from v_dialplans  where domain_uuid = 
'980dde29-ed4c-4eb4-b9ed-ddc665c80e03'  and app_uuid = 
'16589224-c876-aeb3-f59f-523a1c0801f7' order by dialplan_order, dialplan_name 
asc
ERROR:  column "v_dialplans.dialplan_order" must appear in the GROUP BY clause 
or be used in an aggregate function at character 170
STATEMENT:  select count(*) as num_rows from v_dialplans  where domain_uuid = 
'980dde29-ed4c-4eb4-b9ed-ddc665c80e03'  and app_uuid = 
'16589224-c876-aeb3-f59f-523a1c0801f7' order by dialplan_order, dialplan_name 
asc
ERROR:  syntax error at or near "=" at character 63
STATEMENT:  select count(*) as num_rows from v_ivr_menuswhere domain_uuid = 
'980dde29-ed4c-4eb4-b9ed-ddc665c80e03'
ERROR:  column "v_dialplans.dialplan_order" must appear in the GROUP BY clause 
or be used in an aggregate function at character 170
STATEMENT:  select count(*) as num_rows from v_dialplans  where domain_uuid = 
'980dde29-ed4c-4eb4-b9ed-ddc665c80e03'  and app_uuid = 
'16589224-c876-aeb3-f59f-523a1c0801f7' order by dialplan_order, dialplan_name 
asc
Original issue reported on code.google.com by cs1kt...@gmail.com on 13 Jun 2012 at 4:34
MasterVitronic / fusionpbx

FusionPBX causing errors in Postgres error log #266
