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

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


I'm not using any of my own custom sql statements.  I'm just doing this on the asterisk cli: "queue set ringinuse no on PJSIP/52501 in techsupport" on a realtime member, and the sql errors are just what I see.  I assumed this sql query is generated internally to asterisk.  There's no dialplan involved.  Sorry there's nothing that i know of that is related in extensions.conf or queues.conf to send.  I assume what is happening is that when the ringinuse option is set on the asterisk cli for a realtime queue member, asterisk tries to update the member entry in the sql but fails.  I don't see anything related to ringinuse in the sql table structure for queue_members.

MariaDB [hpbx3]> desc queue_members;
+-----------------+-------------+------+-----+---------+----------------+
| Field           | Type        | Null | Key | Default | Extra          |
+-----------------+-------------+------+-----+---------+----------------+
| queue_name      | varchar(80) | NO   | PRI | NULL    |                |
| interface       | varchar(80) | NO   | PRI | NULL    |                |
| membername      | varchar(80) | YES  |     | NULL    |                |
| state_interface | varchar(80) | YES  |     | NULL    |                |
| penalty         | int(11)     | YES  |     | NULL    |                |
| paused          | int(11)     | YES  |     | NULL    |                |
| uniqueid        | int(11)     | NO   | UNI | NULL    | auto_increment |
| wrapuptime      | int(11)     | YES  |     | NULL    |                |
+-----------------+-------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)


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