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

[Juan Cuervo (JIRA)]

Juan Cuervo created ASTERISK-30306:
--------------------------------------

             Summary: 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


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)