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

[Jonathan Rose (JIRA)]

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

Jonathan Rose commented on ASTERISK-20717:
------------------------------------------

Yeah, I wasn't sure if it needed to be unique globally or just to the specific mailbox when I was playing with that. While I'm not currently aware of any use of copy that doesn't function more as a move, the fact that the function is called copy does mean we should treat it as such and make it safe for copying files rather than just moving them, so thanks for that.
                
> 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
>          Components: Applications/app_voicemail/ODBC
>    Affects Versions: 11.0.1
>         Environment: Voicemail Build:= ODBC Storage
> MySQL backend
>            Reporter: Alec Davis
>            Assignee: Jonathan Rose
>            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