[asterisk-bugs] [JIRA] (ASTERISK-20717) Voicemail access "SQL Get Data error! coltitle=msg_id"

[Alec Davis (JIRA)]

Alec Davis created ASTERISK-20717:
-------------------------------------

             Summary: Voicemail access "SQL Get Data error! coltitle=msg_id"
                 Key: ASTERISK-20717
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-20717
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
    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 following warning is emitted on console when leaving a message:
"SQL Get Data error! coltitle=msg_id"
Because the greeting doesn't have a messsage ID. It's from the 1.8 recording.

As messages are listened to, and then moved to 'Old' they loose there msg_id.
{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