details: https://code.openbravo.com/erp/devel/pi/rev/49791985066f
changeset: 22908:49791985066f
user: Augusto Mauch <augusto.mauch <at> openbravo.com>
date: Thu Apr 24 14:03:37 2014 +0200
summary: Fixes issue 26308: Product Characteristics tree is not working
properly
The previous fix worked only if the product characteristic tree was already
created.
The product characteristic tree is created when the first product
characteristic is defined. The tree was being created without ad_table_id, and
this column was not being set properly until the modulescripts are executed.
This has been fixed by providing the proper ad_table_id in the tree creation.
diffstat:
src-db/database/model/triggers/M_CHARACTERISTIC_TRG.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (17 lines):
diff -r 2fa563c7719d -r 49791985066f
src-db/database/model/triggers/M_CHARACTERISTIC_TRG.xml
--- a/src-db/database/model/triggers/M_CHARACTERISTIC_TRG.xml Thu Apr 24
12:00:35 2014 +0200
+++ b/src-db/database/model/triggers/M_CHARACTERISTIC_TRG.xml Thu Apr 24
14:03:37 2014 +0200
@@ -43,11 +43,11 @@
INSERT INTO ad_tree (
ad_tree_id, ad_client_id, ad_org_id, isactive,
created, createdby, updated, updatedby,
- name, description, treetype, isallnodes
+ name, description, treetype, isallnodes, ad_table_id
) VALUES (
v_tree_id, :NEW.ad_client_id, '0', :NEW.isactive,
now(), :NEW.createdby, now(), :NEW.updatedby,
- 'Product Characteristic tree', null, 'CH', 'Y'
+ 'Product Characteristic tree', null, 'CH', 'Y',
'E913D17C9B3847CF92235082DBE2EC44'
);
:NEW.ad_tree_id := v_tree_id;
END IF;
------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
