Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011712Openbravo ERPA. Platformpublic2009-12-09 17:142009-12-11 06:38
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0011712: ad_db_modified function found structure changes in the database when there had been no change
DescriptionThe ad_db_modified function (which is used in update.database and export.database to find out if there were changes in the database structure) didn't work correctly when the database was exported in a .dmp file and imported in a new database.

Specifically, it found changes even if no change had been done.
Steps To ReproduceCreate the database (install.source, update.database, ...).
Check that you can do update.database without problems (=you don't get the -Dforce error).
Export the database to a dmp file.
Import it again in a new database. Change your Openbravo.properties file so that it points to this new database.
Do update.database again. It will fail because it finds "differences" in the new database, although it's identical to the old one.
Proposed SolutionThe function needs to be fixed.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-09 17:14marvintmNew Issue
2009-12-09 17:14marvintmAssigned To => marvintm
2009-12-09 17:14marvintmOBNetwork customer => No
2009-12-09 17:16hgbotCheckin
2009-12-09 17:16hgbotNote Added: 0022596
2009-12-09 17:16hgbotStatusnew => resolved
2009-12-09 17:16hgbotResolutionopen => fixed
2009-12-09 17:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/22091b0e5d61bc1952872a0d3538637c1ecc9f60 [^]
2009-12-10 14:11shuehnerNote Added: 0022641
2009-12-10 14:11shuehnerStatusresolved => closed
2009-12-11 00:00anonymoussf_bug_id0 => 2912328
2009-12-11 06:35hudsonbotCheckin
2009-12-11 06:35hudsonbotNote Added: 0022671
2009-12-11 06:38hudsonbotCheckin
2009-12-11 06:38hudsonbotNote Added: 0022678

Notes
(0022596)
hgbot   
2009-12-09 17:16   
Repository: erp/devel/pi
Changeset: 22091b0e5d61bc1952872a0d3538637c1ecc9f60
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Dec 09 17:15:57 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/22091b0e5d61bc1952872a0d3538637c1ecc9f60 [^]

Fixed issue 11712. Function will now work even if you export/import the whole database.

---
M src-db/database/model/prescript-PostgreSql.sql
---
(0022641)
shuehner   
2009-12-10 14:11   
tested, checksum checks still works fine (detects not change) after dumping and recreating the database on postgres using both plain and custom backup-format.
(0022671)
hudsonbot   
2009-12-11 06:35   
---
A changeset related to this issue has passed a series of tests and has been promoted to main:

Changeset: http://code.openbravo.com/erp/devel/main/rev/789f4e19eaf7 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
---
(0022678)
hudsonbot   
2009-12-11 06:38   
---
An OBX is generated including a changeset related to this issue and is available at:

OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15682.obx [^]
---