Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0007806

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 07. Sales management

major

always

2009-02-24 20:18

2009-04-22 00:00

Reporter

villind

View Status

public

Assigned To

gmauleon

Priority

high

Resolution

fixed

Fixed in Version

2.50

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

PostgreSQL

Java version

OS Version

Database version

Ant version

Product Version

2.40MP3

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0007806: Copy product template in simple sales order does not work with Postgresql

Description

Copy product template in simple sales order does not work with Postgresql due to datatype mismatch.

Steps To Reproduce

Click copy product template

Proposed Solution

See the attached patch

Tags

No tags attached.

copy-product-template_postgresql-datatype-fix.diff [^] (618 bytes) 2009-02-24 20:18 [Show Content] [Hide Content]

Index: src-db/database/model/functions/COPY_PRODUCT_TEMPLATE.xml
===================================================================
--- src-db/database/model/functions/COPY_PRODUCT_TEMPLATE.xml	(revision 13598)
+++ src-db/database/model/functions/COPY_PRODUCT_TEMPLATE.xml	(revision 13599)
@@ -98,7 +98,7 @@
       FROM M_PRODUCT_TEMPLATE,
         M_PRODUCT
       WHERE M_PRODUCT_TEMPLATE.M_PRODUCT_ID=M_PRODUCT.M_PRODUCT_ID
-        AND M_PRODUCT_TEMPLATE.TYPE_TEMPLATE IN(2, 3)
+        AND M_PRODUCT_TEMPLATE.TYPE_TEMPLATE IN('2', '3')
         AND M_PRODUCT_TEMPLATE.C_Bpartner_Id=v_Bpartner
       )
     LOOP

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on	backport	0007918		closed	gmauleon	Copy product template in simple sales order does not work with Postgresql
has duplicate	defect	0008296		closed	rafaroda	Copy product template process does not work in Simple Sales Order
related to	defect	0011817		closed	harikrishnan	Copy Product Template displays error in Simple Sales Order

Notes
(0014327) hgbot (developer) 2009-03-03 16:51	Repository: erp/devel/pi Changeset: 10f5e39b2c865ee2f510ea09af6cc7c9f9a0fdce Author: Gorka Mauleon <gorka.mauleon <at> openbravo.com> Date: Tue Mar 03 16:31:45 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/10f5e39b2c865ee2f510ea09af6cc7c9f9a0fdce [^] Fixes 0007806: Copy product template in simple sales order does not work with Postgresql --- M src-db/database/model/functions/M_COPY_PRODUCT_TEMPLATE.xml ---

Issue History
Date Modified	Username	Field	Change
2009-02-24 20:18	villind	New Issue
2009-02-24 20:18	villind	Assigned To	=> rafaroda
2009-02-24 20:18	villind	File Added: copy-product-template_postgresql-datatype-fix.diff
2009-02-24 20:18	villind	Regression testing	=> No
2009-03-03 13:32	rafaroda	Assigned To	rafaroda => gmauleon
2009-03-03 13:32	rafaroda	Priority	normal => high
2009-03-03 13:32	rafaroda	Status	new => scheduled
2009-03-03 13:32	rafaroda	fix_in_branch	=> trunk
2009-03-03 16:51	hgbot	Checkin
2009-03-03 16:51	hgbot	Note Added: 0014327
2009-03-03 16:51	hgbot	Status	scheduled => resolved
2009-03-03 16:51	hgbot	Resolution	open => fixed
2009-03-03 16:51	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/10f5e39b2c865ee2f510ea09af6cc7c9f9a0fdce [^]
2009-03-27 10:23	rafaroda	Relationship added	has duplicate 0008296
2009-04-21 10:33	psarobe	Status	resolved => closed
2009-04-22 00:00	anonymous	sf_bug_id	0 => 2778007
2010-05-31 13:41	rafaroda	Relationship added	related to 0011817

Copyright © 2000 - 2009 MantisBT Group