Internal Server Error

[UPIlobra07]

2025-01-02 19:47:35.212 UTC [162] ERROR:  relation "common_colortheme" does not exist at character 129
inventree-db      | 2025-01-02 19:47:35.212 UTC [162] STATEMENT:  SELECT "common_colortheme"."id", "common_colortheme"."name", "common_colortheme"."user", "common_colortheme"."user_obj_id" FROM "common_colortheme" WHERE "common_colortheme"."user_obj_id" = 3 LIMIT 21
inventree-server  | 2025-01-02T19:47:35.212590Z [error    ] request_failed                 [django_structlog.middlewares.request] code=500 ip=1xxx.xxx.xxx.xxx request=GET /part/ request_id=xxxxxxxxx-4a70-926d-xxxxxxxxxxuser_id=3
inventree-server  | Traceback (most recent call last):
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
inventree-server  |     return self.cursor.execute(sql, params)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 97, in execute
inventree-server  |     raise ex.with_traceback(None)
inventree-server  | psycopg.errors.UndefinedTable: relation "common_colortheme" does not exist
inventree-server  | LINE 1: ...e"."user", "common_colortheme"."user_obj_id" FROM "common_co...
inventree-server  |                                                              ^
inventree-server  | 
inventree-server  | The above exception was the direct cause of the following exception:
inventree-server  | 
inventree-server  | Traceback (most recent call last):
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/core/handlers/base.py", line 220, in _get_response
inventree-server  |     response = response.render()
inventree-server  |                ^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/response.py", line 114, in render
inventree-server  |     self.content = self.rendered_content
inventree-server  |                    ^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/response.py", line 92, in rendered_content
inventree-server  |     return template.render(context, self._request)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/backends/django.py", line 61, in render
inventree-server  |     return self.template.render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 175, in render
inventree-server  |     return self._render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render
inventree-server  |     return self.nodelist.render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render
inventree-server  |     return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server  |                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in <listcomp>
inventree-server  |     return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server  |                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated
inventree-server  |     return self.render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/loader_tags.py", line 157, in render
inventree-server  |     return compiled_parent._render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render
inventree-server  |     return self.nodelist.render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render
inventree-server  |     return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server  |                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in <listcomp>
inventree-server  |     return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server  |                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated
inventree-server  |     return self.render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/loader_tags.py", line 157, in render
inventree-server  |     return compiled_parent._render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render
inventree-server  |     return self.nodelist.render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render
inventree-server  |     return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server  |                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in <listcomp>
inventree-server  |     return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server  |                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated
inventree-server  |     return self.render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/loader_tags.py", line 157, in render
inventree-server  |     return compiled_parent._render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render
inventree-server  |     return self.nodelist.render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render
inventree-server  |     return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server  |                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in <listcomp>
inventree-server  |     return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server  |                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated
inventree-server  |     return self.render(context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/template/library.py", line 237, in render
inventree-server  |     output = self.func(*resolved_args, **resolved_kwargs)
inventree-server  |              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/home/inventree/src/backend/InvenTree/InvenTree/templatetags/inventree_extras.py", line 440, in get_color_theme_css
inventree-server  |     user_theme_name = get_user_color_theme(user)
inventree-server  |                       ^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/home/inventree/src/backend/InvenTree/InvenTree/templatetags/inventree_extras.py", line 462, in get_user_color_theme
inventree-server  |     user_theme = ColorTheme.objects.filter(user_obj=user).get()
inventree-server  |                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 633, in get
inventree-server  |     num = len(clone)
inventree-server  |           ^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 380, in __len__
inventree-server  |     self._fetch_all()
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 1881, in _fetch_all
inventree-server  |     self._result_cache = list(self._iterable_class(self))
inventree-server  |                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 91, in __iter__
inventree-server  |     results = compiler.execute_sql(
inventree-server  |               ^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
inventree-server  |     cursor.execute(sql, params)
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 67, in execute
inventree-server  |     return self._execute_with_wrappers(
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
inventree-server  |     return executor(sql, params, many, context)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 84, in _execute
inventree-server  |     with self.db.wrap_database_errors:
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/utils.py", line 91, in __exit__
inventree-server  |     raise dj_exc_value.with_traceback(traceback) from exc_value
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
inventree-server  |     return self.cursor.execute(sql, params)
inventree-server  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server  |   File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 97, in execute
inventree-server  |     raise ex.with_traceback(None)
inventree-server  | django.db.utils.ProgrammingError: relation "common_colortheme" does not exist
inventree-server  | LINE 1: ...e"."user", "common_colortheme"."user_obj_id" FROM "common_co...

this is a docker installation
i was having part tab not opening then i tried to install a previous version of docker container thinking its the reason of the problem
but after installed the previous version i got the above error message (its longer then this)
if i install a fresh inventree the problem doesn't appear
what could cause this error because i don't want to lose my company data

i dont have a backup file

[SchrodingersGat]

Did you run invoke update as part of the install process?

[UPIlobra07]

yes i did do that

[SchrodingersGat]

Please run invoke migrate and post the output here

[UPIlobra07]

output is here
'sudo docker compose up

WARN[0000] /home/inventree/docker-compose.yml: the attribute version is obsolete, it will be ignored, please remove it to avoid potential confusion
[+] Running 4/0
✔ Container inventree-db Running 0.0s
✔ Container inventree-server Created 0.0s
✔ Container inventree-proxy Created 0.0s
✔ Container inventree-worker Created 0.0s
Attaching to inventree-db, inventree-proxy, inventree-server, inventree-worker
inventree-server | Loading config file : /home/inventree/data/config.yaml
inventree-server | Python version 3.11.9 - /usr/local/bin/python
inventree-worker | Loading config file : /home/inventree/data/config.yaml
inventree-proxy | {"level":"info","ts":1735851980.3228467,"msg":"using config from file","file":"/etc/caddy/Caddyfile"}
inventree-proxy | {"level":"info","ts":1735851980.3238049,"msg":"adapted config to JSON","adapter":"caddyfile"}
inventree-proxy | {"level":"info","ts":1735851980.3243876,"logger":"admin","msg":"admin endpoint started","address":"localhost:2019","enforce_origin":false,"origins":["//localhost:2019","//[::1]:2019","//127.0.0.1:2019"]}
inventree-proxy | {"level":"warn","ts":1735851980.3245506,"logger":"http.auto_https","msg":"server is listening only on the HTTP port, so no automatic HTTPS will be applied to this server","server_name":"srv0","http_port":80}
inventree-proxy | {"level":"info","ts":1735851980.3245747,"logger":"tls.cache.maintenance","msg":"started background certificate maintenance","cache":"0xc000496180"}
inventree-proxy | {"level":"info","ts":1735851980.3250923,"logger":"http.log","msg":"server running","name":"srv0","protocols":["h1","h2","h3"]}
inventree-proxy | {"level":"info","ts":1735851980.3252492,"msg":"autosaved config (load with --resume flag)","file":"/config/caddy/autosave.json"}
inventree-proxy | {"level":"info","ts":1735851980.325254,"msg":"serving initial configuration"}
inventree-proxy | {"level":"info","ts":1735851980.3310418,"logger":"tls","msg":"storage cleaning happened too recently; skipping for now","storage":"FileStorage:/data/caddy","instance":"89046144-bed5-4f15-a952-475c091f8446","try_again":1735938380.331039,"try_again_in":86399.999999691}
inventree-proxy | {"level":"info","ts":1735851980.3310897,"logger":"tls","msg":"finished cleaning storage units"}
inventree-worker | Waiting for database connection...
inventree-worker | Python version 3.11.9 - /usr/local/bin/python3
inventree-worker | /root/.local/lib/python3.11/site-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
inventree-worker | warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
inventree-worker | Waiting for database...
inventree-server | /root/.local/lib/python3.11/site-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
inventree-server | warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
inventree-worker | Database connection successful!
inventree-worker | Python version 3.11.9 - /usr/local/bin/python3
inventree-worker | /root/.local/lib/python3.11/site-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
inventree-worker | warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
inventree-server | 2025-01-02T21:06:25.599197Z [warning ] request_finished [django_structlog.middlewares.request] code=401 ip=XXX.XXX.XXX.XXX request=GET /api/notifications/?read=false request_id=aXXX.XXX.XXX.XXX--XXX.XXX.XXX.XXX user_id=None
inventree-server | 2025-01-02 21:06:25,599 WARNING {'code': 401, 'request': 'GET /api/notifications/?read=false', 'event': 'request_finished', 'user_id': None, 'ip': 'XXX.XXX.XXX.XXX, 'request_id': 'aXXX.XXX.XXX.XXX', 'timestamp': '2025-01-02T21:06:25.599197Z', 'logger': 'django_structlog.middlewares.request', 'level': 'warning'}
inventree-server | 2025-01-02 21:06:25,603 WARNING Unauthorized: /api/notifications/
inventree-server | 1XXX.XXX.XXX.XXX- - [02/Jan/2025:21:06:25 +0000] "GET /api/notifications/?read=false HTTP/1.1" 401 58 "http://XXX.XXX.XXX.XXX/stock/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:133.0) Gecko/20100101 Firefox/133.0"
inventree-server | 1XXX.XXX.XXX.XXX - - [02/Jan/2025:21:06:27 +0000] "GET /part/ HTTP/1.1" 302 0 "http://1XXX.XXX.XXX.XXX/stock/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:133.0) Gecko/20100101 Firefox/133.0"
inventree-server | XXX.XXX.XXX.XXX - - [02/Jan/2025:21:06:27 +0000] "GET /accounts/login/?next=/part/ HTTP/1.1" 200 8575 "http://XXX.XXX.XXX.XXX/stock/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:133.0) Gecko/20100101 Firefox/133.0"
inventree-server | XXX.XXX.XXX.XXX - - [02/Jan/2025:21:06:30 +0000] "POST /accounts/login/ HTTP/1.1" 302 0 "http://1XXX.XXX.XXX.XXX/accounts/login/?next=/part/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:133.0) Gecko/20100101 Firefox/133.0"
inventree-server | XXX.XXX.XXX.XXX - - [02/Jan/2025:21:06:30 +0000] "GET /accounts/authenticate/?next=%2Fpart%2F HTTP/1.1" 200 7382 "http://XXX.XXX.XXX.XXX/accounts/login/?next=/part/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:133.0) Gecko/20100101 Firefox/133.0"
inventree-server | XXX.XXX.XXX.XXX- - [02/Jan/2025:21:06:49 +0000] "POST /accounts/authenticate/?next=%2Fpart%2F HTTP/1.1" 200 7544 "http://XXX.XXX.XXX.XXX/accounts/authenticate/?next=%2Fpart%2F" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:133.0) Gecko/20100101 Firefox/133.0"
inventree-server | XXX.XXX.XXX.XXX - - [02/Jan/2025:21:07:04 +0000] "POST /accounts/authenticate/?next=%2Fpart%2F HTTP/1.1" 302 0 "http://XXX.XXX.XXX.XXX/accounts/authenticate/?next=%2Fpart%2F" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:133.0) Gecko/20100101 Firefox/133.0"
inventree-db | 2025-01-02 21:07:04.575 UTC [235] ERROR: relation "common_colortheme" does not exist at character 129
inventree-db | 2025-01-02 21:07:04.575 UTC [235] STATEMENT: SELECT "common_colortheme"."id", "common_colortheme"."name", "common_colortheme"."user", "common_colortheme"."user_obj_id" FROM "common_colortheme" WHERE "common_colortheme"."user_obj_id" = 3 LIMIT 21
inventree-server | 2025-01-02T21:07:04.575322Z [error ] request_failed [django_structlog.middlewares.request] code=500 ip=XXX.XXX.XXX.XXX request=GET /part/ request_id=XXX.XXX.XXX.XXX448f-XXX.XXX.XXX.XXX user_id=3
inventree-server | Traceback (most recent call last):
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
inventree-server | return self.cursor.execute(sql, params)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 97, in execute
inventree-server | raise ex.with_traceback(None)
inventree-server | psycopg.errors.UndefinedTable: relation "common_colortheme" does not exist
inventree-server | LINE 1: ...e"."user", "common_colortheme"."user_obj_id" FROM "common_co...
inventree-server | ^
inventree-server |
inventree-server | The above exception was the direct cause of the following exception:
inventree-server |
inventree-server | Traceback (most recent call last):
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/core/handlers/base.py", line 220, in _get_response
inventree-server | response = response.render()
inventree-server | ^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/response.py", line 114, in render
inventree-server | self.content = self.rendered_content
inventree-server | ^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/response.py", line 92, in rendered_content
inventree-server | return template.render(context, self._request)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/backends/django.py", line 61, in render
inventree-server | return self.template.render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 175, in render
inventree-server | return self._render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render
inventree-server | return self.nodelist.render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render
inventree-server | return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in
inventree-server | return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated
inventree-server | return self.render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/loader_tags.py", line 157, in render
inventree-server | return compiled_parent._render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render
inventree-server | return self.nodelist.render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render
inventree-server | return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in
inventree-server | return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated
inventree-server | return self.render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/loader_tags.py", line 157, in render
inventree-server | return compiled_parent._render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render
inventree-server | return self.nodelist.render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render
inventree-server | return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in
inventree-server | return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated
inventree-server | return self.render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/loader_tags.py", line 157, in render
inventree-server | return compiled_parent._render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render
inventree-server | return self.nodelist.render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render
inventree-server | return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in
inventree-server | return SafeString("".join([node.render_annotated(context) for node in self]))
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated
inventree-server | return self.render(context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/template/library.py", line 237, in render
inventree-server | output = self.func(*resolved_args, **resolved_kwargs)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/home/inventree/src/backend/InvenTree/InvenTree/templatetags/inventree_extras.py", line 440, in get_color_theme_css
inventree-server | user_theme_name = get_user_color_theme(user)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/home/inventree/src/backend/InvenTree/InvenTree/templatetags/inventree_extras.py", line 462, in get_user_color_theme
inventree-server | user_theme = ColorTheme.objects.filter(user_obj=user).get()
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 633, in get
inventree-server | num = len(clone)
inventree-server | ^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 380, in len
inventree-server | self._fetch_all()
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 1881, in _fetch_all
inventree-server | self._result_cache = list(self._iterable_class(self))
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 91, in iter
inventree-server | results = compiler.execute_sql(
inventree-server | ^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
inventree-server | cursor.execute(sql, params)
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 67, in execute
inventree-server | return self._execute_with_wrappers(
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
inventree-server | return executor(sql, params, many, context)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 84, in _execute
inventree-server | with self.db.wrap_database_errors:
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/utils.py", line 91, in exit
inventree-server | raise dj_exc_value.with_traceback(traceback) from exc_value
inventree-server | File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
inventree-server | return self.cursor.execute(sql, params)
inventree-server | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
inventree-server | File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 97, in execute
inventree-server | raise ex.with_traceback(None)
inventree-server | django.db.utils.ProgrammingError: relation "common_colortheme" does not exist
inventree-server | LINE 1: ...e"."user", "common_colortheme"."user_obj_id" FROM "common_co...
inventree-server | ^
inventree-server | 2025-01-02 21:07:04,577 ERROR {'code': 500, 'request': 'GET /part/', 'event': 'request_failed', 'ip': 'XXX.XXX.XXX.XXX, 'user_id': 3, 'request_id': 'eXXX.XXX.XXX.XXXXXX.XXX.XXX.XXX', 'timestamp': '2025-01-02T21:07:04.575322Z', 'logger': 'django_structlog.middlewares.request', 'level': 'error', 'exception': 'Traceback (most recent call last):\n File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute\n return self.cursor.execute(sql, params)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 97, in execute\n raise ex.with_traceback(None)\npsycopg.errors.UndefinedTable: relation "common_colortheme" does not exist\nLINE 1: ...e"."user", "common_colortheme"."user_obj_id" FROM "common_co...\n ^\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n File "/root/.local/lib/python3.11/site-packages/django/core/handlers/base.py", line 220, in _get_response\n response = response.render()\n ^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/response.py", line 114, in render\n self.content = self.rendered_content\n ^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/response.py", line 92, in rendered_content\n return template.render(context, self._request)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/backends/django.py", line 61, in render\n return self.template.render(context)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 175, in render\n return self._render(context)\n ^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render\n return self.nodelist.render(context)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render\n return SafeString("".join([node.render_annotated(context) for node in self]))\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in \n return SafeString("".join([node.render_annotated(context) for node in self]))\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated\n return self.render(context)\n ^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/loader_tags.py", line 157, in render\n return compiled_parent._render(context)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render\n return self.nodelist.render(context)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render\n return SafeString("".join([node.render_annotated(context) for node in self]))\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in \n return SafeString("".join([node.render_annotated(context) for node in self]))\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated\n return self.render(context)\n ^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/loader_tags.py", line 157, in render\n return compiled_parent._render(context)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render\n return self.nodelist.render(context)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render\n return SafeString("".join([node.render_annotated(context) for node in self]))\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in \n return SafeString("".join([node.render_annotated(context) for node in self]))\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated\n return self.render(context)\n ^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/loader_tags.py", line 157, in render\n return compiled_parent._render(context)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 167, in _render\n return self.nodelist.render(context)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in render\n return SafeString("".join([node.render_annotated(context) for node in self]))\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 1005, in \n return SafeString("".join([node.render_annotated(context) for node in self]))\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/base.py", line 966, in render_annotated\n return self.render(context)\n ^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/template/library.py", line 237, in render\n output = self.func(*resolved_args, **resolved_kwargs)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/home/inventree/src/backend/InvenTree/InvenTree/templatetags/inventree_extras.py", line 440, in get_color_theme_css\n user_theme_name = get_user_color_theme(user)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/home/inventree/src/backend/InvenTree/InvenTree/templatetags/inventree_extras.py", line 462, in get_user_color_theme\n user_theme = ColorTheme.objects.filter(user_obj=user).get()\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 633, in get\n num = len(clone)\n ^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 380, in len\n self._fetch_all()\n File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 1881, in _fetch_all\n self._result_cache = list(self._iterable_class(self))\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/db/models/query.py", line 91, in iter\n results = compiler.execute_sql(\n ^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql\n cursor.execute(sql, params)\n File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 67, in execute\n return self._execute_with_wrappers(\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers\n return executor(sql, params, many, context)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 84, in _execute\n with self.db.wrap_database_errors:\n File "/root/.local/lib/python3.11/site-packages/django/db/utils.py", line 91, in exit\n raise dj_exc_value.with_traceback(traceback) from exc_value\n File "/root/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute\n return self.cursor.execute(sql, params)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/root/.local/lib/python3.11/site-packages/psycopg/cursor.py", line 97, in execute\n raise ex.with_traceback(None)\ndjango.db.utils.ProgrammingError: relation "common_colortheme" does not exist\nLINE 1: ...e"."user", "common_colortheme"."user_obj_id" FROM "common_co...\n ^'}
inventree-db | 2025-01-02 21:07:05.115 UTC [235] ERROR: relation "common_colortheme" does not exist at character 129
inventree-db | 2025-01-02 21:07:05.115 UTC [235] STATEMENT: SELECT "common_colortheme"."id", "common_colortheme"."name", "common_colortheme"."user", "common_colortheme"."user_obj_id" FROM "common_colortheme" WHERE "common_colortheme"."user_obj_id" = 3 LIMIT 21
'

i have a fresh inventree installation when i remove and paste the pgdb file from previous installation to it the problem start to happen

[UPIlobra07]

here is the invoke migrate output

`sudo docker compose run --rm inventree-server invoke migrate

[sudo] password for upiinc:
WARN[0000] /home/upiinc/inventree/docker-compose.yml: the attribute version is obsolete, it will be ignored, please remove it to avoid potential confusion
[+] Creating 1/0
✔ Container inventree-db Created 0.0s
[+] Running 1/1
✔ Container inventree-db Started 0.3s
Loading config file : /home/inventree/data/config.yaml
Running InvenTree database migrations...
Python version 3.11.9 - /usr/local/bin/python3
/root/.local/lib/python3.11/site-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
No changes detected
Python version 3.11.9 - /usr/local/bin/python3
/root/.local/lib/python3.11/site-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
Python version 3.11.9 - /usr/local/bin/python3
/root/.local/lib/python3.11/site-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
Operations to perform:
Synchronize unmigrated apps: allauth, allauth_2fa, corsheaders, crispy_forms, dbbackup, dj_rest_auth, django_cleanup, django_filters, django_ical, django_otp, django_structlog, djmoney, drf_spectacular, formtools, generic, import_export, maintenance_mode, markdownify, messages, mptt, registration, rest_framework, runserver_nostatic, staticfiles, web
Apply all migrations: InvenTree, account, admin, auth, build, common, company, contenttypes, django_q, error_report, exchange, flags, importer, machine, order, otp_static, otp_totp, part, plugin, report, socialaccount, stock, taggit, user_sessions, users
Synchronizing apps without migrations:
Creating tables...
Running deferred SQL...
Running migrations:
No migrations to apply.
Python version 3.11.9 - /usr/local/bin/python3
/root/.local/lib/python3.11/site-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
InvenTree database migrations completed
Rebuilding internal database structures
Python version 3.11.9 - /usr/local/bin/python3
/root/.local/lib/python3.11/site-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
Failed to set maintenance mode state
2025-01-02 21:06:11,950 WARNING Failed to set maintenance mode state
Rebuilding image thumbnails
Python version 3.11.9 - /usr/local/bin/python3
/root/.local/lib/python3.11/site-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
`

[matmair]

@SchrodingersGat I am pretty sure this is because the color theme table was removed by the current master branch

[lobra07]

, is there anyway to fix it or having a batch fix for it

[SchrodingersGat]

@UPIlobra07 what version of InvenTree are you running exactly? Can you share the output of invoke version

[UPIlobra07]

@SchrodingersGat yes when i started to see the problems with the UI i switched to master to try to find a solution then i switch back to the stable version still the problem

[SchrodingersGat]

We have just released 0.17.2 which should address this problem for you. However, it is not recommended to switch between master and stable in this way - there may be other unexpected problems that you encounter

[GilDev]

Thanks @SchrodingersGat, that indeed fixed the old UI! But now it’s the new /platform UI that shows a blank page… Maybe I have missed something, it’s an issue I had when initially setting up InvenTree with a Cloudflare Tunnel, but it was working until this new update.

[SchrodingersGat]

Any error messages in your browser console?

[GilDev]

Well it’s working now… Nothing has changed which is a bit weird.