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

[Chris Savinovich (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-28356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris Savinovich updated ASTERISK-28356:
----------------------------------------

    Assignee: Michael  (was: Unassigned)
      Status: Waiting for Feedback  (was: Triage)

I will like to help you but you make it difficult because I have to ask you a few times for the same items.  Had you send us your realtime configuration from the start I would have been able to assist you already, Again: database structure, how did you create the tables. *Are you using the Alembic scripts?* full structure of table queues, full structure of table queue_members, etc, etc.permissions on the table and/or ringinuse column.
C. Savinovich


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