mainSavannah Administration - Support: sr #109536, Trouble Using Savannah Bug Tracker

 
 

sr #109536: Trouble Using Savannah Bug Tracker

Submitter:  Armin Müller <arm_in>
Submitted:  Tue 24 Jul 2018 05:25:22 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
   

Jump to the original submission

Mon 08 Oct 2018 02:04:27 PM UTC, comment #13: 

I've tried it again. It looks really good now. The SQL error is gone, and "Additional constraint" as well as "Modified Since" date is stored correctly.

Thank you very much for your help!!

Armin Müller <arm_in>
Sat 06 Oct 2018 06:24:56 PM UTC, comment #12: 

This was a newer bug, I think now I've fixed it.

Ineiev <ineiev>
Site Administrator
Fri 05 Oct 2018 11:21:30 AM UTC, comment #11: 

Hmmm, something went wrong.

The SQL error has disappeared.

But it seems that the "modified since" field is not retained. If I click on "Bugs" or "Bugs->Brows", the current date will be written into the date field. All 1300+ active errors will be shown.

Armin Müller <arm_in>
Fri 05 Oct 2018 11:08:59 AM UTC, comment #10: 

All cited SQL queries are for the case when the additional constraint is activated and it selects items that are not modified; I've just pushed and installed a fix.

Thank you!

Ineiev <ineiev>
Site Administrator
Thu 04 Oct 2018 09:11:50 AM UTC, comment #9: 

To narrow down the problem:

  • I'm using the tracker under four different systems.
  • Different browsers (IE, Firefox, SeaMonkey, Safari)
  • Different OS (Windows XP, 7, 10, iOS 11)
  • Different internet providers
  • If I screwed up my user profile on the iOS system, it will be also wrong on the Windows system. The error is traveling with the user profile.


So, obviously it has nothing to do with

  • OS
  • Browser
  • Cookies
  • Windows / Linux / MacOS


It has to do, however, with

  • The ticket system on savannah.gnu.org
  • The user profile on savannah.gnu.org
  • The options "Additional constraint" = "activated" and "Any modified since" = "[any date]"
  • Maybe the customization that has been done for the project "GNU Octave"
Armin Müller <arm_in>
Thu 04 Oct 2018 08:48:08 AM UTC, comment #8: 

Same problem here on another project (quilt):

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 >= 0) AND (bugs_history.field_name = NULL)) WHERE bugs.group_id='3520' AND (bugs.spamscore < '5' OR submitted_by='12366') AND user_assigned_to.user_id=bugs.assigned_to AND bugs_history.bug_id IS NULL]

I think it is caused by previous search criteria which are remembered but no longer valid. Using "Bugs > Reset to open" as advised by Armin works around the problem (thanks Armin!) However it is not exactly user-friendly.

Ideally, the old query should be transparently converted to the equivalent query for the new model. If that is not possible or is considered too much work for a transitory issue, then invalid queries should be automatically forgotten. In other words, when a query fails, instead of spitting the database error in the browser, you should redirect to the same page as "Bugs > Reset to open".

Jean Delvare <khali>
  Spam posted by liona_rezz
Wed 01 Aug 2018 01:06:31 PM UTC, comment #6: 

Still doesn't reproduce for me, with URL


https://savannah.gnu.org/bugs/index.php?go_report=Apply&group=octave&func=browse&set=custom&msort=0&report_id=100&advsrch=0&status_id=0&resolution_id=0&assigned_to=0&category_id=0&bug_group_id=0&history_search=1&history_field=0&history_event=modified&history_date_dayfd=1&history_date_monthfd=8&history_date_yearfd=2018&chunksz=50&spamscore=5&boxoptionwanted=1#options


Ineiev <ineiev>
Site Administrator
Tue 31 Jul 2018 09:25:21 AM UTC, comment #5: 

When I read the other two cases, it seems that the settings are important:


Default for Octave:

Open/Closed = "Open"
Additional constraint = "deactivated"

Failure Case for Octave:

Open/Closed = "Any"
Additional constraint = "activated" <= this one is relevant
Any modified since = "[any date]"

The setting "Additional constraint = activated" will lead to the bug.

Armin Müller <arm_in>
Sat 28 Jul 2018 12:35:30 PM UTC, comment #4: 

...and to sr #109187.

Ineiev <ineiev>
Site Administrator
Sat 28 Jul 2018 12:33:56 PM UTC, comment #3: 

Looks similar to sr #107979.

Ineiev <ineiev>
Site Administrator
Thu 26 Jul 2018 09:26:31 PM UTC, comment #2: 

I just tried to clear all cookies in connection with "gnu" and "savannah". However, the effect still does happen.

Armin Müller <arm_in>
Thu 26 Jul 2018 10:24:02 AM UTC, comment #1: 

I did encounter such errors, but I can't reproduce this one. Does it still happen after you clear your Savannah cookies?

Ineiev <ineiev>
Site Administrator
Tue 24 Jul 2018 05:25:22 PM UTC, original submission:  

For some reason, and for some weeks now, the bug tracker in Octave is broken when I'm using it. An SQL error is appearing when browsing the bug list.

https://savannah.gnu.org/bugs/?group=octave

Example:

"Bugs => Browse" 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 >= 0) AND (bugs_history.field_name = NULL)) WHERE bugs.group_id='1925' AND (bugs.spamscore < '5' OR submitted_by='94238') AND user_assigned_to.user_id=bugs.assigned_to AND bugs_history.bug_id IS NULL]

"Bugs => Reset to open"

... then gives results as expected, again. I have to restore my settings manually, however.

Posted before as Octave bug #54355

Armin Müller <arm_in>

 

(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 khali (Posted a comment)
  • -email is unavailable- added by ineiev (Posted a comment)
  • -email is unavailable- added by arm_in (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 5 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2018-10-05 ineiev StatusNeed Info Done
        Open/ClosedOpen Closed
    2018-09-19 ineiev Carbon-CopyRemoved 127802 -
    2018-07-26 ineiev StatusNone Need Info
        Assigned toNone ineiev

    Back to the top

    Powered by Savane 3.13-758e.
    Corresponding source code