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 Mar 9 15:57:05 2012  
Should Start On: Thu Mar 8 23:00:00 2012Should be Finished on: Thu Mar 8 23:00:00 2012
Category: SystemPriority: 7 - High
Status: Wait replyPrivacy: Public
Percent Complete: 0%Assigned to: Assaf Gordon <agn>
Open/Closed: ClosedEffort: 0.00

Add a New Comment (Rich MarkupRich Markup):

You are not logged in

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


Wed Aug 27 21:21:10 2014, 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 Aug 12 00:44:18 2014, 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 Mar 9 15:58:09 2012, comment #1:

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

Miguel de Benito <mdbenito>
Fri Mar 9 15:57:05 2012, 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 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 agn (Posted a comment)
  • -unavailable- added by mdbenito (Submitted the item)
  • -unavailable- added by mdbenito

    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):



    Follow 4 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Wed Aug 27 21:21:10 2014agnOpen/ClosedOpen=>Closed
    Tue Aug 12 00:44:18 2014agnStatusNone=>Wait reply
      Assigned toNone=>agn
    Fri Mar 9 15:57:05 2012mdbenitoCarbon-Copy-=>Added mdbenito

    Back to the top

    Powered by Savane 3.1-cleanup1