[asterisk-bugs] [JIRA] (ASTERISK-20717) Voicemail access "SQL Get Data error! coltitle=msg_id"
Alec Davis (JIRA)
noreply at issues.asterisk.org
Wed Nov 21 17:55:45 CST 2012
[ https://issues.asterisk.org/jira/browse/ASTERISK-20717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alec Davis updated ASTERISK-20717:
----------------------------------
Description:
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}
was:
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}
> 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
More information about the asterisk-bugs
mailing list