Skip to Content
Menu
This question has been flagged
1 Reply
2557 Views

I am testing with ODOO community editions. I installed CRM, SALES, EVENTS, INVOICING, DISCUSS, EMPLOYEE apps and insert few datas in all module. Now, i tried installing PROJECT app but got following error. Please advise.

Odoo Server Error
Traceback (most recent call last):
  File "D:\ODOO\Odoo 10.0\server\odoo\http.py", line 640, in _handle_exception
  File "D:\ODOO\Odoo 10.0\server\odoo\http.py", line 677, in dispatch
  File "D:\ODOO\Odoo 10.0\server\odoo\http.py", line 333, in _call_function
  File "D:\ODOO\Odoo 10.0\server\odoo\service\model.py", line 101, in wrapper
  File "D:\ODOO\Odoo 10.0\server\odoo\http.py", line 326, in checked_call
  File "D:\ODOO\Odoo 10.0\server\odoo\http.py", line 935, in __call__
  File "D:\ODOO\Odoo 10.0\server\odoo\http.py", line 506, in response_wrap
  File "D:\ODOO\Odoo 10.0\server\odoo\addons\web\controllers\main.py", line 889, in call_button
  File "D:\ODOO\Odoo 10.0\server\odoo\addons\web\controllers\main.py", line 877, in _call_kw
  File "D:\ODOO\Odoo 10.0\server\odoo\api.py", line 681, in call_kw
  File "D:\ODOO\Odoo 10.0\server\odoo\api.py", line 672, in call_kw_multi
  File "D:\ODOO\Odoo 10.0\server\odoo\addons\base\module\module.py", line 410, in button_immediate_install
  File "D:\ODOO\Odoo 10.0\server\odoo\addons\base\module\module.py", line 484, in _button_immediate_function
  File "D:\ODOO\Odoo 10.0\server\odoo\modules\registry.py", line 82, in new
  File "D:\ODOO\Odoo 10.0\server\odoo\modules\loading.py", line 339, in load_modules
  File "D:\ODOO\Odoo 10.0\server\odoo\modules\loading.py", line 237, in load_marked_modules
  File "D:\ODOO\Odoo 10.0\server\odoo\modules\loading.py", line 156, in load_module_graph
  File "D:\ODOO\Odoo 10.0\server\odoo\modules\loading.py", line 95, in _load_data
  File "D:\ODOO\Odoo 10.0\server\odoo\tools\convert.py", line 845, in convert_file
  File "D:\ODOO\Odoo 10.0\server\odoo\tools\convert.py", line 915, in convert_xml_import
  File "D:\ODOO\Odoo 10.0\server\odoo\tools\convert.py", line 796, in parse
  File "D:\ODOO\Odoo 10.0\server\odoo\tools\convert.py", line 799, in parse
  File "D:\ODOO\Odoo 10.0\server\odoo\tools\convert.py", line 707, in _tag_record
  File "D:\ODOO\Odoo 10.0\server\odoo\addons\base\ir\ir_model.py", line 1189, in _update
  File "D:\ODOO\Odoo 10.0\server\odoo\addons\account\models\company.py", line 107, in write
  File "D:\ODOO\Odoo 10.0\server\odoo\addons\product\models\res_company.py", line 55, in write
  File "D:\ODOO\Odoo 10.0\server\odoo\addons\base\res\res_company.py", line 350, in write
  File "D:\ODOO\Odoo 10.0\server\odoo\models.py", line 3564, in write
  File "D:\ODOO\Odoo 10.0\server\odoo\models.py", line 3650, in _write
  File "D:\ODOO\Odoo 10.0\server\odoo\sql_db.py", line 154, in wrapper
  File "D:\ODOO\Odoo 10.0\server\odoo\sql_db.py", line 231, in execute
ParseError: "insert or update on table "res_company" violates foreign key constraint "res_company_project_time_mode_id_fkey"
DETAIL:  Key (project_time_mode_id)=(5) is not present in table "product_uom".
" while parsing file:///d:/odoo/odoo 10.0/server/odoo/addons/project/data/project_data.xml:6, near
<record id="base.main_company" model="res.company">
            <field name="project_time_mode_id" ref="product.product_uom_hour"/>
        </record>
Avatar
Discard
Best Answer

Please run this PSQL query and delete the record. then its work fine.

DELETE FROM res_company WHERE  project_time_mode_id = 5;

or you just try with new database.


Avatar
Discard
Related Posts Replies Views Activity
3
Jun 24
1328
3
Jul 23
24340
2
Jun 22
4591
2
Sep 21
3480
1
Nov 20
6784