Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005270Openbravo ERP01. General setuppublic2008-09-25 16:112008-12-11 17:09
Reporterrafaroda 
Assigned Toalostale 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
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
Summary0005270: '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
depends on backport 0005291 closed alostale 'Database Error' when changing User Role 
depends on backport 0005292 closed alostale 'Database Error' when changing User Role 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-25 16:11rafarodaNew Issue
2008-09-25 16:11rafarodaAssigned To => cromero
2008-09-25 16:11rafarodasf_bug_id0 => 2128495
2008-09-25 16:11rafarodaRegression testing => No
2008-09-25 16:41rafarodaNote Added: 0009201
2008-09-29 09:58psarobeStatusnew => scheduled
2008-09-29 09:58psarobeAssigned Tocromero => alostale
2008-09-29 09:58psarobefix_in_branch => trunk
2008-09-29 10:03FrancescoFinamoreIssue Monitored: FrancescoFinamore
2008-11-11 10:51FrancescoFinamoreIssue End Monitor: FrancescoFinamore
2008-12-10 09:51alostaleAssigned Toalostale => iperdomo
2008-12-11 15:57alostaleAssigned Toiperdomo => alostale
2008-12-11 17:09alostaleStatusscheduled => closed
2008-12-11 17:09alostaleNote Added: 0011191
2008-12-11 17:09alostaleResolutionopen => out of date
2008-12-12 12:12alostaleTag Attached: platform1_sprint1

Notes
(0009201)
rafaroda   
2008-09-25 16:41   
In addition to this:
1) You will be able to change the Role to one the user already has. For instance, if User A has roles Role 1 and Role 2 you will be able to update the drop-down value from Role 1 to Role 2 and from Role 2 to Role 1. But you will not be able to change Role drop-down value from Roles 1 and 2 to Role 3.
2) In the case that you were able to change the Role, you will notice that, even if '1 row/s updated' message displays, the record is not changed. For instance, if you try to update in User A (that has Role 1 and Role 2) Role 1 by Role 2, update successful will display but in grid mode you will keep seeing Role 1 and Role 2 not Role 2 twice.
(0011191)
alostale   
2008-12-11 17:09   
As this bug is due to trying to update a column that is part of the primary key and now there is a new primary key column for this table this bug does not longer affect to trunk.