diff --git a/core/filter_api.php b/core/filter_api.php index 31d8574..27d9273 100644 --- a/core/filter_api.php +++ b/core/filter_api.php @@ -943,7 +943,7 @@ function filter_get_query_sort_data( &$p_filter, $p_show_sticky, $p_query_clause $t_value_field = ( $t_def['type'] == CUSTOM_FIELD_TYPE_TEXTAREA ? 'text' : 'value' ); $c_cf_alias = str_replace( ' ', '_', $t_custom_field ); $t_cf_table_alias = $t_custom_field_string_table . '_' . $t_custom_field_id; - $t_cf_select = "$t_cf_table_alias.$t_value_field $c_cf_alias"; + $t_cf_select = "$t_cf_table_alias.$t_value_field `$c_cf_alias`"; # check to be sure this field wasn't already added to the query. if( !in_array( $t_cf_select, $p_query_clauses['select'] ) ) { @@ -951,7 +951,7 @@ function filter_get_query_sort_data( &$p_filter, $p_show_sticky, $p_query_clause $p_query_clauses['join'][] = "LEFT JOIN $t_custom_field_string_table $t_cf_table_alias ON $t_bug_table.id = $t_cf_table_alias.bug_id AND $t_cf_table_alias.field_id = $t_custom_field_id"; } - $p_query_clauses['order'][] = "$c_cf_alias $c_dir"; + $p_query_clauses['order'][] = "`$c_cf_alias` $c_dir"; # if sorting by plugin columns } else if ( isset( $t_plugin_columns[ $t_sort_fields[$i] ] ) ) {