| Summary: | ASTERISK-27853: Incorrect error reported when leaving/retrieving a ODBC voicemail | ||
| Reporter: | Nic Colledge (nic) | Labels: | |
| Date Opened: | 2018-05-12 06:25:04 | Date Closed: | 2018-05-18 16:44:04 |
| Priority: | Minor | Regression? | No |
| Status: | Closed/Complete | Components: | Applications/app_voicemail Applications/app_voicemail/ODBC |
| Versions: | 13.21.0 | Frequency of Occurrence | |
| Related Issues: | |||
| Environment: | Ubuntu 16.04.4 Kernel 4.4.0-124-generic MariaDB ODBC dirver / MariaDB database | Attachments: | |
| Description: | 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. | ||
| Comments: | By: Asterisk Team (asteriskteam) 2018-05-12 06:25:06.044-0500 Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution. A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report. Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process]. By: Friendly Automation (friendly-automation) 2018-05-18 16:44:05.461-0500 Change 8986 merged by Kevin Harwell: app_voicemail: Fix incorrect msg leaving/retrieving an ODBC voicemail [https://gerrit.asterisk.org/8986|https://gerrit.asterisk.org/8986] By: Friendly Automation (friendly-automation) 2018-05-18 17:19:30.739-0500 Change 9008 merged by Kevin Harwell: app_voicemail: Fix incorrect msg leaving/retrieving an ODBC voicemail [https://gerrit.asterisk.org/9008|https://gerrit.asterisk.org/9008] By: Friendly Automation (friendly-automation) 2018-05-18 17:19:58.324-0500 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] | ||