taskSavannah Administration - Tasks: task #11901, Database error: unable to browse...


task #11901: Database error: unable to browse tracker.

Submitted by:  Miguel de Benito <mdbenito>
Submitted on:  Fri 09 Mar 2012 03:57:05 PM UTC  
Should Start On:  Thu 08 Mar 2012 11:00:00 PM UTC Should be Finished on:  Thu 08 Mar 2012 11:00:00 PM UTC
Category:  System Priority:  7 - High
Status:  Wait reply Privacy:  Public
Percent Complete:  0% Assigned to:  Assaf Gordon <agn>
Open/Closed:  Closed Effort:  0.00

Add a New Comment(Rich Markup)

You are not logged in

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


Wed 27 Aug 2014 09:21:10 PM UTC, comment #3:


I am closing this task due to inactivity.
If this is still an issue, please reply and it will be re-opened.

- Assaf

Assaf Gordon <agn>
Site AdministratorIn charge of this item.
Tue 12 Aug 2014 12:44:18 AM UTC, comment #2:


I'm reviewing old tasks in GNU Savannah.

As of August 2014, I was not able to reproduce the error with the steps listed in this task.

Are you still experiencing these issues?

If within two weeks I still do not get a reply, I will close this

- Assaf

Assaf Gordon <agn>
Site AdministratorIn charge of this item.
Fri 09 Mar 2012 03:58:09 PM UTC, comment #1:

I forgot to mention that the project is TeXmacs, in case it's needed.

Miguel de Benito <mdbenito>
Fri 09 Mar 2012 03:57:05 PM UTC, original submission:


a particular combination of search criteria causes a database error. Since the last settings are stored in the session I cannot browse the tracker 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]

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

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

    Date Changed by Updated Field Previous Value => Replaced by
    2014-08-27 agn Open/ClosedOpen => Closed
    2014-08-12 agn StatusNone => Wait reply
        Assigned toNone => agn
    2012-03-09 mdbenito Carbon-Copy- => Added mdbenito

    Back to the top

    Powered by Savane 3.3