Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006760Openbravo ERP01. General setuppublic2008-12-30 13:522009-01-19 15:59
ReporterrachelJohnston 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version2.50alpha-r5 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006760: SQL error when accessing User setup
DescriptionWhen I click General Setup > Security > User, I get an SQL error:

Error:
ERROR: more than one row returned by a subquery used as an expression

I am logged in as Openbravo / openbravo I have tried various different roles (sys, openbravo admin and ones I have set up myself) with the same result.
Steps To ReproduceAs above.
Proposed SolutionIf this is user error in some way, would it be possible to reword the error message to something more meaningful?
Additional Information
TagsNo tags attached.
Relationships
related to defect 0006506 closed alostale Not able to create a user in General Setup 
has duplicate defect 0006530 closed shuehner userA cannot see General Setup - Security - User 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-30 13:52rachelJohnstonNew Issue
2008-12-30 13:52rachelJohnstonAssigned To => rafaroda
2008-12-30 13:52rachelJohnstonsf_bug_id0 => 2477150
2008-12-30 13:52rachelJohnstonOBNetwork customer => No
2008-12-30 13:52rachelJohnstonRegression testing => No
2009-01-09 19:02psarobePriorityhigh => urgent
2009-01-09 19:04psarobeStatusnew => scheduled
2009-01-09 19:04psarobeNote Added: 0012075
2009-01-09 19:04psarobeAssigned Torafaroda => alostale
2009-01-09 19:04psarobefix_in_branch => trunk
2009-01-09 19:41psarobeRelationship addedhas duplicate 0006530
2009-01-19 15:58alostaleRelationship addedrelated to 0006506
2009-01-19 15:59alostaleStatusscheduled => closed
2009-01-19 15:59alostaleNote Added: 0012349
2009-01-19 15:59alostaleResolutionopen => unable to reproduce

Notes
(0012075)
psarobe   
2009-01-09 19:04   
This seems to be a regression because Asier already fixed this bug previous to R5

Thanks Rachel
(0012349)
alostale   
2009-01-19 15:59   
With the current trunk revision (12009) I'm not able to reproduce it, this may be fixed by issue 0006506