Error while getting templates list: Database error detected, please cgeck logs to find details

[itsamemarkus]

I think I was on Version 3.0.0 RC1 and upgraded to 3.0.1 official release. After that I couldn't load any templates. There wasn't anything super important on that intstance so I'll just set up a new one. Just wanted to document the error I got here in case it affects others.

2025-01-02 21:35:07 ERROR server.py:199 Controller database error in /v3/templates (GET): (sqlite3.OperationalError) no such column: docker_templates.mac_address
[SQL: SELECT docker_templates.template_id AS docker_templates_template_id, templates.template_id AS templates_template_id, templates.template_type AS templates_template_type, docker_templates.image AS docker_templates_image, docker_templates.adapters AS docker_templates_adapters, docker_templates.mac_address AS docker_templates_mac_address, docker_templates.start_command AS docker_templates_start_command, docker_templates.environment AS docker_templates_environment, docker_templates.console_type AS docker_templates_console_type, docker_templates.aux_type AS docker_templates_aux_type, docker_templates.console_auto_start AS docker_templates_console_auto_start, docker_templates.console_http_port AS docker_templates_console_http_port, docker_templates.console_http_path AS docker_templates_console_http_path, docker_templates.console_resolution AS docker_templates_console_resolution, docker_templates.extra_hosts AS docker_templates_extra_hosts, docker_templates.extra_volumes AS docker_templates_extra_volumes, docker_templates.memory AS docker_templates_memory, docker_templates.cpus AS docker_templates_cpus, docker_templates.custom_adapters AS docker_templates_custom_adapters
FROM templates JOIN docker_templates ON templates.template_id = docker_templates.template_id
WHERE templates.template_id IN (?, ?, ?, ?) ORDER BY templates.template_id]
[parameters: ('e434b65c0c674345a2fdbb2f94debdb2', '2d1d25b927274783be7ad8ec0c43659d', 'e7a9cf69f78540b7806ccf72474d8b3a', '7b6448263e354e65bd69f6a755d46f72')]
(Background on this error at: https://sqlalche.me/e/20/e3q8)