DB broken after update

[SparkeyinVA]

Yesterday @SchrodingersGat helped me discover a bug in my installation of 0.11.0. The installation of 0.11.0 was done with Ubuntu 22.04 LTS and the quick install is outlined on this page. https://docs.inventree.org/en/latest/start/installer/ and the install worked great and was using a sqlite3 database.

Since I was told that the latest version had the bug fix I decided to try updating the install. The website https://inventree.org/ was down so I tried the master install for Ubuntu 20.04 as shown here. https://packager.io/gh/inventree/InvenTree/builds/498/install/ubuntu-20.04
The installation went well and the inventree did appear to be updated to 0.12.0 dev. However, the database is not fully working. For example, I can see part subcategories but I can't see any parts.

I am getting a large number of Server errors. I am copying one of these errors at the end of this post.

I had not finished a step to get the database Migrated correctly. I am unsure what since I that with the quick install, this happened automatically after 0.11.0.

I have tried rerunning the quick install today since the site is back up, and it works; however, it says that inventree is already at the latest version regardless if I try to install stable or latest or master versions.

Since I have a daily backup set, I tried to restore the last backup using the invoke restore, as shown here, https://docs.inventree.org/en/latest/start/backup/. I ran this from within the virtual environment and the /opt/inventree folder. I also can't get it to work.

I am at a loss as to what to do next. Any suggestions would be very helpful.

Here is an example of one Server error.
Error object (67)
(http://192.168.1.200/admin/error_report/error/67/history/)

Type: OperationalError
Path: http://192.168.1.200/order/sales-order/11/
Info: no such column: stock_stockitem.consumed_by_id
When: May 24, 2023, 1:02 p.m.
Data: Traceback (most recent call last):

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

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

sqlite3.OperationalError: no such column: stock_stockitem.consumed_by_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/django/core/handlers/base.py", line 181, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/opt/inventree/env/lib/python3.10/site-packages/django/views/generic/base.py", line 70, in view
return self.dispatch(request, *args, **kwargs)

File "/opt/inventree/env/lib/python3.10/site-packages/django/contrib/auth/mixins.py", line 104, in dispatch
return super().dispatch(request, *args, **kwargs)

File "/opt/inventree/env/lib/python3.10/site-packages/django/views/generic/base.py", line 98, in dispatch
return handler(request, *args, **kwargs)

File "/opt/inventree/env/lib/python3.10/site-packages/django/views/generic/detail.py", line 106, in get
self.object = self.get_object()

File "/opt/inventree/env/lib/python3.10/site-packages/django/views/generic/detail.py", line 52, in get_object
obj = queryset.get()

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/models/query.py", line 431, in get
num = len(clone)

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

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

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/models/query.py", line 813, in _prefetch_related_objects
prefetch_related_objects(self._result_cache, *self._prefetch_related_lookups)

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/models/query.py", line 1730, in prefetch_related_objects
obj_list, additional_lookups = prefetch_one_level(

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/models/query.py", line 1872, in prefetch_one_level
all_related_objects = list(rel_qs)

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

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/models/query.py", line 1324, 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 51, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)

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

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/backends/utils.py", line 75, 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 79, in _execute
with self.db.wrap_database_errors:

File "/opt/inventree/env/lib/python3.10/site-packages/django/db/utils.py", line 90, 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 84, in _execute
return self.cursor.execute(sql, params)

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

django.db.utils.OperationalError: no such column: stock_stockitem.consumed_by_id

[SparkeyinVA]

I was able to fix this finally. Steps taken. https://docs.inventree.org/en/latest/start/installer/. I followed the steps for "Manual Install"

Step 1) wget -qO- https://dl.packager.io/srv/inventree/InvenTree/key | sudo apt-key add -
Step 2) sudo wget -O /etc/apt/sources.list.d/inventree.list https://dl.packager.io/srv/inventree/InvenTree/stable/installer/ubuntu/20.04.repo
Step 3) sudo apt-get update

Next, I removed inventree
Step 4) sudo apt remove inventree

I was able to then able to install inventree using the Quick Script
Step 5) wget -qO install.sh https://get.inventree.org && bash install.sh

I tried removing it, and it did not work because the key was invalid. But when I followed the above steps in this order, it worked, and reindexed the database, and all is well with the world.

I am back to V0.11.0. I am unsure when V0.11.1 or V0.11.2 (which has the bug fix) will be available for a stable install. I am assuming that running the quick script will update to the most recent stable version. Is this assumption correct?

[matmair]

@SparkeyinVA stable packages mirror the stable branch. master mirrors the master branch. We might need to change that strategy as it seems that bugfixes are not picked up that way.

I am a bit surprised by the errors - did you use https://packager.io/gh/inventree/InvenTree/builds/498/install/ubuntu-20.04 or another build / do you have an idea about the time when you tried the install so that I can look up the current build at that time?
We had a key change a few releases ago - do you have any idea when (version number) you first installed InvenTree on that server? Might have been before the key change. They should roll over but that fails sometimes .

[SparkeyinVA]

@matmair When I think about stable vs. master, I think of what KiCad does where the stable is the release, and the master is like the nightly. Could you clarify for me the way that inventree is done? I can wait until version 0.11.2 is available as a stable version.

I think I did the https://dl.packager.io/srv/inventree/InvenTree/master/installer/ubuntu/20.04.repo. I did the installation on May 23, between 9 and 10 AM EST. it was a master build 493 or 494, I believe.

The fix I am looking for is the one discussed in this thread #4876. V0.11.0 the sales order allocation button is missing. @SchrodingersGat said it has been fixed in V0.11.2.

Thanks a lot for all the help. :)

[matmair]

Pretty much. KiCad has a bit more phases to a stable release but yes.

Thank you for the info, I will try to reproduce this. If you run updates now it should actually update to 0.11.2 - that release was not build automatically for some reason.

[SparkeyinVA]

@matmair Thank you and I have been able to update to V0.11.2 and it looks like it is working as expected.