Hello, summary: - update.database (with code from 2009-12-24 until 2009-12-28) failed on pi-branch with PostgreSQL - no public release is affected, only the pi branch
this issue only affects the pi branch from 2009-12-24 until today (2009-12-28) and only when used with the PostgreSQL. The update.database failed with an error when working on BLOB columns used for the logo images. The error message shown was: ERROR: column "binarydata" is of type oid but expression is of type bytea which can be seen at: http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/1353/console The issue is fixed now, but when update.database was run with the broken code, then some rows of the ad_image table have been deleted, but the foreign values in i.e. ad_system_info still point to the deleted records. This will cause the update.database process to still fails as can be seen here: http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/1354/console To fix the db state the easiest solution is to recreate the database. If the db-content needs to be preserved, an alternative manual fix can be done. The affected columns can be set to null and then the images need to be re-inserted into the database (which can be done by calling 'ant load.logoimages' Again, only the people who did update.database on pi with code from 2009-12-24 and 2009-12-28 might be affected.. Regards, Stefan ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Openbravo-development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-development
