Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002826Openbravo ERP00. Application dictionarypublic2008-04-08 09:552008-06-18 20:00
Reporterpsarobe 
Assigned ToDowid 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
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
Summary0002826: Translations windows. No possibility of chosing a language
DescriptionIn most of the translations tabs is not possible to select a language so this feature cannot be used

Seeing the configuration of this tabs, all seems to have sense but at last it does not work properly.

You can have the example of this in Product window, UOM window, etc...
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003676 closed pheenan Translations windows. No possibility of chosing  
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-18 20:00psarobeStatusresolved => closed

Notes
(0006415)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1937441 [^]
(0003474)
cromero   
2008-04-08 10:36   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1500614
Originator: NO

This errors has been found in the trunk
(0003475)
Dowid   
2008-04-08 11:38   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1630374
Originator: NO


The reason of the bug in my opinion consists of the following (It should be noted, that the reason of this bug is the same as the reason in bug - [ 1879633 ] Error in Application translation check window https://sourceforge.net/tracker/index.php?func=detail&aid=1879633&group_id=162271&atid=823129 [^]):

An incorrect key is set in the Application Dictionary, in the AD_language table. The AD_Language table has a non-standard (For OpenBravo) primary key - AD_LANGUAGE VARCHAR2(6 BYTE)in the database. The primary key in the AD was set to AD_Language_ID, which is a "synthetic" primary key, and it IS NOT a primary key in the database.

To correct this bug, I've switched around the properties for columns AD_Language and AD_Language_ID and the bug disappeared.

Below please view the changes:

Table (AD_LAnguage) -> Column:
1. AD_Language:
  Referense: String
  Mandatory: Y
  Key column: Y
2. AD_Language_ID:
  Referense: ID
  Mandatory: Y
  Key column: N
  Default Value: @SQL=SELECT COALESCE(MAX(AD_Language_ID),0)+1 AS DefaultValue FROM AD_Language
  Secondary Key: Y
      
(0003476)
cromero   
2008-04-09 18:53   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1500614
Originator: NO

This is not the correct solution.
The solution is setting:
* Column to not updatable (unchecked)
* Field to not readonly (unchecked)

Carlos
(0003477)
Dowid   
2008-04-10 10:03   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1630374
Originator: NO

Carlos, you are correct. I've made a mistake, believing that this bug and bug
[1879633 ] Error in Application translation check window share the same core problem.

Thank you Carlos.
(0003478)
cromero   
2008-04-10 11:27   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1500614
Originator: NO

This solution should be applied to tables:

C_Country_trl
C_Currrency_TRL
c_taxCategory_trl
c_greeting_trl
C_uom_trl
C_Doctype_trl
C_elementvalue_trl
C_paymentterm_trl
M_product_trl
C_TAX_TRL
(0003479)
Dowid   
2008-04-10 17:06   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1630374
Originator: NO

Bug fixed.
During the creation of a new record in the translation tab you can select a language. However, Language cannot be modified in existing records.


Changes applied:

* Column not updatable (unchecked): already preset for this columns.
Language cannot be modified in existing records.

* Field to not readonly (unchecked):
1. C_Country_Trl: Window Country Region and City -> tab Translation -> field Language, Readonly: N
2. C_DocType_Trl: Window Document Type -> tab Translation -> field Language, Readonly: N
3. C_ElementValue_Trl: window Account Tree -> tab Translation -> field Language, Readonly: N
4. C_Greeting_Trl: Title -> tab Translation -> field Language, Readonly: N
5. C_PaymentTerm_Trl: Window Payment Term -> tab Translation -> field Language, Readonly: N
6. C_TaxCategory_Trl: Window Tax Category-> tab Translation -> field Language, Readonly: N
7. C_UOM_Trl: Window Unit of Measure -> tab Translation -> field Language, Readonly: N
8. M_Product_Trl: Window Product-> tab Translation -> field Language, Readonly: N

already preset:
c_tax_trl: window Tax Rate -> tab Translation -> field Language Readonly: N
C_Currency_TRL: window Currency-> tab Translation-> field Language Readonly: N