On Sunday 15 May 2011, you wrote: > I have this error too on V6.0.2, I would really like to find a way to > see the exact lines in the database that are not ok.
... DETAIL: Key (name)=(2) is not present in table "res_partner". The 'DETAIL' line will only give you the values, not the id's of the offending lines. Reason is, Postgres tables are not always supposed to have 'id' or anything standardized as their primary key. So, the server can only report the values, not guess and report the primary key(s). setting "res.partner.name = '2' " ? May I ask why you are trying to do that? -- Say NO to spam and viruses. Stop using Microsoft Windows! -- 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/656264 Title: IntegrityError: insert or update on table "product_supplierinfo" violates foreign key constraint "product_supplierinfo_name_fkey" DETAIL: Key (name)=(2) is not present in table "res_partner". Status in OpenERP Server: Invalid Bug description: From minimal profile + crm modules trying to install product modules I obtain this error Environment Information : System : Linux-2.6.35-22-generic-x86_64-with-Ubuntu-10.10-maverick OS Name : posix Distributor ID: Ubuntu Description: Ubuntu maverick (development branch) Release: 10.10 Codename: maverick Operating System Release : 2.6.35-22-generic Operating System Version : #33-Ubuntu SMP Sun Sep 19 20:32:27 UTC 2010 Operating System Architecture : 64bit Operating System Locale : it_IT.UTF8 Python Version : 2.6.6 OpenERP-Client Version : 5.0.14 Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last): File "/usr/share/pyshared/openerp-server/netsvc.py", line 256, in dispatch result = LocalService(service_name)(method, *params) File "/usr/share/pyshared/openerp-server/netsvc.py", line 76, in __call__ return getattr(self, method)(*params) File "/usr/share/pyshared/openerp-server/service/web_services.py", line 638, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/usr/share/pyshared/openerp-server/service/web_services.py", line 618, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/usr/share/pyshared/openerp-server/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/usr/share/pyshared/openerp-server/wizard/__init__.py", line 73, in execute_cr action_res = action(self, cr, uid, data, context) File "/usr/share/pyshared/openerp-server/addons/base/module/wizard/wizard_module_upgrade.py", line 92, in _upgrade_module db, pool = pooler.restart_pool(cr.dbname, update_module=True) File "/usr/share/pyshared/openerp-server/pooler.py", line 62, in restart_pool return get_db_and_pool(db_name, force_demo, status, update_module=update_module) File "/usr/share/pyshared/openerp-server/pooler.py", line 40, in get_db_and_pool addons.load_modules(db, force_demo, status, update_module) File "/usr/share/pyshared/openerp-server/addons/__init__.py", line 736, in load_modules r = load_module_graph(cr, graph, status, report=report) File "/usr/share/pyshared/openerp-server/addons/__init__.py", line 637, in load_module_graph tools.convert_xml_import(cr, m, fp, idref, mode=mode, noupdate=True, **kwargs) File "/usr/share/pyshared/openerp-server/tools/convert.py", line 877, in convert_xml_import obj.parse(doc.getroot()) File "/usr/share/pyshared/openerp-server/tools/convert.py", line 774, in parse self._tags[rec.tag](self.cr, rec, n) File "/usr/share/pyshared/openerp-server/tools/convert.py", line 746, in _tag_record id = self.pool.get('ir.model.data')._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode ) File "/usr/share/pyshared/openerp-server/addons/base/ir/ir_model.py", line 515, in _update res_id = model_obj.create(cr, uid, values, context=context) File "/usr/share/pyshared/openerp-server/osv/orm.py", line 2869, in create cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2)) File "/usr/share/pyshared/openerp-server/sql_db.py", line 78, in wrapper return f(self, *args, **kwargs) File "/usr/share/pyshared/openerp-server/sql_db.py", line 123, in execute res = self._obj.execute(query, params) IntegrityError: insert or update on table "product_supplierinfo" violates foreign key constraint "product_supplierinfo_name_fkey" DETAIL: Key (name)=(2) is not present in table "res_partner". _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
