Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006464Openbravo ERPA. Platformpublic2008-12-10 14:482009-07-03 16:12
Reportervillind 
Assigned Toalostale 
PriorityurgentSeveritycriticalReproducibilitysometimes
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version2.40MP1 
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
Summary0006464: User editing account editing is not possible
DescriptionUser account editing is not possible, or any operation that uses AD_USER as a primary table. As the table name is ambiguous the result is unpredictable.
Steps To ReproduceEnter screen users. It may break or not. It all depend on the data.
Proposed SolutionSee the attached patch
Additional Information
Tagsplatform1_sprint1
Relationships
duplicate of backport 0006509 closed alostale Not able to create a user in General Setup 
Attached Filesdiff audit_data_fix.diff (1,320) 2008-12-10 14:48
https://issues.openbravo.com/file_download.php?file_id=521&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-12-10 14:48villindNew Issue
2008-12-10 14:48villindAssigned To => shuehner
2008-12-10 14:48villindsf_bug_id0 => 2413857
2008-12-10 14:48villindFile Added: audit_data_fix.diff
2008-12-10 14:48villindRegression testing => No
2008-12-10 16:28svnbotCheckin
2008-12-10 16:28svnbotNote Added: 0011158
2008-12-10 16:28svnbotStatusnew => resolved
2008-12-10 16:28svnbotResolutionopen => fixed
2008-12-10 16:28svnbotsvn_revision => 11094
2008-12-10 16:29villindStatusresolved => new
2008-12-10 16:29villindResolutionfixed => open
2008-12-10 16:29villindNote Added: 0011159
2008-12-11 09:43networkbIssue Monitored: networkb
2008-12-11 09:43networkbPrioritynormal => immediate
2008-12-11 10:56rafarodaNote Added: 0011170
2008-12-11 10:56rafarodaAssigned Toshuehner => alostale
2008-12-11 10:56rafarodaStatusnew => feedback
2008-12-11 11:30villindNote Added: 0011171
2008-12-11 18:30shuehnerNote Added: 0011203
2008-12-15 14:26alostaleTag Attached: platform1_sprint1
2008-12-15 14:26alostaleRelationship addedduplicate of 0006509
2008-12-15 14:26alostaleStatusfeedback => closed
2008-12-15 14:26alostaleDuplicate ID0 => 6509
2008-12-15 14:26alostaleResolutionopen => duplicate
2009-07-03 16:12pjuvaraPriorityimmediate => urgent

Notes
(0011158)
svnbot   
2008-12-10 16:28   
Repository: openbravo
Revision: 11094
Author: villind
Date: 2008-12-10 16:28:29 +0100 (Wed, 10 Dec 2008)

Fixed 0006464: User editing account editing is not possible

---
U branches/bonware/r2.40/src-wad/src/org/openbravo/wad/datasource.xsqlxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11094&sc=1 [^]
(0011159)
villind   
2008-12-10 16:29   
Fixed in Bonware branch, not in r2.40 maintenance.
(0011170)
rafaroda   
2008-12-11 10:56   
Villind, thank you for the patch, we will review it. But please provide extended description and steps to reproduce. Thank you.
(0011171)
villind   
2008-12-11 11:30   
This depend on the data and probably also on query planner decision. When a table is used more than one time in a query the alias should always be used to make the query unambiguous.

There are two windows that can be used to reproduce this:
 * User
 * Business Partner -> Contact
(0011203)
shuehner   
2008-12-11 18:30   
Note: The same code is present in trunk and should be fixed there as well. It was introduced by changing the Audit Info fields from comboboxes to normal textfields.