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


sr #109187: Additional constrain gives SQL error

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

Add a New Comment(Rich Markup)

You are not logged in

Please log in, so followups can be emailed to you.


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

Fixed, see sr #109536.

Thank you!

Ineiev <ineiev>
Site AdministratorIn charge of this item.
Thu 15 Dec 2016 01:08:30 PM UTC, comment #2:


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)

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.

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"
"additional constraint" activated then "Any", "not modified" since 16.11.2016.

This gives

Juan Pablo Carbajal <juanpi>


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

Attach Files:

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)

    Do you think this task is very important?
    If so, you can add your encouragement to it.
    This task has 0 encouragements so far.

    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.4