I started updating the CRM module and since the application is inaccessible. How to correct this problem? In the logs, I find the following error:
2018-08-28 13:26:52,623 968 INFO odoo-db odoo.modules.registry: module website_crm: creating or updating database tables
2018-08-28 13:26:52,860 968 INFO odoo-db odoo.modules.loading: loading website_crm/data/website_crm_data.xml
2018-08-28 13:26:52,940 968 INFO odoo-db odoo.sql_db: bad query: INSERT INTO "crm_team" ("id", "alias_id", "use_quotations", "company_id", "use_invoices", "use_leads", "active", "use_opportunities", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('crm_team_id_seq'), 13, true, 1, false, true, true, false, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id
2018-08-28 13:26:52,941 968 ERROR odoo-db odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/odoo/odoo-server/odoo/modules/registry.py", line 82, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/odoo/odoo-server/odoo/modules/loading.py", line 335, in load_modules
force, status, report, loaded_modules, update_module)
File "/odoo/odoo-server/odoo/modules/loading.py", line 237, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/odoo/odoo-server/odoo/modules/loading.py", line 156, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/odoo/odoo-server/odoo/modules/loading.py", line 95, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/odoo/odoo-server/odoo/tools/convert.py", line 845, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/odoo/odoo-server/odoo/tools/convert.py", line 915, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/odoo/odoo-server/odoo/tools/convert.py", line 796, in parse
self.parse(rec, mode)
File "/odoo/odoo-server/odoo/tools/convert.py", line 799, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/odoo/odoo-server/odoo/tools/convert.py", line 707, 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 "/odoo/odoo-server/odoo/addons/base/ir/ir_model.py", line 1229, in _update
record = record.create(values)
File "/odoo/odoo-server/addons/crm/models/crm_team.py", line 40, in create
return super(Team, self).create(vals)
File "/odoo/odoo-server/addons/mail/models/mail_alias.py", line 223, in create
)).create(vals)
File "/odoo/odoo-server/addons/sales_team/models/crm_team.py", line 45, in create
return super(CrmTeam, self.with_context(mail_create_nosubscribe=True)).create(values)
File "/odoo/odoo-server/addons/mail/models/mail_thread.py", line 228, in create
thread = super(MailThread, self).create(values)
File "/odoo/odoo-server/odoo/models.py", line 3826, in create
record = self.browse(self._create(old_vals))
File "/odoo/odoo-server/odoo/models.py", line 3921, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/odoo/odoo-server/odoo/sql_db.py", line 154, in wrapper
return f(self, *args, **kwargs)
File "/odoo/odoo-server/odoo/sql_db.py", line 231, in execute
res = self._obj.execute(query, params)
ParseError: "null value in column "name" violates not-null constraint
DETAIL: Failing row contains (4, 2018-08-28 13:26:52.805678, null, 1, 1, null, null, 1, 2018-08-28 13:26:52.805678, t, null, null, t, null, f, 13, t, f, null).
" while parsing /odoo/odoo-server/addons/website_crm/data/website_crm_data.xml:33, near
<record model="crm.team" id="sales_team.salesteam_website_sales">
<field name="use_leads">True</field>
<field name="use_opportunities" eval="False"/>
</record>
2018-08-28 13:26:52,946 968 INFO odoo-db werkzeug: 80.12.33.22 - - [28/Aug/2018 13:26:52] "POST /web/dataset/call_kw/ir.module.module/search_read HTTP/1.1" 500 -
2018-08-28 13:26:53,140 968 ERROR odoo-db werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 180, in run_wsgi
execute(self.server.app)
File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 168, in execute
application_iter = app(environ, start_response)
File "/odoo/odoo-server/odoo/service/server.py", line 249, in app
return self.app(e, s)
File "/odoo/odoo-server/odoo/service/wsgi_server.py", line 186, in application
return application_unproxied(environ, start_response)
File "/odoo/odoo-server/odoo/service/wsgi_server.py", line 172, in application_unproxied
result = handler(environ, start_response)
File "/odoo/odoo-server/odoo/http.py", line 1308, in __call__
return self.dispatch(environ, start_response)
File "/odoo/odoo-server/odoo/http.py", line 1282, in __call__
return self.app(environ, start_wrapped)
File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 591, in __call__
return self.app(environ, start_response)
File "/odoo/odoo-server/odoo/http.py", line 1464, in dispatch
odoo.registry(db).check_signaling()
File "/odoo/odoo-server/odoo/__init__.py", line 52, in registry
return modules.registry.Registry(database_name)
File "/odoo/odoo-server/odoo/modules/registry.py", line 59, in __new__
return cls.new(db_name)
File "/odoo/odoo-server/odoo/modules/registry.py", line 82, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/odoo/odoo-server/odoo/modules/loading.py", line 335, in load_modules
force, status, report, loaded_modules, update_module)
File "/odoo/odoo-server/odoo/modules/loading.py", line 237, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/odoo/odoo-server/odoo/modules/loading.py", line 156, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/odoo/odoo-server/odoo/modules/loading.py", line 95, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/odoo/odoo-server/odoo/tools/convert.py", line 845, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/odoo/odoo-server/odoo/tools/convert.py", line 915, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/odoo/odoo-server/odoo/tools/convert.py", line 796, in parse
self.parse(rec, mode)
File "/odoo/odoo-server/odoo/tools/convert.py", line 799, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/odoo/odoo-server/odoo/tools/convert.py", line 707, 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 "/odoo/odoo-server/odoo/addons/base/ir/ir_model.py", line 1229, in _update
record = record.create(values)
File "/odoo/odoo-server/addons/crm/models/crm_team.py", line 40, in create
return super(Team, self).create(vals)
File "/odoo/odoo-server/addons/mail/models/mail_alias.py", line 223, in create
)).create(vals)
File "/odoo/odoo-server/addons/sales_team/models/crm_team.py", line 45, in create
return super(CrmTeam, self.with_context(mail_create_nosubscribe=True)).create(values)
File "/odoo/odoo-server/addons/mail/models/mail_thread.py", line 228, in create
thread = super(MailThread, self).create(values)
File "/odoo/odoo-server/odoo/models.py", line 3826, in create
record = self.browse(self._create(old_vals))
File "/odoo/odoo-server/odoo/models.py", line 3921, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/odoo/odoo-server/odoo/sql_db.py", line 154, in wrapper
return f(self, *args, **kwargs)
File "/odoo/odoo-server/odoo/sql_db.py", line 231, in execute
res = self._obj.execute(query, params)
ParseError: "null value in column "name" violates not-null constraint
DETAIL: Failing row contains (4, 2018-08-28 13:26:52.805678, null, 1, 1, null, null, 1, 2018-08-28 13:26:52.805678, t, null, null, t, null, f, 13, t, f, null).
" while parsing /odoo/odoo-server/addons/website_crm/data/website_crm_data.xml:33, near
<record model="crm.team" id="sales_team.salesteam_website_sales">
<field name="use_leads">True</field>
<field name="use_opportunities" eval="False"/>
</record>
