Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0003596Openbravo ERP01. General setuppublic2008-01-15 17:102008-06-12 09:44
Reportercromero 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.35MP4 
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
Summary0003596: Bad format in BPLocation when Address2 is null P
Description[ 1855691 ] Bad format in BPLocation when Address2 is null in PostgreSQL

Related to bug:

0002407


If I enter all data in the Business Partner Location window, the format is
right 'Address1 - Address2 - City - ...', but, for i.e, if Address2 is
missing (or any other fields), the formatted string is ''.

The problem is in LocationAddress_Data.xsql:

(TO_CHAR(table4.Address1) || ' - ' || TO_CHAR(table4.Address2) || ' - ' ||
TO_CHAR(table4.Postal) ...

Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0002407 closed alostale Bad format in BPLocation when Address2 is null in PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0007185)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:44)
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=1872204 [^]
(0004064)
cromero   
2008-01-15 17:14   
(edited on: 2008-06-12 09:27)
Logged In: YES
user_id=1500614
Originator: YES

Fixed since revision 2001.
Updated function AD_COLUMN_IDENTIFIER_REF_SQL.

Carlos Romero
Openbravo Team