mainSavannah Administration - Support: sr #110583, Searching cookbook leads to an...

 
 

sr #110583: Searching cookbook leads to an error

Submitter:  None
Submitted:  Mon 13 Dec 2021 10:54:05 AM UTC
   
 
Category:  Savannah website Priority:  5 - Normal
Severity:  4 - Important Status:  Done
Privacy:  Public Assigned to:  ineiev
Originator Email:  -email is unavailable- Operating System:  None
Open/Closed:  Closed
* Mandatory Fields

Add a New Comment Rich Markup
   

Thu 23 Dec 2021 01:50:03 PM UTC, comment #1: 

Thank you, fixed.

Ineiev <ineiev>
Site Administrator
Mon 13 Dec 2021 10:54:05 AM UTC, original submission:  

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]

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by ineiev (Posted a comment)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 4 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2021-12-23 ineiev StatusNone Done
        Assigned toNone ineiev
        Operating SystemMac OS None
        Open/ClosedOpen Closed

    Back to the top

    Powered by Savane 3.13-caa5.
    Corresponding source code