Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005510 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | major | always | 2008-10-13 11:37 | 2008-11-25 14:16 | |||
| Reporter | joan | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 9683 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.5.0_14 | |||
| OS Version | Debian Etch | Database version | 8.1 | Ant version | 1.6.5 | |||
| Product Version | 2.40 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005510: Problem installing Openbravo | |||||||
| Description | When i try to install openbravo as a developer it always fails in one function. Y copy the log where the error occours. | |||||||
| Steps To Reproduce | Install Openbravo (it happens also on 2.40b) Accept license Specify Ob Dir, any Attach dir, any Installation mode, 1 Complete instalation, 2(development) Everything else by default. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  01database.log [^] (105,566 bytes) 2008-10-13 11:37 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0009534) cromero (viewer) 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 (viewer) 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 (viewer) 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 (viewer) 2008-10-14 16:36 |
Should I upgrade?, there is any other thing like this? |
|
(0009643) psarobe (viewer) 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 (viewer) 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 [^] |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |