Error on database restore after the 0.15.3 update

[rohitsingal1]

Receiving the following error. I am unable to access my parts and stock data from the front end. The page returns blank results. I feel the database has not migrated to the correct version.

sudo inventree run invoke restore

Restoring InvenTree database
Python version 3.10.12 - /opt/inventree/env/bin/python3
/opt/inventree/env/lib/python3.10/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")
Finding latest backup
Restoring backup for database 'default' and server 'None'
Restoring: default-server-2024-05-26-000035.dump.gz
Restore tempfile created: 6.2 MiB
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index auth_group_permissions_group_id_permission_id_0cd325b0_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index auth_user_groups_user_id_group_id_94350c0c_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index auth_user_user_permissions_user_id_permission_id_14a6b632_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index django_content_type_app_label_model_76bd3d3b_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index auth_permission_content_type_id_codename_01ab375a_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index part_partstar_part_id_user_id_3cffef67_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index common_notificationentry_key_uid_93240f63_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index taggit_taggeditem_content_type_id_object_id_tag_id_4bb97a8e_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index part_partcategorystar_category_id_user_id_ea052d2d_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index company_manufacturerpartparameter_manufacturer_part_id_name_67acf00e_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index part_partsellpricebreak_part_id_quantity_bd1a9901_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index build_buildline_build_id_bom_item_id_39298754_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index build_builditem_build_line_id_stock_item_id_install_into_id_239bb093_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index part_supplierpricebreak_part_id_quantity_502fe8d1_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index part_supplierpart_part_id_supplier_id_SKU_5a63ff75_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index exchange_rate_currency_backend_id_c6037b21_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index flags_flagstate_name_condition_value_4e81ec48_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index order_salesordershipment_order_id_reference_0b2a76c1_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index part_bomitemsubstitute_part_id_bom_item_id_46b97ea2_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index part_partparameter_part_id_template_id_74280ad3_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index part_partrelated_part_1_id_part_2_id_0f725b72_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index socialaccount_socialapp_sites_socialapp_id_site_id_71a9a768_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index users_ruleset_name_group_id_129b730d_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index account_emailaddress_user_id_email_987c8728_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index unique_verified_email already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index company_manufacturerpart_part_id_manufacturer_id_MPN_7c735053_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index machine_machinesetting_machine_config_id_config_type_key_12c71a98_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index order_returnorderlineitem_order_id_item_id_d98e7e92_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index part_partinternalpricebreak_part_id_quantity_2f23db66_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index plugin_notificationusersetting_method_user_id_key_aada38de_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index plugin_pluginsetting_plugin_id_key_e49485b1_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index socialaccount_socialtoken_app_id_account_id_fca4e0ac_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: index socialaccount_socialaccount_provider_uid_fc810c6e_uniq already exists
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: auth_group.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: auth_group_permissions.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: auth_permission.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: auth_user.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: auth_user_groups.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: build_build.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: FOREIGN KEY constraint failed
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: build_buildline.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: common_inventreesetting.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: common_inventreesetting.key
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: common_inventreeusersetting.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: common_newsfeedentry.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table company_company has 16 columns but 15 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: django_admin_log.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: django_content_type.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: django_migrations.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: django_q_schedule.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table django_q_task has 12 columns but 13 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: django_site.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: exchange_exchangebackend.name
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: exchange_rate.currency, exchange_rate.backend_id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: exchange_rate.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: label_buildlinelabel.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: label_partlabel.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: label_stockitemlabel.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: label_stocklocationlabel.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: order_purchaseorder.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: order_purchaseorderlineitem.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: order_salesorder.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: order_salesorderallocation.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: order_salesorderlineitem.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: order_salesordershipment.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: part_bomitem.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: NOT NULL constraint failed: part_part.barcode_hash
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: part_partcategory.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table part_partpricing has 37 columns but 41 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table part_supplierpart has 20 columns but 19 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: plugin_notificationusersetting.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table plugin_pluginconfig has 5 columns but 6 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: plugin_pluginsetting.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table report_billofmaterialsreport has 9 columns but 11 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table report_buildreport has 9 columns but 11 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table report_purchaseorderreport has 9 columns but 11 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table report_returnorderreport has 9 columns but 11 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table report_salesorderreport has 9 columns but 11 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: report_stocklocationreport.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table report_testreport has 10 columns but 12 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: stock_stockitem.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: stock_stockitemtracking.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: table stock_stocklocation has 16 columns but 17 values were supplied
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: user_sessions_session.session_key
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: users_owner.id
warnings.warn(f"Error in db restore: {err}")
/opt/inventree/env/lib/python3.10/site-packages/dbbackup/db/sqlite.py:78: UserWarning: Error in db restore: UNIQUE constraint failed: users_ruleset.id
warnings.warn(f"Error in db restore: {err}")
Restoring InvenTree media files
Python version 3.10.12 - /opt/inventree/env/bin/python3
/opt/inventree/env/lib/python3.10/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")
Restoring backup for media files
Finding latest backup
Restoring: server-2024-05-26-000035.tar.gz
Backup size: 111.5 MiB

Also the front end on selecting the stock menu gives the message

Error details can be found in the admin panel
URL: /api/stock/location/tree/

Type:
OperationalError
Path:
/api/stock/location/
Info:
no such column: stock_stocklocation.location_type_id
When:
May 27, 2024, 1:56 p.m.
Data:
Traceback (most recent call last):

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 328, in execute
return super().execute(query, params)

sqlite3.OperationalError: no such column: stock_stocklocation.location_type_id

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

File "/opt/inventree/env/lib/python3.10/site-packages/rest_framework/views.py", line 506, in dispatch
response = handler(request, *args, **kwargs)

File "/opt/inventree/src/backend/InvenTree/InvenTree/api.py", line 414, in get
return super().get(request, *args, **kwargs)

File "/opt/inventree/env/lib/python3.10/site-packages/rest_framework/generics.py", line 239, in get
return self.list(request, *args, **kwargs)

File "/opt/inventree/env/lib/python3.10/site-packages/rest_framework/mixins.py", line 40, in list
page = self.paginate_queryset(queryset)

File "/opt/inventree/env/lib/python3.10/site-packages/rest_framework/generics.py", line 171, in paginate_queryset
return self.paginator.paginate_queryset(queryset, self.request, view=self)

File "/opt/inventree/env/lib/python3.10/site-packages/rest_framework/pagination.py", line 395, in paginate_queryset
return list(queryset[self.offset:self.offset + self.limit])

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/models/query.py", line 398, in iter
self._fetch_all()

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/models/query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/models/query.py", line 91, in iter
results = compiler.execute_sql(

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
cursor.execute(sql, params)

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
with self.db.wrap_database_errors:

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 328, in execute
return super().execute(query, params)

django.db.utils.OperationalError: no such column: stock_stocklocation.location_type_id

[rohitsingal1]

Was able to resolve it. Database file was wrongly copied. Closing the issue.