<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>RE: [asterisk-users] create table in mysql using asterisk</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Consolas">Thanks</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Consolas">But that's no</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Consolas">t the</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Consolas"> problem, I also tried without the quotes and still the error appears only this time it</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Consolas"> is</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Consolas"> like this</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><B></B></SPAN><B><SPAN LANG="en-us"><FONT FACE="Consolas">app_addon_sql_mysql.c:383 aMYSQL_query: aMYSQL_query: mysql_query</FONT></SPAN></B><SPAN LANG="en-us"><B></B></SPAN><B><SPAN LANG="en-us"><FONT FACE="Consolas"></FONT></SPAN></B><SPAN LANG="en-us"><B></B></SPAN><B><SPAN LANG="en-us"> <FONT FACE="Consolas">failed. Error: You have an error in your SQL syntax; check the manual</FONT></SPAN></B><SPAN LANG="en-us"><B></B></SPAN><B><SPAN LANG="en-us"><FONT FACE="Consolas"></FONT></SPAN></B><SPAN LANG="en-us"><B></B></SPAN><B><SPAN LANG="en-us"> <FONT FACE="Consolas">that corresponds to your MySQL server version for the right syntax to</FONT></SPAN></B><SPAN LANG="en-us"><B></B></SPAN><B><SPAN LANG="en-us"><FONT FACE="Consolas"></FONT></SPAN></B><SPAN LANG="en-us"><B></B></SPAN><B><SPAN LANG="en-us"> <FONT FACE="Consolas">use near '' at line 1</FONT></SPAN></B><SPAN LANG="en-us"><B></B></SPAN><B><SPAN LANG="en-us"></SPAN></B></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>-----Original Message-----<BR>
From: asterisk-users-bounces@lists.digium.com [<A HREF="mailto:asterisk-users-bounces@lists.digium.com">mailto:asterisk-users-bounces@lists.digium.com</A>] On Behalf Of James Sharp<BR>
Sent: Monday, January 09, 2012 9:56 AM<BR>
To: Asterisk Users Mailing List - Non-Commercial Discussion<BR>
Subject: Re: [asterisk-users] create table in mysql using asterisk</SPAN></FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>On 01/09/2012 02:44 AM, Eyal wrote:</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> Hi,</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> I try to create a new table using MYSQL command in asterisk.</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> This is what i write:</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> *Query resultid ${connid} CREATE TABLE IF NOT EXISTS "conference_600"</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> ("id" int(11) NOT NULL auto_increment, "channel_id" varchar(40),</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> "number_in_line" int(2), PRIMARY KEY("id")")*</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> and this is the warning that i get in the cli:</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> *app_addon_sql_mysql.c:383 aMYSQL_query: aMYSQL_query: mysql_query</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> failed. Error: You have an error in your SQL syntax; check the manual</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> that corresponds to your MySQL server version for the right syntax to</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> use near '"conference_600" ("id" int(11) NOT NULL auto_increment,</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> "channel_id" varchar(40)' at line 1</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="he"><FONT FACE="Arial">> *</FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> What is the problem do you think?</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>> Do I in the direction or have a completely different way to do this?</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="he"></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>That's a MySQL syntax error, not an Asterisk error. However, the </SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>solution is to not put quotes around your table and field names. That </SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>will make MySQL happy.</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="he"></SPAN></P>
<P DIR=RTL><SPAN LANG="he"><FONT FACE="Arial">--</FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="he"><FONT FACE="Arial">_____________________________________________________________________</FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>-- Bandwidth and Colocation Provided by <A HREF="http://www.api-digital.com">http://www.api-digital.com</A> --</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>New to Asterisk? Join us for a live introductory webinar every Thurs:</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR> <A HREF="http://www.asterisk.org/hello">http://www.asterisk.org/hello</A></SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="he"></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>asterisk-users mailing list</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR>To UNSUBSCRIBE or update options visit:</SPAN></FONT></SPAN></P>
<P DIR=RTL><SPAN LANG="en-us"><FONT FACE="Consolas"><SPAN DIR=LTR> <A HREF="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</A></SPAN></FONT></SPAN></P>
</BODY>
</HTML>