Forgot to set my attachment as patch, can somebody fix this?
--
You received this bug notification because you are a member of
OpenUpgrade Committers, which is subscribed to OpenUpgrade Addons.
https://bugs.launchpad.net/bugs/1355054
Title:
Migration script for stock_location
Status in OpenUpgrade Addons:
New
Bug description:
Find attached a migration script for stock_location based on stock's
migration scripts. The only difference found in the analysis is the
change from address_id (res.partner.address) to partner_id which is
reflected in these migration scripts.
For reference, here is the error the migration attempt will throw
without this patch:
2014-08-11 08:14:14,077 2836 ERROR xxxxx openerp.sql_db: bad query: ALTER
TABLE "product_pulled_flow" ADD FOREIGN KEY ("partner_address_id") REFERENCES
"res_partner" ON DELETE set null
Traceback (most recent call last):
File "/opt/openerp/openupgrade-server/openerp/sql_db.py", line 226, in
execute
res = self._obj.execute(query, params)
IntegrityError: insert or update on table "product_pulled_flow" violates
foreign key constraint "product_pulled_flow_partner_address_id_fkey"
DETAIL: Key (partner_address_id)=(78) is not present in table "res_partner".
2014-08-11 08:14:14,077 2836 ERROR xxxxx openerp: Failed to initialize
database `xxxxx`.
Traceback (most recent call last):
File "/opt/openerp/openupgrade-server/openerp/cli/server.py", line 98, in
preload_registry
db, registry =
openerp.pooler.get_db_and_pool(dbname,update_module=update_module)
File "/opt/openerp/openupgrade-server/openerp/pooler.py", line 33, in
get_db_and_pool
registry = RegistryManager.get(db_name, force_demo, status, update_module)
File "/opt/openerp/openupgrade-server/openerp/modules/registry.py", line
192, in get
update_module)
File "/opt/openerp/openupgrade-server/openerp/modules/registry.py", line
218, in new
openerp.modules.load_modules(registry.db, force_demo, status,
update_module)
File "/opt/openerp/openupgrade-server/openerp/modules/loading.py", line
378, in load_modules
processed_upgrade = load_marked_modules(cr, graph, states_to_load, force,
status, report, loaded_modules, update_module, registry)
File "/opt/openerp/openupgrade-server/openerp/modules/loading.py", line
285, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict,
report=report, skip_modules=loaded_modules, perform_checks=perform_checks,
registry=registry)
File "/opt/openerp/openupgrade-server/openerp/modules/loading.py", line
186, in load_module_graph
init_module_models(cr, package.name, models)
File "/opt/openerp/openupgrade-server/openerp/modules/module.py", line 381,
in init_module_models
obj._auto_end(cr, {'module': module_name})
File "/opt/openerp/openupgrade-server/openerp/osv/orm.py", line 3243, in
_auto_end
cr.execute('ALTER TABLE "%s" ADD FOREIGN KEY ("%s") REFERENCES "%s" ON
DELETE %s' % (t, k, r, d))
File "/opt/openerp/openupgrade-server/openerp/sql_db.py", line 161, in
wrapper
return f(self, *args, **kwargs)
File "/opt/openerp/openupgrade-server/openerp/sql_db.py", line 226, in
execute
res = self._obj.execute(query, params)
IntegrityError: insert or update on table "product_pulled_flow" violates
foreign key constraint "product_pulled_flow_partner_address_id_fkey"
DETAIL: Key (partner_address_id)=(78) is not present in table "res_partner".
To manage notifications about this bug go to:
https://bugs.launchpad.net/openupgrade-addons/+bug/1355054/+subscriptions
--
Mailing list: https://launchpad.net/~credativ
Post to : [email protected]
Unsubscribe : https://launchpad.net/~credativ
More help : https://help.launchpad.net/ListHelp
