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
Tilghman Lesher
2009-Jul-17 22:13 UTC
[asterisk-users] Voicemail ODBC storage table schema
On Friday 17 July 2009 16:25:13 Hoggins! wrote:> 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,mailb >oxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)] > > I had to roll back to 1.6.1.0 in the meantime.Oops. It's now documented in UPGRADE.txt and the table schema is in doc/tex/odbcstorage.tex (which is rendered into the PDF at release). -- Tilghman & Teryl with Peter, Cottontail, Midnight, Thumper, & Johnny (bunnies) and Harry, BB, & George (dogs)