In article <acf1979b7d3ca54089c1abda3528b1f901dbc...@media2.media.ltd>,
Eyal <e...@mcr-m.com> wrote:
> I try to create a new table using MYSQL command in asterisk.
> This is what i write:
> Query resultid ${connid} CREATE TABLE IF NOT EXISTS "conference_600"
> ("id" int(11) NOT NULL auto_increment, "channel_id" varchar(40),
> "number_in_line" int(2), PRIMARY KEY("id")")
> and this is the warning that i get in the cli:
> app_addon_sql_mysql.c:383 aMYSQL_query: aMYSQL_query: mysql_query
> failed. Error: You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to
> use near '"conference_600" ("id" int(11) NOT NULL auto_increment,
> "channel_id" varchar(40)' at line 1
>
> What is the problem do you think?
> Do I in the direction or have a completely different way to do this?
Yes, you need to solve your problem in a completely different way.
You appear to be wanting to create a new table for each conference,
with the table containing a row for each channel that is a member
of the conference.
You don't need to do that at all. Just have a single table, with an
additional column containing your conference number. Then you only
need to create the table once, outside of Asterisk, and within
Asterisk you only need to write rows into the table, putting the
conference number into the additional column instead of using it
as part of the table name.
Hope this helps!
Tony
--
Tony Mountifield
Work: t...@softins.co.uk - http://www.softins.co.uk
Play: t...@mountifield.org - http://tony.mountifield.org
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
