[Home]

Summary:ASTERISK-14680: res_config_mysql doesn't recognize commented record correctly
Reporter:Makoto Dei (makoto)Labels:
Date Opened:2009-08-19 22:13:42Date Closed:2009-08-20 10:30:26
Priority:MajorRegression?No
Status:Closed/CompleteComponents:Addons/res_config_mysql
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:res_config_mysql recognizes records with commented = 0 as commented records.
res_config_mysql executes the following SQL senetence. "commented=1" in WHERE clause should be "commented=0".

SELECT category, var_name, var_val, cat_metric FROM %s WHERE filename='%s' and commented=1 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id
Comments:By: Digium Subversion (svnbot) 2009-08-20 10:29:39

Repository: asterisk-addons
Revision: 1018

U   branches/1.6.1/res/res_config_mysql.c

------------------------------------------------------------------------
r1018 | tilghman | 2009-08-20 10:29:38 -0500 (Thu, 20 Aug 2009) | 4 lines

Select uncommented lines, not commented ones.
(closes issue ASTERISK-14680)
Reported by: makoto

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk-addons?view=rev&revision=1018
By: Digium Subversion (svnbot) 2009-08-20 10:30:06

Repository: asterisk-addons
Revision: 1019

U   branches/1.6.2/res/res_config_mysql.c

------------------------------------------------------------------------
r1019 | tilghman | 2009-08-20 10:30:06 -0500 (Thu, 20 Aug 2009) | 4 lines

Select uncommented lines, not commented ones.
(closes issue ASTERISK-14680)
Reported by: makoto

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk-addons?view=rev&revision=1019
By: Digium Subversion (svnbot) 2009-08-20 10:30:25

Repository: asterisk
Revision: 213248

U   trunk/addons/res_config_mysql.c

------------------------------------------------------------------------
r213248 | tilghman | 2009-08-20 10:30:25 -0500 (Thu, 20 Aug 2009) | 4 lines

Select uncommented lines, not commented ones.
(closes issue ASTERISK-14680)
Reported by: makoto

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=213248