[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=200274#comment-200274 ] 

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

I'd already found that missing copy of msg_id in the ODBC COPY, and has been in place for a few days now.
But was unsure as to whether the msd_id's in the system were supposed to be unique.

This fix potentially could make 2 messages have the same unique id.
It doesn't in this case where a message is listened to then moved to OLD.

Now this senario is getting into territory I haven't used;
  if you can copy a message from 1 mailbox to another, if the ODBC COPY method is used (with this patch), then 2 messages have the same msg_id.



                
> 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