[asterisk-bugs] [JIRA] (ASTERISK-30306) require_odbc: Realtime table queue_log requires column 'time', but that column does not exist!

[Juan Cuervo (JIRA)]

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

Juan Cuervo updated ASTERISK-30306:
-----------------------------------

    Attachment: debug_log_123456.txt

> require_odbc: Realtime table queue_log requires column 'time', but that column does not exist!
> ----------------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-30306
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-30306
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_config_odbc
>    Affects Versions: 18.15.0
>            Reporter: Juan Cuervo
>            Assignee: Juan Cuervo
>         Attachments: asterisk_queue_log_table.sql, debug_log_123456.txt, res_odbc.conf
>
>
> There is a series of warnings in the console everytime asterisk is started: 
> Asterisk Ready.
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'time', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data1', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data2', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data3', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data4', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data5', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data1', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data2', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data3', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data4', but that column does not exist!
> [Nov 10 19:50:34] WARNING[226990]: res_config_odbc.c:1224 require_odbc: Realtime table queue_log at voicemax requires column 'data5', but that column does not exist!
> *CLI> 
> *CLI> odbc show voicemax
> ODBC DSN Settings
> -----------------
>   Name:   voicemax
>   DSN:    voicemax
>     Number of active connections: 1 (out of 16)
>     Logging: Enabled
>     Number of prepares executed: 1
>     Number of queries executed: 1
>     Longest running SQL query: INSERT INTO queue_log (time, data5, data4, data3, data2, data1, event, agent, queuename, callid) VALUES (?, ?, ?, ?, ?, ?, ?,?, ?, ?) (5 milliseconds)
> Despite the warning, the odbc connection is stablished and data is saved in the queue_log table. 



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