[Savannah-help-public] [sr #105997] Account messed up

[Sandro Santilli]

URL:
  <http://savannah.gnu.org/support/?105997>

                 Summary: Account messed up
                 Project: Savannah Administration
            Submitted by: strk
            Submitted on: Saturday 09/01/2007 at 11:19
                Category: None
                Priority: 5 - Normal
                Severity: 3 - Normal
                  Status: None
             Assigned to: None
        Originator Email: 
        Operating System: None
             Open/Closed: Open
         Discussion Lock: Any

    _______________________________________________________

Details:

Hello savannah hackers. First of all Thanks a lot for your execllent work !!

Now, the nasty things:

Since one or two weeks it seems my account (strk) is messed up on savannah.
The most disturbing and reproducible symptom is that, when logged in, I can
NOT browse Gnash project bugs:
https://savannah.gnu.org/bugs/?group=gnash 

Initially, the above url used to return a 'blank' page, nowadays it luckly
returns some more informations:

 db_query: SQL query error Column 'submitted_by' in 
           order clause is ambiguous in 
 [SELECT DISTINCT 
  bugs.group_id,bugs.priority,bugs.privacy,bugs.status_id,
  bugs.submitted_by,bugs.bug_id,bugs.summary,
  bugs.category_id,bugs.severity,bugs.resolution_id,
  user_assigned_to.user_name AS assigned_to,
  user_submitted_by.user_name AS submitted_by,
  bugs.date FROM bugs ,user user_assigned_to,
  user user_submitted_by 
  WHERE bugs.group_id='8191' AND 
  (bugs.spamscore < '5' OR submitted_by='27281') AND 
  bugs.status_id IN ('1') AND 
  bugs.severity IN ('8','9') AND 
  user_assigned_to.user_id=bugs.assigned_to AND 
  user_submitted_by.user_id=bugs.submitted_by 
  ORDER BY submitted_by ASC LIMIT 0,50]


Both initially and nowadays the symptom does NOT show
up in the following cases:

 1) Browsing bugs of another project, I'm not a
    member of, like
    https://savannah.gnu.org/bugs/?group=grep
    
 2) Browsing bugs of a project on non-gnu.org I'm a member
    of, like:
    https://savannah.nongnu.org/bugs/?group=sins

 3) Browsing gnash bugs but w/out being logged in
    (this requires removing the cookie, or I keep being
    redirected to it). 

 4) (not confirmed by myself)
    Browsing gnash bugs logged in as a different
    project member (reported by others in the team)

Hope this is enough info to easily find out what the
problem is. Managing bugs is being an hard experience
(clean cookies, browse as anonymouse, login when in need
to update one).

Thanks in advance.




    _______________________________________________________

Reply to this item at:

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

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