[savannah-help-public] [sr #109187] Additional constrain gives SQL error

[Juan Pablo Carbajal]

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

                 Summary: Additional constrain gives SQL error
                 Project: Savannah Administration
            Submitted by: juanpi
            Submitted on: Thu 24 Nov 2016 11:05:29 PM GMT
                Category: Savannah trackers - bugs, tasks, etc.
                Priority: 5 - Normal
                Severity: 3 - Normal
                  Status: None
             Assigned to: None
        Originator Email: address@hidden
        Operating System: None
             Open/Closed: Open
         Discussion Lock: Any

    _______________________________________________________

Details:

In the GNU Octave Project I am trying to filter bugs by Open and by the date
of the last edition. I tried doing the following
"+ Display Criteria" --> "Open/Closed" listbox, selected "Open" 
then
"additional constraint" activated then "Any", "not modified" since
16.11.2016.

This gives 
++
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
LEFT JOIN bugs_history ON ((bugs_history.bug_id = bugs.bug_id ) AND
(bugs_history.date >= 1479254400) ) WHERE bugs.group_id='1925' AND
(bugs.spamscore < 5 OR submitted_by='84107') AND bugs.status_id IN ('1') AND
bugs.resolution_id IN ('11') AND user_assigned_to.user_id=bugs.assigned_to AND
bugs_history.bug_id IS NULL]
--




    _______________________________________________________

Reply to this item at:

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

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/