Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005291Openbravo ERP01. General setuppublic2008-09-29 09:582009-05-19 09:09
Reporterrafaroda 
Assigned Toalostale 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005291: 'Database Error' when changing User Role
DescriptionWhen trying to change a role of an user (via 'User Roles' tab), 'Database Error' displays (with no other message in the log file).

This bug also reproduces in 2.3x branch but does not reproduce in the trunk.
Steps To Reproduce1) Log in as 'Openbravo Admin'.
2) Select an user in 'General Setup || Security || User || User'.
3) Go to 'User Roles' tab and edit one record changing its role, for instance, from 'Admin' to 'Production'.
Proposed Solution'Database Error' message displays.
Additional Information
Tagsplatform1_sprint1
Relationships
related to defect 00001722.40alpha-r2 closed alostale Database error when updating a Org Access Role 
blocks defect 0005270 closed alostale 'Database Error' when changing User Role 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-29 09:58psarobeNew Issue
2008-09-29 09:58psarobeAssigned To => alostale
2008-09-29 09:58psarobeStatusnew => scheduled
2008-12-10 09:51alostaleAssigned Toalostale => iperdomo
2008-12-11 17:11alostaleRelationship addedrelated to 0000172
2008-12-11 17:11alostaleNote Added: 0011192
2008-12-11 18:10alostaleNote Added: 0011195
2008-12-11 18:11svnbotCheckin
2008-12-11 18:11svnbotNote Added: 0011197
2008-12-11 18:11svnbotStatusscheduled => resolved
2008-12-11 18:11svnbotResolutionopen => fixed
2008-12-11 18:11svnbotsvn_revision => 11124
2008-12-12 08:29alostaleAssigned Toiperdomo => alostale
2008-12-12 08:29alostaleStatusresolved => new
2008-12-12 08:29alostaleResolutionfixed => open
2008-12-12 08:29alostaleStatusnew => scheduled
2008-12-12 08:29alostalefix_in_branch2.40 => trunk
2008-12-12 08:30alostaleStatusscheduled => resolved
2008-12-12 08:30alostaleResolutionopen => fixed
2008-12-12 12:12alostaleTag Attached: platform1_sprint1
2009-05-19 09:09sureshbabuRegression testing => No
2009-05-19 09:09sureshbabuStatusresolved => closed
2009-05-19 09:09sureshbabuNote Added: 0016441

Notes
(0011192)
alostale   
2008-12-11 17:11   
This is the same bug as 0000172 (update a column that is part of the PK)
(0011195)
alostale   
2008-12-11 18:10   
As the solution for this bug is quite complex and would add instability and there is an easy workarround which consists in deleting the current record and creating a new one with the proper role, the solution for this bug will just show a message telling the user to do this.
(0011197)
svnbot   
2008-12-11 18:11   
Repository: openbravo
Revision: 11124
Author: alostale
Date: 2008-12-11 18:11:06 +0100 (Thu, 11 Dec 2008)

fixed bug 0005291: 'Database Error' when changing User Role

---
U branches/r2.40/src-db/database/sourcedata/AD_MESSAGE.xml
U branches/r2.40/src-wad/src/org/openbravo/wad/Wad.java
U branches/r2.40/src-wad/src/org/openbravo/wad/javasource.javaxml
U branches/r2.40/src-wad/src/org/openbravo/wad/javasource.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11124&sc=1 [^]
(0016441)
sureshbabu   
2009-05-19 09:09   
As per the Developer comments, issue has been fixed.