Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0005510 | Openbravo ERP | 01. General setup | public | 2008-10-13 11:37 | 2008-11-25 14:16 |
|
| Reporter | joan | |
| Assigned To | cromero | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | Debian Etch |
| Product Version | 2.40 | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| 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. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | depends on | backport | 0005583 | | closed | cromero | Problem installing Openbravo | | has duplicate | defect | 0005553 | | closed | | c_invoice_post not found in OB2.40 with Postgresql |
|
| Attached Files |  01database.log (105,566) 2008-10-13 11:37
https://issues.openbravo.com/file_download.php?file_id=321&type=bug |
|
| 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 |
|
|
|
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
|
|
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. |
|
|
|
|
You are affected because you use PostgreSQl 8.1 that does not accept the notation:
delete from c_taxregisterline trl |
|
|
|
(0009568)
|
|
joan
|
|
2008-10-14 16:36
|
|
|
Should I upgrade?, there is any other thing like this? |
|
|
|
|
|
We will fix but we strongly recommend you to upgrade to 8.3.3. You will notice lot of performance improvements |
|
|
|
(0009995)
|
|
svnbot
|
|
2008-11-05 12:11
|
|
|