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 websitePriority: 5 - Normal
Severity: 5 - BlockerStatus: None
Assigned to: NoneOperating System: None
Open/Closed: Open

Add a New Comment(Rich Markup)

You are not logged in

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


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 File(s):

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -unavailable- added by karl (Posted a comment)
  • -unavailable- added by mjflick (Posted a comment)
  • -unavailable- added by mdbenito (Submitted the item)

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

    Only logged-in users can vote.


    Please enter the title of George Orwell's famous dystopian book (it's a date):



    No Changes Have Been Made to This Item

    Back to the top

    Powered by Savane 3.1-cleanup1