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 UTCShould be Finished on: Thu 08 Mar 2012 11:00:00 PM UTC
Category: SystemPriority: 7 - High
Status: NonePrivacy: Public
Percent Complete: 0%Assigned to: None
Open/Closed: OpenEffort: 0.00

Add a New Comment (Rich MarkupRich Markup):
   

You are not logged in

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

 

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:

Hi,

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

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

     

     

    Follows 1 latest change.

    Date Changed By Updated Field Previous Value => Replaced By
    Fri 09 Mar 2012 03:57:05 PM UTCmdbenitoCarbon-Copy-=>Added mdbenito

    Back to the top


    Powered by Savane 3.1-cleanup