Hello Jay, Last news, the problem is solved and here was the trick: Purchase_warn, sale_warn, invoice_warn and picking_warn in table res_partner were not the only 4 fields to have changed type from varchar to boolean during the upgrade. There were actually 2 more fields, namely purchase_line_warn and sale_line_warn in the product_product table. So in total, there were 6 fields affected during the upgrade! So I had to follow the same basic process of changing the field types from boolean back to varchar(50) for these 2 extra fields and the trick was done. That's all there was to it.
I actually wonder if the reason of this extra field type change is due to our use of the module product_variant. Any hint on that? Thank you very much Jay for your guidance and hope that this info will help someone else. Cheers! -- You received this bug notification because you are a member of C2C OERPScenario, which is subscribed to the OpenERP Project Group. https://bugs.launchpad.net/bugs/421524 Title: warning update module warning Status in OpenERP Modules (addons): Invalid Bug description: If you try to update from version 5.0.0 to last version you have: [2009-08-30 17:40:09,770] WARNING:orm:column 'purchase_warn' in table 'res_partner' has changed type (DB = bool, def = selection) but unable to migrate this change ! [2009-08-30 17:40:09,774] WARNING:orm:column 'sale_warn' in table 'res_partner' has changed type (DB = bool, def = selection) but unable to migrate this change ! [2009-08-30 17:40:09,799] WARNING:orm:column 'invoice_warn' in table 'res_partner' has changed type (DB = bool, def = selection) but unable to migrate this change ! [2009-08-30 17:40:09,824] WARNING:orm:column 'picking_warn' in table 'res_partner' has changed type (DB = bool, def = selection) but unable to migrate this change ! [2009-08-30 17:40:10,380] WARNING:orm:column 'purchase_line_warn' in table 'product_product' has changed type (DB = bool, def = selection) but unable to migrate this change ! [2009-08-30 17:40:10,390] WARNING:orm:column 'sale_line_warn' in table 'product_product' has changed type (DB = bool, def = selection) but unable to migrate this change ! [2009-08-30 17:40:11,222] WARNING:orm:column 'purchase_warn' in table 'res_partner' has changed type (DB = bool, def = selection) but unable to migrate this change ! [2009-08-30 17:40:11,224] WARNING:orm:column 'sale_warn' in table 'res_partner' has changed type (DB = bool, def = selection) but unable to migrate this change ! [2009-08-30 17:40:11,234] WARNING:orm:column 'invoice_warn' in table 'res_partner' has changed type (DB = bool, def = selection) but unable to migrate this change ! [2009-08-30 17:40:11,246] WARNING:orm:column 'picking_warn' in table 'res_partner' has changed type (DB = bool, def = selection) but unable to migrate this change ! _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
