URL: <https://savannah.nongnu.org/support/?110583>
Summary: Searching cookbook leads to an error Project: Savannah Administration Submitted by: None Submitted on: Mon 13 Dec 2021 10:54:05 AM UTC Category: Savannah website Priority: 5 - Normal Severity: 4 - Important Status: None Assigned to: None Originator Email: sh.ya...@gmail.com Operating System: Mac OS Open/Closed: Open Discussion Lock: Any _______________________________________________________ Details: I've tried searching in the cookbook (without logging in) and ended up in the following address: https://savannah.nongnu.org/search/?Search=Search&words=transition&type_of_search=cookbook&only_group_id=5802&exact=1&max_rows=25#options The following error appeared: db_query: SQL query error Unknown column 'groups.use_cookbook' in 'field list' in [SELECT cookbook.bug_id,cookbook.summary,cookbook.date,cookbook.privacy,cookbook.submitted_by,user.user_name, groups.use_cookbook,cookbook.group_id FROM cookbook,user,groups WHERE user.user_id=cookbook.submitted_by AND groups.group_id=cookbook.group_id AND groups.use_cookbook=1 AND ((cookbook.details LIKE '%transition%') OR (cookbook.summary LIKE '%transition%') OR (cookbook.bug_id LIKE '%transition%')) AND cookbook.group_id='5802' AND cookbook.spamscore < 5 GROUP BY bug_id,summary,date,user_name ORDER BY cookbook.date DESC LIMIT 0,26] _______________________________________________________ Reply to this item at: <https://savannah.nongnu.org/support/?110583> _______________________________________________ Message sent via Savannah https://savannah.nongnu.org/