I tried to install Delivery costs and got the error: product_catergory_all missing. After long searching I found a tip to add an external point which removed this message, but led into another problem. Be fore ruining my installatation I prefer to ask for help here now. I'd gladly pay someone to fix my issues if someone is intrested to do so.
Michael
Error Message
Error:
Odoo Server Error
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 744, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 654, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_model.py", line 1476, in _update
record = record.create(values)
File "/usr/lib/python3/dist-packages/odoo/addons/product/models/product.py", line 305, in create
product = super(ProductProduct, self.with_context(create_product_product=True)).create(vals)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 236, in create
thread = super(MailThread, self).create(values)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3373, in create
record = self.browse(self._create(old_vals))
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3430, in _create
parent_id = self.env[parent_model].create(parent_vals).id
File "/usr/lib/python3/dist-packages/odoo/addons/product/models/product_template.py", line 295, in create
template = super(ProductTemplate, self).create(vals)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 236, in create
thread = super(MailThread, self).create(values)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3373, in create
record = self.browse(self._create(old_vals))
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3466, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
psycopg2.IntegrityError: insert or update on table "product_template" violates foreign key constraint "product_template_categ_id_fkey"
DETAIL: Key (categ_id)=(1) is not present in table "product_category".
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 650, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 310, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise
raise value
File "/usr/lib/python3/dist-packages/odoo/http.py", line 692, in dispatch
result = self._call_function(**self.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 342, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 335, in checked_call
result = self.endpoint(*a, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 936, in __call__
return self.method(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 515, in response_wrap
response = f(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 935, in call_button
action = self._call_kw(model, method, args, {})
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 923, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 689, in call_kw
return call_kw_multi(method, model, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 680, in call_kw_multi
result = method(recs, *args, **kwargs)
File "<decorator-gen-56>", line 2, in button_immediate_install
File "/usr/lib/python3/dist-packages/odoo/addons/base/module/module.py", line 71, in check_and_log
return method(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/base/module/module.py", line 448, in button_immediate_install
return self._button_immediate_function(type(self).button_install)
File "/usr/lib/python3/dist-packages/odoo/addons/base/module/module.py", line 541, in _button_immediate_function
modules.registry.Registry.new(self._cr.dbname, update_module=True)
File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 85, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 380, in load_modules
loaded_modules, update_module, models_to_check)
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 274, in load_marked_modules
perform_checks=perform_checks, models_to_check=models_to_check
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 181, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 95, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 791, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 852, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 741, in parse
self.parse(rec, mode)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 751, in parse
exc_info[2]
File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 86, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 744, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 654, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_model.py", line 1476, in _update
record = record.create(values)
File "/usr/lib/python3/dist-packages/odoo/addons/product/models/product.py", line 305, in create
product = super(ProductProduct, self.with_context(create_product_product=True)).create(vals)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 236, in create
thread = super(MailThread, self).create(values)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3373, in create
record = self.browse(self._create(old_vals))
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3430, in _create
parent_id = self.env[parent_model].create(parent_vals).id
File "/usr/lib/python3/dist-packages/odoo/addons/product/models/product_template.py", line 295, in create
template = super(ProductTemplate, self).create(vals)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 236, in create
thread = super(MailThread, self).create(values)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3373, in create
record = self.browse(self._create(old_vals))
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3466, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "insert or update on table "product_template" violates foreign key constraint "product_template_categ_id_fkey"
DETAIL: Key (categ_id)=(1) is not present in table "product_category".
" while parsing /usr/lib/python3/dist-packages/odoo/addons/delivery/data/delivery_data.xml:4, near
<record id="product_product_delivery" model="product.product">
<field name="name">Free delivery charges</field>
<field name="default_code">Delivery</field>
<field name="type">service</field>
<field name="categ_id" ref="product.product_category_all"/>
<field name="sale_ok" eval="False"/>
<field name="purchase_ok" eval="False"/>
<field name="list_price">0.0</field>
</record>
