[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-hackers-public] [task #11901] Database error: unable to browse
From: |
Miguel de Benito |
Subject: |
[Savannah-hackers-public] [task #11901] Database error: unable to browse tracker. |
Date: |
Fri, 09 Mar 2012 15:57:06 +0000 |
User-agent: |
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_3) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.78 Safari/535.11 |
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/
- [Savannah-hackers-public] [task #11901] Database error: unable to browse tracker.,
Miguel de Benito <=