[asterisk-users] Voicemail ODBC storage table schema

[Tilghman Lesher]

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)