[asterisk-bugs] [JIRA] (ASTERISK-27853) Incorrect error reported when leaving/retrieving a ODBC voicemail

[Nic Colledge (JIRA)]

Nic Colledge created ASTERISK-27853:
---------------------------------------

             Summary: Incorrect error reported when leaving/retrieving a ODBC voicemail
                 Key: ASTERISK-27853
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27853
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Applications/app_voicemail, Applications/app_voicemail/ODBC
    Affects Versions: 13.21.0
         Environment: Ubuntu 16.04.4
Kernel 4.4.0-124-generic
MariaDB ODBC dirver / MariaDB database
            Reporter: Nic Colledge
            Severity: Minor


Incorrect error reported when leaving/retrieving a ODBC voicemail and voicemail message records were inserted in the DB without a category column value (null value).

WARNING[12869][C-00000000]: app_voicemail.c:3965 retrieve_file: SQL Get Data error! coltitle=category
[SELECT * FROM voicemail_messages WHERE dir=? AND msgnum=?]

Due to the order of the columns in the database create scripts and the underlying code in retrieve_file this error causes no problems (but would if the column order was different for some reason). Its mainly just a distracting/annoying message in the console / logs.

Steps to reproduce:
1) leave a ODBC voicemail with appropriate settings so that no category column value is inserted.
2) leave another voicemail (in the same box) - the error is displayed on the asterisk console when retrieve_file is called.

Ill post a patch to gerrit soon.



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