[asterisk-users] MySQL syntax error : I really don't see where...

[Per Jessen]

jonas kellens wrote:

> [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

You need to separate the selected columns with commas.


/Per Jessen, Zürich

-- 
http://www.spamchek.com/ - your spam is our business.