Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005014Openbravo ERPZ. Otherspublic2008-09-11 09:362008-12-16 13:09
Reportervmromanos 
Assigned Tovmromanos 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04
Product Versionpi 
Target VersionpiFixed in Version 
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
Summary0005014: 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,
Additional Information
TagsNo tags attached.
Relationships
related to defect 0005021 closed rafaroda "get_uuid" does not exist in C_UOM_TRG in PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-11 09:36vmromanosNew Issue
2008-09-11 09:36vmromanosAssigned To => vmromanos
2008-09-11 09:36vmromanossf_bug_id0 => 2105167
2008-09-11 09:36vmromanosOBNetwork customer => No
2008-09-11 09:36vmromanosRegression testing => No
2008-09-11 09:37vmromanosStatusnew => scheduled
2008-09-11 09:37vmromanosfix_in_branch => trunk
2008-09-11 09:39svnbotCheckin
2008-09-11 09:39svnbotNote Added: 0008984
2008-09-11 09:39svnbotStatusscheduled => resolved
2008-09-11 09:39svnbotResolutionopen => fixed
2008-09-11 09:39svnbotsvn_revision => 7174
2008-09-11 11:25vmromanosNote Added: 0008990
2008-09-11 13:00rafarodaRelationship addedrelated to 0005021
2008-12-16 13:09psarobeStatusresolved => closed

Notes
(0008984)
svnbot   
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   
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.