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

[Friendly Automation (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-27853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=243462#comment-243462 ] 

Friendly Automation commented on ASTERISK-27853:
------------------------------------------------

Change 9009 merged by Kevin Harwell:
app_voicemail: Fix incorrect msg leaving/retrieving an ODBC voicemail

[https://gerrit.asterisk.org/9009|https://gerrit.asterisk.org/9009]

> 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
>            Assignee: 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)