0005510: Problem installing Openbravo - Openbravo Issue Tracking System

(0009534)
cromero (reporter)
2008-10-13 11:47

The problem is in this sentence:

[createdatabase] delete from c_taxregisterline trl where trl.c_invoicetax_id in
[createdatabase] (select trl.c_invoicetax_id
[createdatabase] FROM c_taxregisterline trl
[createdatabase] inner join c_invoicetax it on trl.c_invoicetax_id = it.c_invoicetax_id
[createdatabase] inner join c_taxregister tr on tr.c_taxregister_id= trl.c_taxregister_id
[createdatabase] inner join c_taxpayment tp on tr.c_taxpayment_id=tp.c_taxpayment_id
[createdatabase] WHERE it.c_invoice_id = v_record_id
[createdatabase] and tp.processed='N');

It should be:

[createdatabase] delete from c_taxregisterline where c_taxregisterline.c_invoicetax_id in
[createdatabase] (select trl.c_invoicetax_id
[createdatabase] FROM c_taxregisterline trl
[createdatabase] inner join c_invoicetax it on trl.c_invoicetax_id = it.c_invoicetax_id
[createdatabase] inner join c_taxregister tr on tr.c_taxregister_id= trl.c_taxregister_id
[createdatabase] inner join c_taxpayment tp on tr.c_taxpayment_id=tp.c_taxpayment_id
[createdatabase] WHERE it.c_invoice_id = v_record_id
[createdatabase] and tp.processed='N');

(0009535)
joan (reporter)
2008-10-13 11:52

I am the only one who is affected with this error?, i'm unsure if it is because i have "unclean" my machine or because it is a bug on 2.40 version or why it happens.

(0009566)
cromero (reporter)
2008-10-14 16:31

You are affected because you use PostgreSQl 8.1 that does not accept the notation:
delete from c_taxregisterline trl

(0009568)
joan (reporter)
2008-10-14 16:36

Should I upgrade?, there is any other thing like this?

(0009643)
psarobe (manager)
2008-10-20 11:16

We will fix but we strongly recommend you to upgrade to 8.3.3. You will notice lot of performance improvements

(0009995)
svnbot (reporter)
2008-11-05 12:11

Repository: openbravo
Revision: 9683
Author: cromeroherrero
Date: 2008-11-05 12:11:49 +0100 (Wed, 05 Nov 2008)

Fixed bug 5510: Problem installing Openbravo

---
U trunk/src-db/database/model/functions/C_INVOICE_POST.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9683&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-10-13 11:37	joan	New Issue
2008-10-13 11:37	joan	Assigned To	=> cromero
2008-10-13 11:37	joan	sf_bug_id	0 => 2163203
2008-10-13 11:37	joan	File Added: 01database.log
2008-10-13 11:47	cromero	Note Added: 0009534
2008-10-13 11:52	joan	Note Added: 0009535
2008-10-14 16:31	cromero	Note Added: 0009566
2008-10-14 16:36	joan	Note Added: 0009568
2008-10-17 09:30	rafaroda	Relationship added	has duplicate 0005553
2008-10-17 09:43	mmarquez	Issue Monitored: mmarquez
2008-10-20 11:16	psarobe	Status	new => scheduled
2008-10-20 11:16	psarobe	Note Added: 0009643
2008-10-20 11:16	psarobe	fix_in_branch	=> trunk
2008-11-05 12:11	svnbot	Checkin
2008-11-05 12:11	svnbot	Note Added: 0009995
2008-11-05 12:11	svnbot	Status	scheduled => resolved
2008-11-05 12:11	svnbot	Resolution	open => fixed
2008-11-05 12:11	svnbot	svn_revision	=> 9683
2008-11-25 14:16	psarobe	Regression testing	=> No
2008-11-25 14:16	psarobe	Status	resolved => closed

Notes
(0009534) cromero (reporter) 2008-10-13 11:47	The problem is in this sentence: [createdatabase] delete from c_taxregisterline trl where trl.c_invoicetax_id in [createdatabase] (select trl.c_invoicetax_id [createdatabase] FROM c_taxregisterline trl [createdatabase] inner join c_invoicetax it on trl.c_invoicetax_id = it.c_invoicetax_id [createdatabase] inner join c_taxregister tr on tr.c_taxregister_id= trl.c_taxregister_id [createdatabase] inner join c_taxpayment tp on tr.c_taxpayment_id=tp.c_taxpayment_id [createdatabase] WHERE it.c_invoice_id = v_record_id [createdatabase] and tp.processed='N'); It should be: [createdatabase] delete from c_taxregisterline where c_taxregisterline.c_invoicetax_id in [createdatabase] (select trl.c_invoicetax_id [createdatabase] FROM c_taxregisterline trl [createdatabase] inner join c_invoicetax it on trl.c_invoicetax_id = it.c_invoicetax_id [createdatabase] inner join c_taxregister tr on tr.c_taxregister_id= trl.c_taxregister_id [createdatabase] inner join c_taxpayment tp on tr.c_taxpayment_id=tp.c_taxpayment_id [createdatabase] WHERE it.c_invoice_id = v_record_id [createdatabase] and tp.processed='N');

(0009535) joan (reporter) 2008-10-13 11:52	I am the only one who is affected with this error?, i'm unsure if it is because i have "unclean" my machine or because it is a bug on 2.40 version or why it happens.

(0009566) cromero (reporter) 2008-10-14 16:31	You are affected because you use PostgreSQl 8.1 that does not accept the notation: delete from c_taxregisterline trl

(0009568) joan (reporter) 2008-10-14 16:36	Should I upgrade?, there is any other thing like this?

(0009643) psarobe (manager) 2008-10-20 11:16	We will fix but we strongly recommend you to upgrade to 8.3.3. You will notice lot of performance improvements

(0009995) svnbot (reporter) 2008-11-05 12:11	Repository: openbravo Revision: 9683 Author: cromeroherrero Date: 2008-11-05 12:11:49 +0100 (Wed, 05 Nov 2008) Fixed bug 5510: Problem installing Openbravo --- U trunk/src-db/database/model/functions/C_INVOICE_POST.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=9683&sc=1 [^]