ejabberd 16.06 + mysql 5.5.50, message history is not saved

Hellow!

I use ejabberd 16.06 + mysql 5.5.50, message history is not saved.

My ejabberd.yml:

## MySQL server:

odbc_type: mysql
odbc_server: "freldo"
odbc_port: 3306
odbc_database: "ejabberd"
odbc_username: "ejabberd"
odbc_password: "ejabberd"

modules:
...
mod_mam:
db_type: odbc
default: always
for the formation of the database structure, I used: mysql.sql (https://github.com/processone/ejabberd/blob/83cce468a573d3ca58a0c6653a2c...)

I get an error:

@ejabberd_sql:check_error:1039 SQL query 'SELECT timestamp, xml, peer,
kind, nick FROM (SELECT timestamp, xml, peer, kind, nick FROM archive
WHERE username='test' and bare_peer='misha@freldo' ORDER BY timestamp
DESC limit 21) AS t ORDER BY timestamp ASC;' failed: "#42S22Unknown
column 'kind' in 'field list'"

I have not saved message history in database.

Tracked here:

Syndicate content