c2c-oerpscenario team mailing list archive

[Hayssam <hayssam.hoballah@xxxxxxxxx>]

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 !