[asterisk-users] Voicemail ODBC storage table schema

Hoggins! fuckspam at wheres5.com
Fri Jul 17 16:25:13 CDT 2009


Hello,

Upgraded from 1.6.1.0 to 1.6.1.1 and my voicemail setup does not work
anymore. I use ODBC storage for voicemail. Comes out that the
"voicemessages" table schema should have changed, because the log says
Asterisk needed to store data to an additional field called "flag". Any
new message cannot be saved.
The thing is that I'd like to know where I can find an updated schema
for the generic voicemail storage table. Apparently, only the "flag"
field has appeared, but I can't find out what is the type of the field.

Here are the fields it's trying to update :

[INSERT INTO voicemessages
(dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag)
VALUES (?,?,?,?,?,?,?,?,?,?,?)]

I had to roll back to 1.6.1.0 in the meantime.

    Thanks.

       Hoggins!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090717/6627ce44/attachment.htm 


More information about the asterisk-users mailing list