Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005292Openbravo ERP01. General setuppublic2008-09-29 09:582009-01-27 10:22
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
Summary0005292: '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 backport 0003969 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:12alostaleRelationship addedrelated to 0003969
2008-12-11 17:12alostaleNote Added: 0011193
2008-12-11 18:10alostaleNote Added: 0011196
2008-12-12 08:31alostaleAssigned Toiperdomo => alostale
2008-12-12 08:55svnbotCheckin
2008-12-12 08:55svnbotNote Added: 0011218
2008-12-12 08:55svnbotStatusscheduled => resolved
2008-12-12 08:55svnbotResolutionopen => fixed
2008-12-12 08:55svnbotsvn_revision => 11136
2008-12-12 12:12alostaleTag Attached: platform1_sprint1
2009-01-27 10:22psarobeRegression testing => No
2009-01-27 10:22psarobeStatusresolved => closed

Notes
(0011193)
alostale   
2008-12-11 17:12   
This is the same bug as 0003969 (update a column that is part of the PK)
(0011196)
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.
(0011218)
svnbot   
2008-12-12 08:55   
Repository: openbravo
Revision: 11136
Author: alostale
Date: 2008-12-12 08:55:22 +0100 (Fri, 12 Dec 2008)

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

---
U branches/r2.3x/database/sourcedata/AD_MESSAGE.xml
U branches/r2.3x/database/sourcedata/AD_MESSAGE_TRL.xml
U branches/r2.3x/database/sourcedata/AD_TEXTINTERFACES.xml
U branches/r2.3x/database/sourcedata/AD_TEXTINTERFACES_TRL.xml
U branches/r2.3x/src-wad/src/org/openbravo/wad/Wad.java
U branches/r2.3x/src-wad/src/org/openbravo/wad/javasource.javaxml
U branches/r2.3x/src-wad/src/org/openbravo/wad/javasource.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11136&sc=1 [^]