RE: [Asterisk-Users] Asterisk voicemail support

[S McGowan]

That's because DELETE is a reserved word. The queries asterisk sends need to have ` surrounding the name, not ' or ".   I had the same problem but my employers at the time didn't want to delve into the code, we just used the options column From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aisling Sent: Tuesday, January 10, 2006 12:57 PM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] Asterisk voicemail support Hi,   I was wondering if anyone has had a problem adding the ‘delete’ field to the voicemail_users table. I have no problems adding other fields e.g.   alter table voicemail_users add column hidefromdir varchar(3) NOT NULL default ‘no’;   However when I do   alter table voicemail_users add column delete varchar(3) NOT NULL default ‘no’;   I get a message telling me that I have an error in my MySQL syntax…..Is this because the ‘delete’ word I s a reserved word and if so is this something others have experienced?   Many thanks, Aisling. -------------------Legal Disclaimer--------------------------------------- The above electronic mail transmission is confidential and intended only for the person to whom it is addressed. Its contents may be protected by legal and/or professional privilege. Should it be received by you in error please contact the sender at the above quoted email address. Any unauthorised form of reproduction of this message is strictly prohibited. The Institute does not guarantee the security of any information electronically transmitted and is not liable if the information contained in this communication is not a proper and complete record of the message as transmitted by the sender nor for any delay in its receipt.

_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users