Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0017287
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. PlatformminorN/A2011-05-19 19:062022-02-01 08:08
ReporterrafademiguelView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0RC6.1SCM revision 
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
Summary

0017287: There is a Unique Index for "Name" in table "AD_Package" called AD_PACKAGE_NAME but Name don't have to start with the prefix

DescriptionThere is a Unique Index for column "Name" in table "AD_Package" called AD_PACKAGE_NAME but Name don't have to start with the prefix so if two people use the same name (although have differences package name) the update database crash.

     [java] 63654 ERROR - Error while inserting into the database: ERROR: llave duplicada viola restricción de unicidad «ad_package_name»
     [java] Detail: Ya existe la llave (name)=(Data).
     [java] org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «ad_package_name»
     [java] Detail: Ya existe la llave (name)=(Data).


I propose or eliminate the unique index or force the column name to start with OBPREFIX.

(It had occurred with name "data" in a real situation)

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0052444)
AugustoMauch (administrator)
2012-09-24 21:18

Effort: 1
Impact: mid
Plan: mid

- Issue History
Date Modified Username Field Change
2011-05-19 19:06 rafademiguel New Issue
2011-05-19 19:06 rafademiguel Assigned To => alostale
2011-05-19 19:06 rafademiguel Modules => Core
2011-05-19 19:06 rafademiguel OBNetwork customer => No
2011-05-23 08:14 alostale Status new => scheduled
2011-11-23 10:37 alostale Type defect => design defect
2012-09-24 21:18 AugustoMauch Note Added: 0052444
2017-03-31 14:36 alostale Status scheduled => acknowledged
2017-04-10 14:34 alostale Assigned To alostale => platform
2022-02-01 08:08 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker