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

Jonathan Rose edited comment on ASTERISK-20717 at 11/29/12 4:54 PM:
--------------------------------------------------------------------

Hey Alec, I have a patch for this that I think solves the problem.
https://reviewboard.asterisk.org/r/2220/

It doesn't magically fix messages that were broken by this whole process already, but it does keep them from getting jacked on when they change folders.

If you could verify that the patch works, that might speed up the review. If not it probably won't take very long for it to be approved since the problem seems to have been pretty straight forward.
                
      was (Author: jrose):
    Hey Alec, I have a patch for this that I think solves the problem.
https://reviewboard.asterisk.org/r/2220/

It doesn't magically fix messages that were broken by this whole process already, but it does keep them from getting jacked on when they change folders.
                  
> 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