Hi,
I'm test openerp v5, just updated with bzr stable.
Invoicing works fine, but when I try to create a quotation, or view sales
orders:
> object sale.order doesn't exist
So checked thze sale module it was not completely installed, when I install it
again it gives the following error:
>
>
> Environment Information :
> System : Windows-XP-5.1.2600-SP3
> OS Name : nt
> Operating System Release : XP
> Operating System Version : 5.1.2600
> Operating System Architecture : 32bit
> Operating System Locale : fr_CH.cp1252
> Python Version : 2.5.2
> OpenERP-Client Version : 5.0.6
> Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call
> last):
> File "/opt/openerp.bzr/server/bin/netsvc.py", line 244, in dispatch
> result = LocalService(service_name)(method, *params)
> File "/opt/openerp.bzr/server/bin/netsvc.py", line 73, in __call__
> return getattr(self, method)(*params)
> File "/opt/openerp.bzr/server/bin/service/web_services.py", line 653, in
> execute
> return self._execute(db, uid, wiz_id, datas, action, context)
> File "/opt/openerp.bzr/server/bin/service/web_services.py", line 633, in
> _execute
> return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
> File "/opt/openerp.bzr/server/bin/wizard/__init__.py", line 177, in execute
> res = self.execute_cr(cr, uid, data, state, context)
> File "/opt/openerp.bzr/server/bin/wizard/__init__.py", line 73, in
> execute_cr
> action_res = action(self, cr, uid, data, context)
> File
> "/opt/openerp.bzr/server/bin/addons/base/module/wizard/wizard_module_upgrade.py",
> line 92, in _upgrade_module
> db, pool = pooler.restart_pool(cr.dbname, update_module=True)
> File "/opt/openerp.bzr/server/bin/pooler.py", line 62, in restart_pool
> return get_db_and_pool(db_name, force_demo, status,
> update_module=update_module)
> File "/opt/openerp.bzr/server/bin/pooler.py", line 40, in get_db_and_pool
> addons.load_modules(db, force_demo, status, update_module)
> File "/opt/openerp.bzr/server/bin/addons/__init__.py", line 740, in
> load_modules
> r = load_module_graph(cr, graph, status, report=report)
> File "/opt/openerp.bzr/server/bin/addons/__init__.py", line 642, in
> load_module_graph
> tools.convert_xml_import(cr, m, fp, idref, mode=mode, noupdate=True,
> **kwargs)
> File "/opt/openerp.bzr/server/bin/tools/convert.py", line 853, in
> convert_xml_import
> obj.parse(doc.getroot())
> File "/opt/openerp.bzr/server/bin/tools/convert.py", line 750, in parse
> self._tags[rec.tag](self.cr, rec, n)
> File "/opt/openerp.bzr/server/bin/tools/convert.py", line 722, 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 "/opt/openerp.bzr/server/bin/addons/base/ir/ir_model.py", line 504, in
> _update
> res_id = model_obj.create(cr, uid, values, context=context)
> File "/opt/openerp.bzr/server/bin/addons/sale/sale.py", line 346, in create
> return super(sale_order, self).create(cr, uid, vals, context=context)
> File "/opt/openerp.bzr/server/bin/osv/orm.py", line 2753, in create
> cr.execute('insert into "'+self._table+'" (id'+upd0+") values
> ("+str(id_new)+upd1+')', tuple(upd2))
> File "/opt/openerp.bzr/server/bin/sql_db.py", line 76, in wrapper
> return f(self, *args, **kwargs)
> File "/opt/openerp.bzr/server/bin/sql_db.py", line 125, in execute
> res = self._obj.execute(query, params)
> IntegrityError: insert or update on table "sale_order" violates foreign key
> constraint "sale_order_partner_id_fkey"
> DETAIL: Key (partner_id)=(3) is not present in table "res_partner".
The last line seems to indicate an issue with a specific partner.
Now, when I installed Openerp, it came with demo data, and I deleted all
partners except 3 or 4 (from the GUI).
So, I went into pgadmin and did "delete from sale_order;" which wiped two rows.
Then I tried to install the sale module again, but it gave the same error, and
the two lines reappeared in the sale_order table!
Any suggestions?
-------------------- m2f --------------------
--
http://www.openobject.com/forum/viewtopic.php?p=49421#49421
-------------------- m2f --------------------
_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman2/listinfo/tinyerp-users
