search for: amysql_query

...esultid ${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...

...to connect Asterisk to the MySQL, but I can't execute it. It returns an error, as below: -- Executing [200 at teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT/ ramal/ FROM/ colaboradores/ WHERE/ ramal=200") in new stack [Feb 18 15:55:13] WARNING[7696]: app_mysql.c:393 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 '/ ramal/ FROM/ colaboradores/ WHERE/ ramal=200' at line 1 Its seems it can connect to mysql My extension (AEL)...

...S} ${DB}); MYSQL(Query resultid ${connid} SELECT TIMEDIFF(callend,callstart) FROM tblCall WHERE id=7); MYSQL(fetch fetchid ${resultid} temp); MYSQL(Disconnect ${connid}); } } </CODE> The error I'm getting is below: [Mar 6 08:59:35] WARNING[27116]: app_addon_sql_mysql.c:268 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 ') FROM tblCall WHERE id=7' at line 1 Has anyone done this kind of calculation before, or is there a better way to...

...[Aug 30 14:07:42] -- Executing [s at macro-vakantie:2] MYSQL("IAX2/zoiper-9238", "Query resultid 1 SELECT vakantie_set vakantie_data1 vakantie_data2 FROM AstDB where SIPACCOUNT="092779077"") in new stack [Aug 30 14:07:42] WARNING[26029]: app_addon_sql_mysql.c:335 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 'vakantie_data2 FROM AstDB where SIPACCOUNT="092779077"' at line 1 Greetingz, Jonas. -------------- nex...

...cli: -- Executing [s at macro-checkblacklist:2] MYSQL("SIP/1003-00000006", "Query resultid 1 SELECT\ callerid\ from\ blacklist\ where\ companycode = 95040654321 and callerid=1003 and blockenabled = 1") in new stack [Jan 25 17:05:34] WARNING[2583]: app_addon_sql_mysql.c:374 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 '\ callerid\ from\ blacklist\ where\ companycode = 95040654321 and callerid=1003 ' at line 1 -- Best regards, Su...

...} pass) MYSQL(clear ${resultid}) MySQL(Query resultid ${connid} SELECT/INSERT whatever from table) So, it gives me this pass value correct, but if I execute some other query INSERT or SELECT after clearing the result, it gives me an error [May 17 16:16:13] WARNING[19572]: app_addon_sql_mysql.c:374 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: Commands out of sync; you can't run this command now The error disappears if I reconnect to mysql after calling the stored procedure but it seams not right to me to connect to mysql 2 times for 1 call. Did anyone have the same issue? -------------- nex...

...s,6,MYSQL(Fetch fetchid ${resultid} mailbox) exten => s,7,MYSQL(Clear ${resultid}) exten => s,8,Set(vpbx-number=${mailbox}) exten => s,9,MYSQL(Disconnect ${connid}) exten => s,10,Return And here's the error from 1.6.0.5: [Apr 22 09:06:36] WARNING[17379]: app_addon_sql_mysql.c:311 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 '\,vpbx.password\,vpbx.name FROM ext\,vpbx WHERE mailbox="1234567890" and vpbx_id' at line 1 If I re...

i have problem in compiling asterisk-addons 1.0.1 --------------------------------------------------------- [root@kamran asterisk-addons-1.0.1]# make cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/local/mysql/include -c -o cdr_addon_mysql.o cdr_addon_mysql.c ../asterisk: Not a directory make: *** [cdr_addon_mysql.o] Error 1 --------------------------------------------------------- i want to

...eld. From the logs: Apr 16 12:40:05 VERBOSE[13718] logger.c: == Where Field Name = bin2 and value to update is 2_4643 Apr 16 12:40:05 DEBUG[13718] pbx.c: Launching 'MYSQL' Apr 16 12:40:05 DEBUG[13718] pbx.c: Launching 'MYSQL' Apr 16 12:40:05 WARNING[13718] app_addon_sql_mysql.c: aMYSQL_query: missing some arguments Apr 16 12:40:05 DEBUG[13718] pbx.c: Launching 'MYSQL' Apr 16 12:40:05 WARNING[13718] app_addon_sql_mysql.c: Identifier 160, identifier_type 2 not found in identifier list Apr 16 12:40:05 WARNING[13718] app_addon_sql_mysql.c: Invalid result identifier 160 passed in...

An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/4ba848c0/attachment.htm -------------- next part -------------- A non-text attachment was scrubbed... Name: bhfisher.vcf Type: text/x-vcard Size: 253 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/4ba848c0/attachment.vcf