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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005014
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersminoralways2008-09-11 09:362008-12-16 13:09
ReportervmromanosView Statuspublic 
Assigned Tovmromanos 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision7174
ProjectionnoneETAnoneTarget Versionpi
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 8.04Database version8.3.3Ant version1.7
Product VersionpiSCM revision7158 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005014: Verify Languages does not work on PostgreSQL database

DescriptionWhen you press the "Verify Languages" button inside General Setup || Application || Language || Language, the application returns an error about "duplicate key value violates unique constraint ad_element_trl_key".

Steps To Reproduce1- Go to Setup || Application || Language || Language, select any language, check off "System language" and save the record.
2- Press the "Verify Languages" button and you will see the error.

Important: The bug is only reproducible when using PostgreSQL database.
Proposed SolutionInside ad_language_create.xml file, line 400,

Change:
SELECT get_uuid, C_PaymentTerm_ID, AD_Language, C_PaymentTerm.Name,

by:
SELECT get_uuid(), C_PaymentTerm_ID, AD_Language, C_PaymentTerm.Name,
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0005021 closedrafaroda "get_uuid" does not exist in C_UOM_TRG in PostgreSQL 

-  Notes
(0008984)
svnbot (reporter)
2008-09-11 09:39

Repository: openbravo
Revision: 7174
Author: vmromanos
Date: 2008-09-11 09:39:37 +0200 (Thu, 11 Sep 2008)

Fixed bug 0005014: Verify Languages does not work on PostgreSQL database.

---
U trunk/src-db/database/model/functions/AD_LANGUAGE_CREATE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=7174&sc=1 [^]
(0008990)
vmromanos (manager)
2008-09-11 11:25

Just a clarification: the error the application shows is "no existe la columna «get_uuid»" instead of "duplicate key value violates unique constraint ad_element_trl_key".

So this fix solves the "no existe la columna get_uuid" error.

- Issue History
Date Modified Username Field Change
2008-09-11 09:36 vmromanos New Issue
2008-09-11 09:36 vmromanos Assigned To => vmromanos
2008-09-11 09:36 vmromanos sf_bug_id 0 => 2105167
2008-09-11 09:36 vmromanos Regression testing => No
2008-09-11 09:37 vmromanos Status new => scheduled
2008-09-11 09:37 vmromanos fix_in_branch => trunk
2008-09-11 09:39 svnbot Checkin
2008-09-11 09:39 svnbot Note Added: 0008984
2008-09-11 09:39 svnbot Status scheduled => resolved
2008-09-11 09:39 svnbot Resolution open => fixed
2008-09-11 09:39 svnbot svn_revision => 7174
2008-09-11 11:25 vmromanos Note Added: 0008990
2008-09-11 13:00 rafaroda Relationship added related to 0005021
2008-12-16 13:09 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker