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

[Alec Davis (JIRA)]

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

Alec Davis commented on ASTERISK-20717:
---------------------------------------

The exact message on cnsole when accessing username:
{code}2012-11-22 11:50:56.636500] WARNING[1752][C-00000135]: app_voicemail.c:3713 retrieve_file: SQL Get Data error! coltitle=msg_id
[SELECT * FROM voicemessages WHERE dir=? AND msgnum=?]{code}


                
> 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 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