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

[Juan Pablo Carbajal]

Follow-up Comment #2, sr #109187 (project administration):

Hi,

Thanks for looking into this. I ma currently hitting similar errors everytime
I go to the bugs sections of the GNu Octave project. It seems is a cookie
problem. 

In particular if I remove the cookie "session_hash" I get rid of many of these
errors (not the one I reported)

To reproduce the bug I just followed my instructions, step by step, and I get
the same error (even after I removed all cookies)

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=0)
 AND bugs.status_id IN ('1') 
 AND user_assigned_to.user_id=bugs.assigned_to 
 AND bugs_history.bug_id IS NULL]
 

I have added some new lines to the error to avoid truncation in this site.


    _______________________________________________________

Reply to this item at:

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

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