aboutsummaryrefslogtreecommitdiffstats
path: root/addons/res_config_mysql.c
diff options
context:
space:
mode:
Diffstat (limited to 'addons/res_config_mysql.c')
-rw-r--r--addons/res_config_mysql.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/addons/res_config_mysql.c b/addons/res_config_mysql.c
index dae856ea4..273114cbe 100644
--- a/addons/res_config_mysql.c
+++ b/addons/res_config_mysql.c
@@ -927,7 +927,7 @@ static struct ast_config *config_mysql(const char *database, const char *table,
return NULL;
}
- ast_str_set(&sql, 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", table, file);
+ ast_str_set(&sql, 0, "SELECT category, var_name, var_val, cat_metric FROM %s WHERE filename='%s' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id", table, file);
ast_debug(1, "MySQL RealTime: Static SQL: %s\n", ast_str_buffer(sql));