From bbc28e626a04c826a561261eba6ec6348c9b009d Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sat, 23 Nov 2024 11:11:19 +0300 Subject: fix _get_name failing on filters without any rules because of wrong type of JOIN --- classes/Pref_Filters.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'classes') diff --git a/classes/Pref_Filters.php b/classes/Pref_Filters.php index 2d8003629..32ed2d187 100644 --- a/classes/Pref_Filters.php +++ b/classes/Pref_Filters.php @@ -735,8 +735,8 @@ class Pref_Filters extends Handler_Protected { ->select('f.inverse') ->select_expr('COUNT(DISTINCT r.id)', 'num_rules') ->select_expr('COUNT(DISTINCT a.id)', 'num_actions') - ->join('ttrss_filters2_rules', ['r.filter_id', '=', 'f.id'], 'r') - ->join('ttrss_filters2_actions', ['a.filter_id', '=', 'f.id'], 'a') + ->left_outer_join('ttrss_filters2_rules', ['r.filter_id', '=', 'f.id'], 'r') + ->left_outer_join('ttrss_filters2_actions', ['a.filter_id', '=', 'f.id'], 'a') ->where('f.id', $id) ->group_by_expr('f.title, f.match_any_rule, f.inverse') ->find_one(); -- cgit v1.2.3-54-g00ecf