Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011712Openbravo ERPA. Platformpublic2009-12-09 17:142009-12-11 06:38
marvintm 
marvintm 
normalmajorhave not tried
closedfixed 
5
 
 
Core
No
0011712: ad_db_modified function found structure changes in the database when there had been no change
The 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.
Create 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.
The function needs to be fixed.
No tags attached.
Issue History
2009-12-09 17:14marvintmNew Issue
2009-12-09 17:14marvintmAssigned To => marvintm
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 [^]
---