ADD CONSTRAINT "external_mapping_line_ref_template_uniq" error

Bug #1006788 reported by Sylvain Calador
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
OpenObject Extension
Confirmed
Undecided
Sébastien BEAU - http://www.akretion.com

Bug Description

Hi,

openobject-extension: bzr revno 328
openobject-server/6.1: bzr revno 4180

While installing base_external_referential, i get an SQL error:

2012-05-31 08:49:10,920 3161 ERROR increvable openerp.sql_db: Programming error: ERREUR: la colonne « referential_id » nommée dans la clé n'existe pas
, in query ALTER TABLE "external_mapping_line" ADD CONSTRAINT "external_mapping_line_ref_template_uniq" unique (referential_id, template_id)

After investigations, this error is raised because the type of the field "referential_id" on "external_mapping_line" object is "related" so a openobject sql_constraint can not be applied, because the column not exists in the table "external_mapping_line".

I have no fix to provide except ignore or drop this sql_constraint.

Thanks.

Sylvain

Revision history for this message
Alexis de Lattre (alexis-via) wrote :

I confirm the bug. Sebastien, could you decide how you want to fix it ?

Changed in openobject-extension:
status: New → Confirmed
assignee: nobody → Sébastien BEAU - http://www.akretion.com (sebastien.beau)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.