[Savannah-hackers-public] [task #11901] Database error: unable to browse tracker.

[Miguel de Benito]

URL:
  <http://savannah.gnu.org/task/?11901>

                 Summary: Database error: unable to browse tracker.
                 Project: Savannah Administration
            Submitted by: mdbenito
            Submitted on: vie 09 mar 2012 16:57:05 CET
         Should Start On: vie 09 mar 2012 00:00:00 CET
   Should be Finished on: vie 09 mar 2012 00:00:00 CET
                Category: System
                Priority: 7 - High
                  Status: None
                 Privacy: Public
        Percent Complete: 0%
             Assigned to: None
             Open/Closed: Open
         Discussion Lock: Any
                  Effort: 0.00

    _______________________________________________________

Details:

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]




    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/task/?11901>

_______________________________________________
  Mensaje enviado vía/por Savannah
  http://savannah.gnu.org/