Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002076Openbravo ERP08. Project and service managementpublic2007-10-11 09:492008-07-08 12:18
Reporteruser71 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002076: Can't save expense lines in expense sheet
Description
OS: Linux - Centos 4 (test/prod) & Windows XP (dev)
DB: Postgres 8.1.9 (test/prod) & 8.2.4 (dev)
Release: 2.34
Browser: Firefox 2.0.0.6, IE 7

When trying to add a line to an expense sheet get the following error

record "old" is not assigned yet
The tuple structure of a not-yet-assigned record is indeterminate.

This is caused by s_timeexpsenseline_trg refering to the 'OLD' row on an insert.

Attach sql script has working version of the trigger
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003594 closed cromero Can't save expense lines in expense sheet 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-08 12:18psarobeStatusresolved => closed

Notes
(0005665)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1811343 [^]
(0002344)
cromero   
2008-01-15 12:40   
(edited on: 2008-06-12 09:22)
Logged In: YES
user_id=1500614
Originator: NO

Fixed.

I have committed in the trunk the corrected version of this trigger (revision 1986).

Thank you Ben for your patch. I have reviewed it and it works, but I have looked for the cause of this line and I have recoded it just to be executed only in UPDATE mode.

Carlos Romero
Openbravo Team