Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006640Openbravo ERP02. Master data managementpublic2008-12-18 11:322009-03-03 17:16
ReporterYoris 
Assigned Tovmromanos 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Versionubuntu intrepid
Product Version2.40 
Target VersionFixed 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
Summary0006640: Error: no existe la función concat(text,integer)
DescriptionThis error jumps when trying to add a "Bank Account" to a BPartner, it always happens in ubuntu intrepid and windows XP/Vista.
Steps To ReproduceMaster Data Management->BPartner->Bank Account->New
the correct length of a bk acc. in Argentina is 10-15 (usually 12) digits and the iban number is 24 digits long (including Country Code)
fill out all mandatory fields and iban & acc no fields and try to save the account.... (checking either "Show generic" or "Show IBAN" (or both just to try)
Proposed Solutionnone for the problem above, but incresing the digit limit number on Number Account Fields could be on track.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0006502 closed vmromanos Error: no existe la función concat(text,integer) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-18 11:32rafarodaNew Issue
2008-12-18 11:32rafarodaAssigned To => dalsasua
2008-12-18 11:32rafarodaStatusnew => scheduled
2008-12-31 11:58vmromanosAssigned Todalsasua => vmromanos
2008-12-31 12:55svnbotCheckin
2008-12-31 12:55svnbotNote Added: 0011789
2008-12-31 12:55svnbotStatusscheduled => resolved
2008-12-31 12:55svnbotResolutionopen => fixed
2008-12-31 12:55svnbotsvn_revision => 11624
2009-01-06 15:51YorisNote Added: 0011930
2009-01-06 20:16YorisNote Added: 0011933
2009-03-03 17:16psarobeStatusresolved => closed

Notes
(0011789)
svnbot   
2008-12-31 12:55   
Repository: openbravo
Revision: 11624
Author: vmromanos
Date: 2008-12-31 12:55:47 +0100 (Wed, 31 Dec 2008)

Fixed bug 6640: Error in C_BP_BANKACCOUNTIBAN_TRG trigger

---
U branches/r2.40/src-db/database/model/triggers/C_BP_BANKACCOUNTIBAN_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11624&sc=1 [^]
(0011930)
Yoris   
2009-01-06 15:51   
i just downloaded the xml file and noticed the fix, but when i replaced the old one with the this one and compiled it and finally tested the situation the error jumped right up again... should this be reopened? may be other files still have this concat sql function that also have to be replaced? hope to be of some help further on...
(0011933)
Yoris   
2009-01-06 20:16   
nevermind the previous note