mainSavannah Administration - Support: sr #107979, Database error: unable to browse...

 
 

sr #107979: Database error: unable to browse tracker.

Submitter:  Miguel de Benito <mdbenito>
Submitted:  Sat 10 Mar 2012 12:54:33 AM UTC
   
 
Category:  Savannah website Priority:  5 - Normal
Severity:  5 - Blocker Status:  Done
Privacy:  Public Assigned to:  ineiev
Operating System:  None Open/Closed:  Closed
* Mandatory Fields

Add a New Comment Rich Markup
   

Fri 05 Oct 2018 11:10:45 AM UTC, comment #5: 

Fixed, see sr #109536.

Thank you!

Ineiev <ineiev>
Site Administrator
Fri 09 Aug 2013 11:19:01 PM UTC, comment #4: 

I am pretty sure the underlying bug is still there.  You can probably reproduce the problematic search criteria from the SQL given, although it may require something else about the texmacs tracker.  I also don't have a specific test project to point you at to try with, although there must plenty around ... sigh.

Karl Berry <karl>
Site Administrator
Fri 09 Aug 2013 07:45:34 PM UTC, comment #3: 

Is this still a problem, or can we close this?

John Schmidt <johnschmidt4>
Sat 24 Mar 2012 06:54:58 AM UTC, comment #2: 

Thanks for the bug report.

Will investigate.

Michael J. Flickinger <mjflick>
Sat 10 Mar 2012 12:58:42 AM UTC, comment #1: 

Going to the main project page and clicking on "Browse open items" cleaned the query variables from the session and I'm now able to use the tracker again. But the database error is still valid I guess.

Miguel de Benito <mdbenito>
Sat 10 Mar 2012 12:54:33 AM UTC, original submission:  

Hi,

a particular combination of search criteria caused a database error and since the last settings are stored in the session I cannot browse the tracker for the project (TeXmacs) anymore. This is the error:

db_query: SQL query error Unknown column 'bugs.bug_id' in 'on clause' in [SELECT count(DISTINCT bugs.bug_id) AS count FROM bugs ,user user_assigned_to,user user_submitted_by LEFT JOIN bugs_history ON ((bugs_history.bug_id = bugs.bug_id ) AND (bugs_history.date >= 1328050800) ) WHERE bugs.group_id='156' AND (bugs.spamscore < 5 OR submitted_by='80671') AND bugs.status_id IN ('1','5') AND bugs.assigned_to IN ('100','75915') AND bugs.bug_group_id IN ('101','102') AND user_assigned_to.user_id=bugs.assigned_to AND user_submitted_by.user_id=bugs.submitted_by AND bugs_history.bug_id IS NULL]


Also, sorry that I posted this as a task first by mistake.

Miguel de Benito <mdbenito>

 

(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)
  • -email is unavailable- added by karl (Posted a comment)
  • -email is unavailable- added by mjflick (Posted a comment)
  • -email is unavailable- added by mdbenito (Submitted the item)
  •  

    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 3 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2018-10-05 ineiev StatusNone Done
        Assigned toNone ineiev
        Open/ClosedOpen Closed

    Back to the top

    Powered by Savane 3.13-f8d8.
    Corresponding source code