ODBC vm - WARNING SQL Get Data error

Asterisk Asterisk Support
1

Hi,

I’m testing ODBC Voicemail Storage with Asterisk 13.14.1~dfsg-2+deb9u1 (Debian Package).
I used SQL scripting with : http://downloads.asterisk.org/pub/telephony/asterisk/old-releases/asterisk-13.14.1.tar.gz

MariaDB [asterisk]> DESCRIBE voicemail_messages;
+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| dir            | varchar(255) | NO   |     | NULL    |       |
| msgnum         | int(11)      | NO   |     | NULL    |       |
| context        | varchar(80)  | YES  |     | NULL    |       |
| macrocontext   | varchar(80)  | YES  |     | NULL    |       |
| callerid       | varchar(80)  | YES  |     | NULL    |       |
| origtime       | int(11)      | YES  |     | NULL    |       |
| duration       | int(11)      | YES  |     | NULL    |       |
| recording      | longblob     | YES  |     | NULL    |       |
| flag           | varchar(30)  | YES  |     | NULL    |       |
| category       | varchar(30)  | YES  |     | NULL    |       |
| mailboxuser    | varchar(30)  | YES  |     | NULL    |       |
| mailboxcontext | varchar(30)  | YES  |     | NULL    |       |
| msg_id         | varchar(40)  | YES  |     | NULL    |       |
+----------------+--------------+------+-----+---------+-------+
13 rows in set (0.00 sec)

I have this WARNING :

[Oct 17 09:24:26] WARNING[29973]: app_voicemail_odbcstorage.c:3975 retrieve_file: SQL Get Data error! coltitle=category
[SELECT * FROM voicemail_messages WHERE dir=? AND msgnum=?]

Is it normal ?

Thanks in advance :grinning: