We have an Odoo18 instance in development. The instance has started returning an internal server error, and nothing we've tried has made any difference.

A partial traceback is;

  File "<1732>", line 34, in template_1732

  File "<1732>", line 23, in template_1732_content

  File "<1734>", line 1812, in template_1734

odoo.addons.base.models.ir_qweb.QWebException: Error while render the template

ValueError: File(s) /website/static/src/scss/options/colors/user_theme_color_palette.scss not found in bundle web._assets_primary_variables

Template: website.layout

Path: /t/html/head/t[11]

Node: <t t-call-assets="web.assets_frontend" t-js="false"/>

The file "/website/static/src/scss/options/colors/user_theme_color_palette.scss" exists and permissions are correct.

Thinking that it had to be some artefact hanging around form theme development, we've tried removing all traces of every theme with;

DELETE FROM ir_attachment

WHERE res_model = 'ir.ui.view'

AND (name ILIKE('%.assets_%.css') OR name ILIKE('%.assets_%.js'));

DELETE FROM ir_asset

WHERE PATH ILIKE('theme_%');

DELETE FROM ir_ui_view

WHERE arch_fs ILIKE('theme_%');

DELETE FROM theme_ir_asset

WHERE KEY LIKE('theme_%');

DELETE FROM theme_ir_ui_view

WHERE arch_fs ILIKE('theme_%');

DELETE FROM ir_model_data

WHERE "module" LIKE('theme_%')

OR "name" LIKE('module_theme_%');

We've tried updating every module to try to correct it using;

docker exec odoo18 /usr/bin/odoo --xmlrpc-port=8070 --stop-after-init -u all

Whilst, we could just trash the database given that it's in dev, we need to understand what has happened, as trashing the database will not be an option once in production. Understanding what has happened will help us prevent the same thing from happening again, and help us to resolve the issue should it happen in production.

It should be noted that the same codebase is running fine on a QA server.

What are the correct steps to take in this situation? Can we delete all views in the database and execute an update?