Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006992Openbravo ERP08. Project and service managementpublic2009-01-19 13:182009-04-21 12:36
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version8.3
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006992: update.database fails on postgres across revision r11806
DescriptionCommit 11806 introduced an onCreateDefault clause for the field "ALLOWNEGATIVE" with the value Y where the correct form would be 'Y' with quotes.

For reproducing you have to go before the revision which did add the ALLOWNEGATIVE column in the beginning which is r11567
Steps To Reproducecheckout r2.40 revision 11566
use create.database on r2.40
svn update to current r2.40
use update.database.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0006994 closed rafaroda update.database fails on postgres across revision r11806 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-19 13:18shuehnerNew Issue
2009-01-19 13:18shuehnerAssigned To => rafaroda
2009-01-19 13:18shuehnersf_bug_id0 => 2519621
2009-01-19 13:18shuehnerRegression testing => No
2009-01-19 13:29shuehnerNote Added: 0012330
2009-01-19 13:51shuehnerDescription Updated
2009-01-19 13:51shuehnerProposed Solution updated
2009-01-19 13:51shuehnerStatusnew => scheduled
2009-01-19 13:51shuehnerAssigned Torafaroda => shuehner
2009-01-19 13:51shuehnerfix_in_branch => trunk
2009-01-19 15:08svnbotCheckin
2009-01-19 15:08svnbotNote Added: 0012346
2009-01-19 15:08svnbotStatusscheduled => resolved
2009-01-19 15:08svnbotResolutionopen => fixed
2009-01-19 15:08svnbotsvn_revision => 12008
2009-04-21 12:36psarobeStatusresolved => closed

Notes
(0012330)
shuehner   
2009-01-19 13:29   
In addition the onCreateDefault is missing in the trunk table and should be added.
(0012346)
svnbot   
2009-01-19 15:08   
Repository: openbravo
Revision: 12008
Author: huehner
Date: 2009-01-19 15:08:17 +0100 (Mon, 19 Jan 2009)

Fixed 6992
Add missing onCreateDefault = 'Y' for column ALLOWNEGATIVE

---
U trunk/src-db/database/model/tables/C_ACCTSCHEMA.xml
---

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