[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=246733#comment-246733 ] 

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


Not sure what to tell ya.  I can't provide items that don't exist.  There is no dialplan.  No pjsip extensions.  The queue is added into sql via insert statement, and with 1 realtime member.

another example:

insert into queues (name,announce,ringinuse) values ('techsupport','queue-markq','no');
insert into queue_members (queue_name, interface, membername) values ('techsupport','PJSIP/100','ext 100');

test-system*CLI>dialplan show
-= 0 extensions (0 priorities) in 0 contexts. =-
test-system*CLI>queue show
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: 
      ext 100 (PJSIP/100) (ringinuse disabled) (realtime) (Invalid) has taken no calls yet
   No Callers

test-system*CLI>queue set ringinuse yes on PJSIP/100 in techsupport
Set ringinuse on interface 'PJSIP/100' from queue 'techsupport'
[Apr  1 14:28:25] WARNING[21115]: 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.26-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
[Apr  1 14:28:25] WARNING[21115]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [UPDATE queue_members SET  WHERE uniqueid=?]
[Apr  1 14:28:25] WARNING[21115]: 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
[Apr  1 14:28:25] WARNING[21115]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [UPDATE queue_members SET  WHERE uniqueid=?]
test-system*CLI>


> 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)