[asterisk-bugs] [JIRA] (ASTERISK-20739) Voicemail access results in error message - SQL Get Data error! coltitle=msg_id

[Matt Jordan (JIRA)]

Matt Jordan created ASTERISK-20739:
--------------------------------------

             Summary: Voicemail access results in error message - SQL Get Data error! coltitle=msg_id
                 Key: ASTERISK-20739
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-20739
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Applications/app_voicemail/ODBC
    Affects Versions: 11.0.1
         Environment: Voicemail Build:= ODBC Storage
MySQL backend

            Reporter: Alec Davis
            Severity: Minor


Updraded from 1.8 to 11 and added in the extra msg_id field in MySQL,
as noted in https://wiki.asterisk.org/wiki/display/AST/ODBC+Voicemail+Storage

The message "SQL Get Data error! coltitle=msg_id" is emitted on console under the following events:
 1) When using app_directory/app_voicemail when playing the username.
 2) When playing, unheard previous 1.8 recordings.
 3) When playing, 'OLD' meessages, whether recorded on 1.8 or 11


As messages are listened to, and then moved to 'Old' they loose there msg_id - see tables below.
{code}
mysql> select id,msgnum,dir,msg_id,mailboxuser from voicemessages where mailboxuser=8512;
+--------+--------+--------------------------------------------------+----------------------+-------------+
| id     | msgnum | dir                                              | msg_id               | mailboxuser |
+--------+--------+--------------------------------------------------+----------------------+-------------+
|   2331 |      0 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL                 | 8512        |
|  26321 |     -1 | /var/spool/asterisk/voicemail/default/8512/greet | NULL                 | 8512        |
|  80021 |      1 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL                 | 8512        |
| 127731 |      2 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL                 | 8512        |
| 127751 |      3 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL                 | 8512        |
| 127761 |      0 | /var/spool/asterisk/voicemail/default/8512/INBOX | 1353539236-128701767 | 8512        |
+--------+--------+--------------------------------------------------+----------------------+-------------+
6 rows in set (0.00 sec)

mysql> select id,msgnum,dir,msg_id,mailboxuser from voicemessages where mailboxuser=8512;
+--------+--------+--------------------------------------------------+--------+-------------+
| id     | msgnum | dir                                              | msg_id | mailboxuser |
+--------+--------+--------------------------------------------------+--------+-------------+
|   2331 |      0 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL   | 8512        |
|  26321 |     -1 | /var/spool/asterisk/voicemail/default/8512/greet | NULL   | 8512        |
|  80021 |      1 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL   | 8512        |
| 127731 |      2 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL   | 8512        |
| 127751 |      3 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL   | 8512        |
| 127771 |      4 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL   | 8512        |
+--------+--------+--------------------------------------------------+--------+-------------+
{code}



--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira