magentoerpconnect/openerp6.1-legacy-module: foreign key error when importing product links

Bug #1028812 reported by Alexandre Fayolle - camptocamp on 2012-07-25
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Magento OpenERP Connector
Fix Committed
Alexandre Fayolle - camptocamp

Bug Description

2012-07-24 12:05:40,256 24557 INFO ? openerp.addons.base_external_referentials.external_osv: Created in OpenERP product.product from External Ref with external_id 9267 and OpenERP id 6730 successfully
2012-07-24 12:05:40,260 24557 ERROR ? openerp.sql_db: bad query: insert into "product_link" (id,"linked_product_id","type","product_id","sequence",create_uid,create_date) values (5379,6730,E'cross_sell',6697,0,1,(now() at time zone 'UTC'))
Traceback (most recent call last):
File "/srv/openerp/instances/openerp_test_alpesdeveloppement/src/server/openerp/", line 212, in execute
res = self._obj.execute(query, params)
IntegrityError: insert or update on table "product_link" violates foreign key constraint "product_link_linked_product_id_fkey"
DETAIL: Key (linked_product_id)=(6730) is not present in table "product_product".

2012-07-24 12:05:40,266 24557 ERROR openerp_test_alpesdeveloppement openerp.netsvc: Erreur d'intégrité
L'opération n'a pas pu être terminée, probablement à la suite d'une :
- suppression : vous avez essayer de supprimer un enregistrement auquel d'autres enregistrements font référence
- création/modification : un champ requis n'a pas été correctement rempli

The error message (in french) is about a problem of FK. note that the product is reported as created on 1st line of the log.

Related branches

Changed in magentoerpconnect:
assignee: nobody → Alexandre Fayolle @ camptocamp (alexandre-fayolle-c2c)
Changed in magentoerpconnect:
status: New → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers