[asterisk-bugs] [JIRA] (ASTERISK-23457) sqlite3: realtime queue fails after pragma result

[Rusty Newton (JIRA)]

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

Rusty Newton updated ASTERISK-23457:
------------------------------------

    Component/s:     (was: Core/AstDB)
                 Resources/res_config_sqlite
                 Applications/app_queue

> sqlite3: realtime queue fails after pragma 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_sqlite
>    Affects Versions: SVN, 11.2.0
>            Reporter: Scott Griepentrog
>            Severity: Minor
>
> 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)