bugGNU roff - Bugs: bug #53660, [not our problem] Savannah:...

 
 

bug #53660: [not our problem] Savannah: sorting by severity fails with "Unknown column 'bugs.bug_id'"

Submitter:  Bjarni Ingi Gislason <bjarniig>
Submitted:  Sun 15 Apr 2018 02:43:53 PM UTC
   
 
Category:  None Severity:  3 - Normal
Item Group:  None Status:  Invalid
Privacy:  Public Assigned to:  schwarze
Open/Closed:  Closed Planned Release:  None
* Mandatory Fields

Add a New Comment Rich Markup
   

Sun 22 Apr 2018 09:54:35 PM UTC, comment #4: 

Ah, no wonder I didn't see that one.  Its summary is hopelessly vague. :-/

Thanks, Ingo.

Bjarni, please contact Savannah administration for help with this issue.  The groff team is just their guests; we can't fix the bug tracker.

https://savannah.gnu.org/support/?group=administration

G. Branden Robinson <gbranden>
Group administrator
Sun 22 Apr 2018 04:41:20 PM UTC, comment #3: 

Bjarni posted the link below:

http://savannah.gnu.org/support/?107979

I did not check whether the bug indeed exists, nor whether it is the same bug that Bjarni claims it is, nor whether it was properly reported in the right place.  Even if all Bjani says is spot-on, it is obviously completely unrelated to groff.

If the above ticket is valid, maybe some information can be added there.  Or if it is a different bug, maybe a new ticket might make sense in the admin bug tracker.  But not in the groff tracker.

Ingo Schwarze <schwarze>
Group Member
Sat 21 Apr 2018 07:21:15 AM UTC, comment #2: 

Ingo, could you provide a link to {a,the} relevant Savannah Administration ticket?

I searched for "sort error", and turned up only this one, which was "closed due to inactivity".

https://savannah.gnu.org/task/?func=detailitem&item_id=12764

G. Branden Robinson <gbranden>
Group administrator
Wed 18 Apr 2018 09:54:25 PM UTC, comment #1: 

Closing because this is unrelated to groff.

Such stuff should be reported to Savannah Administration instead, and it appears it has already been reported there.

Ingo Schwarze <schwarze>
Group Member
Sun 15 Apr 2018 02:43:53 PM UTC, original submission:  

  Web site: savannah.gnu.org/bugs/?group=groff

  Select "(+) Display"

  Activate "Additional constraint"

  Select in the next line

Severity not modified since 15 April 2015

  Select "Apply"

  A text window appears:

<html><head>
<meta http-equiv="content-type" content="text/html;
charset=UTF-8"></head><body>db_query: SQL query error <em>Unknown
column 'bugs.bug_id' in 'on clause'</em>
 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 &gt;= 1429056000) AND
(bugs_history.field_name = 'severity'))  WHERE bugs.group_id='273' AND
(bugs.spamscore &lt; 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]</body></html>

  A similar error text is shown in "savannah.gnu.org/support/?107979"
from 10th March 2012.

Bjarni Ingi Gislason <bjarniig>

 

(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 gbranden (Posted a comment)
  • -email is unavailable- added by schwarze (Posted a comment)
  • -email is unavailable- added by bjarniig (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 6 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2022-01-22 gbranden Severity1 - Wish 3 - Normal
        Assigned toNone schwarze
        Summarybug tracker: Sorting severity fails with &quot;Unknown column 'bugs.bug_id'&quot; [not our problem] Savannah: sorting by severity fails with "Unknown column 'bugs.bug_id'"
    2018-04-18 schwarze Severity3 - Normal 1 - Wish
        StatusNone Invalid
        Open/ClosedOpen Closed

    Back to the top

    Powered by Savane 3.13-02a9.
    Corresponding source code