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


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

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

Add a New Comment(Rich Markup)

You are not logged in

Please log in, so followups can be emailed to you.


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

Fixed, see sr #109536.

Thank you!

Ineiev <ineiev>
Site AdministratorIn charge of this item.
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>
Site Administrator
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:


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 ( >= 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:

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)

    Do you think this task is very important?
    If so, you can add your encouragement to it.
    This task has 0 encouragements so far.

    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.4