[asterisk-bugs] [JIRA] (ASTERISK-23457) SQlite3: Realtime queue loading fails after PRAGMA query result

[Kevin Harwell (JIRA)]

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

Kevin Harwell updated ASTERISK-23457:
-------------------------------------

    Target Release Version/s: 14.4.0

> SQlite3: Realtime queue loading fails after PRAGMA query result
> ---------------------------------------------------------------
>
>                 Key: ASTERISK-23457
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23457
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_queue, Resources/res_config_sqlite3
>    Affects Versions: SVN, 11.2.0
>            Reporter: Scott Griepentrog
>            Severity: Minor
>      Target Release: 13.4.0, 13.15.0, 14.4.0
>
>
> When loading queues and queue_members, the function realtime_sqlite3_execute_handle() issues sql command "PRAGMA table_info("queue_members") via sqlite3_exec(), and then fails due to a zero return value from sqlite3_changes(), which then causes it to presume the need to create the table and columns that already exist.
> The error
> {noformat}
> res_config_sqlite3.c: Could not execute ')': near ")": syntax error
> {noformat}
> appears when this issue occurs.  The error is caused by attempting to create a list of columns that don't exist when they've already been passed to the add_column_name() callback issued by sqlite3_exec().



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