SQL sintax error Fatal error: Uncaught exception 'PDOException'

[Vahram]

Hi

Please help me with this error, problem in this query but i can not find file for make changes - toll_allow, user_record,enabled from v_extensions order by

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at end of input LINE 1: ..., toll_allow, user_record,enabled from v_extensions order by ^' in /var/www/fusionpbx/resources/classes/destinations.php:74 Stack trace: #0 /var/www/fusionpbx/resources/classes/destinations.php(74): PDOStatement->execute() #1 /var/www/fusionpbx/app/ring_groups/ring_group_edit.php(355): destinations->__construct() #2 {main} thrown in /var/www/fusionpbx/resources/classes/destinations.php on line 74

 

[DigitalDaz]

You using debian and postgres?

 

[Vahram]

Centos postgres

 

[DigitalDaz]

Good luck then, fusionpbx is untested on centos.

 

[Vahram]

I tested working properly
this error appear after editing ring group , this query has sintax error "toll_allow, user_record,enabled from v_extensions order by"
Please help find file and line of this query

 

[JamesBorne]

It tells you where to look mate:

/var/www/fusionpbx/resources/classes/destinations.php on line 74

Have a look at what parameters are being passed to find the issue.