[asterisk-bugs] [JIRA] (ASTERISK-29360) Asterisk, Mysql, Odbc (Unknown column 'data' in 'field list')

[Maksim (JIRA)]

Maksim created ASTERISK-29360:
---------------------------------

             Summary: Asterisk, Mysql, Odbc (Unknown column 'data' in 'field list')
                 Key: ASTERISK-29360
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29360
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Core/Logging
    Affects Versions: 16.15.1
         Environment: CentOS Linux release 8.3.2011
Your MySQL connection id is 108
Server version: 5.5.62 MySQL Community Server (GPL)
            Reporter: Maksim
            Severity: Major


Hi, 

We use for logging queuelog events to mysql database use odbc driver.
When first start asterisk and after started mysqlDB we have trouble with queuelog logging. 

WARNING[1995]: res_odbc.c:538 ast_odbc_print_errors: SQL Prepare returned an error: 42S22: [MySQL][ODBC 8.0(w) Driver][mysqld-5.7.28-log]Unknown column 'data' in 'field list'
WARNING[1995]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [INSERT INTO queue_log (time, data, event, agent, queuename, callid) VALUES (?, ?, ?, ?, ?, ?)]  

after I run command asterisk -rx "core reload" is temp fixed. 

I try add that column data to my sql sheme: 
ALTER TABLE queuelog ADD data varchar(40) COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER event;

and I don't get error, but column data1, data2, data3, data4 is empty.
Asterisk write all volumes to data fields like "|11-9873630826|11"

after asterisk -rx "core reload"




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