[Savannah-help-public] [sr #107979] Database error: unable to browse tracker.

[Miguel de Benito]

URL:
  <http://savannah.gnu.org/support/?107979>

                 Summary: Database error: unable to browse tracker.
                 Project: Savannah Administration
            Submitted by: mdbenito
            Submitted on: sáb 10 mar 2012 01:54:33 CET
                Category: Savannah website
                Priority: 5 - Normal
                Severity: 5 - Blocker
                  Status: None
             Assigned to: None
        Originator Email: 
        Operating System: None
             Open/Closed: Open
         Discussion Lock: Any

    _______________________________________________________

Details:

Hi, 

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 (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]


Also, sorry that I posted this as a task first by mistake.




    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/support/?107979>

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