asterisk users - Jan 2006 - 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20060110/59bc7f11/attachment.htm

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: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] 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. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20060110/7f05accf/attachment.htm