mainSavannah Administration - Support: sr #109187, Additional constrain gives SQL...

 
 

sr #109187: Additional constrain gives SQL error

Submitter:  Juan Pablo Carbajal <juanpi>
Submitted:  Thu 24 Nov 2016 11:05:29 PM UTC
   
 
Category:  Savannah trackers - bugs, tasks, etc. Priority:  5 - Normal
Severity:  3 - Normal Status:  Done
Privacy:  Public Assigned to:  ineiev
Operating System:  None Open/Closed:  Closed
* Mandatory Fields

Add a New Comment Rich Markup
   

Fri 05 Oct 2018 11:10:14 AM UTC, comment #3: 

Fixed, see sr #109536.

Thank you!

Ineiev <ineiev>
Site Administrator
Thu 15 Dec 2016 01:08:30 PM UTC, comment #2: 

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.

Juan Pablo Carbajal <juanpi>
Mon 12 Dec 2016 08:39:36 PM UTC, comment #1: 

Thank you for this detailed bug report. It was outstanding.

Note that it actually exposes a second problem too.  The web display of the information is truncated. Fortunately the email copy included all of it. That is one problem.

http://lists.gnu.org/archive/html/savannah-hackers/2016-11/msg00013.html

The information provided was very good. However now I cannot recreate it. I had no doubt that it existed because it seemed very plausible as I do not think all of the combinations of bug restriction are heavily used and a bug could be lurking there.

However I cannot recreate it now. I am loath to write it off as a temporary glitch. However we have been making a lot of upgrades around the backend of Savannah and it is possible that this is simply associated with the various work that is happening.

Would you be so kind as to attempt to recreate it again and post an update as to your findings?

Bob Proulx <rwp>
Site Administrator
Thu 24 Nov 2016 11:05:29 PM UTC, original submission:  

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]


Juan Pablo Carbajal <juanpi>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by ineiev (Posted a comment)
  • -email is unavailable- added by rwp (Posted a comment)
  • -email is unavailable- added by juanpi (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 3 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2018-10-05 ineiev StatusNone Done
        Assigned toNone ineiev
        Open/ClosedOpen Closed

    Back to the top

    Powered by Savane 3.13-f8d8.
    Corresponding source code