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

[Michael (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-28356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=246786#comment-246786 ] 

Michael commented on ASTERISK-28356:
------------------------------------


download/recompiled and tried the latest 16.3.0  problem still happens.

It happens with v16,v15,v13.21-cert3.  Keep in mind this only happens with realtime queue members added via sql 'queue_members' table.  When changing the ringinuse option on the asterisk cli, it would make sense that the action needs to change the entry for that member in the sql table.  However, I don't see a ringinuse column in that table.  So, i would assume the table is not complete.  It needs a ringinuse column would it not?  And then the appropriate sql command in the asterisk source code to accomplish the change of setting?  I'm not exactly sure i'm just trying to help.



> app_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
>            Assignee: Michael
>            Severity: Minor
>              Labels: pjsip
>
> 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)