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

[Friendly Automation (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-23457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=235318#comment-235318 ] 

Friendly Automation commented on ASTERISK-23457:
------------------------------------------------

Change 4971 merged by zuul:
res_config_sqlite3: Properly create missing columns when necessary

[https://gerrit.asterisk.org/4971|https://gerrit.asterisk.org/4971]

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