[asterisk-bugs] [JIRA] (ASTERISK-28356) queue set ringinuse for realtime member not working

[Michael (JIRA)]

Michael created ASTERISK-28356:
----------------------------------

             Summary: queue set ringinuse for realtime member not working
                 Key: ASTERISK-28356
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28356
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Applications/app_queue
    Affects Versions: 16.2.0
         Environment: debian 9 amd64
asterisk v16.2.0
using pjsip
mysql ODBC 
            Reporter: Michael
            Severity: Minor


when changing the ringinuse option for a queue member added via realtime sql, failure occures.


*CLI>queue show techsupport
techsupport has 0 calls (max unlimited) in 'ringall' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0%, SL2:0.0% within 0s
   Members: 
      Mike (PJSIP/52501) (ringinuse enabled) (dynamic) (Not in use) has taken no calls yet
      Mike (PJSIP/5250) (ringinuse enabled) (realtime) (Not in use) has taken no calls yet
   No Callers

*CLI>queue set ringinuse no on PJSIP/52501 in techsupport
Set ringinuse on interface 'PJSIP/52501' from queue 'techsupport'
*CLI>queue set ringinuse no on PJSIP/5250 in techsupport
Set ringinuse on interface 'PJSIP/5250' from queue 'techsupport'
[Mar 27 16:49:49] WARNING[19466]: res_odbc.c:439 ast_odbc_print_errors: SQL Prepare returned an error: 42000: [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.1.37-MariaDB-0+deb9u1]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE uniqueid=?' at line 1
[Mar 27 16:49:49] WARNING[19466]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [UPDATE queue_members SET  WHERE uniqueid=?]
[Mar 27 16:49:49] WARNING[19466]: res_odbc.c:439 ast_odbc_print_errors: SQL Prepare returned an error: 42000: [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.1.37-MariaDB-0+deb9u1]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE uniqueid=?' at line 1
[Mar 27 16:49:49] WARNING[19466]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [UPDATE queue_members SET  WHERE uniqueid=?]




--
This message was sent by Atlassian JIRA
(v6.2#6252)