[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-help-public] [sr #105997] Account messed up
From: |
Sandro Santilli |
Subject: |
[Savannah-help-public] [sr #105997] Account messed up |
Date: |
Sat, 01 Sep 2007 09:19:46 +0000 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.6) Gecko/20061201 Firefox/2.0.0.6 (Ubuntu-feisty) |
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/
- [Savannah-help-public] [sr #105997] Account messed up,
Sandro Santilli <=