DB Error after update to 1.3.2

[StevenK2104]

Getting this error now after I updated to 1.3.2

ERROR: SPM:DatabaseManager
Database call error in methode loadSpool. See OctoPrint.log for details!

Log file below

octoprint.log

[StanDH]

Identical Problem.

[StevenK2104]

any idea on how long this will be till the issue is fixed ?

[OllisGit]

Hi @StevenK2104 ,

the log messages of the db-migration looks good. Please do the following:

• login to your raspberry via ssh
• navigate to the database-location (found in plugin-settings)
• type sqlite3 spoolmanager.db
• type select * from spo_spoolmodel
• paste the result to this issue
• type select * from spo_pluginmetadatamodel
• paste the result to this issue

btw. "Impossible is done immediately, miracles take longer"

[OllisGit]

Hi,
fyi: found the issue, will be fixed in the next minutes!

[vinxdb]

pi@octopi:~/.octoprint/data/SpoolManager $ sqlite3 spoolmanager.db
-bash: sqlite3: command not found

[schwos]

Experience the same issue; as well sqlite3 isn't installed natively on the Raspberry PI install in the image. It was necessary to install sqlite3 on my image

sudo apt-get install sqlite3

[OllisGit]

Error is fixed in latest release 1.3.3.
Please test and give feedback.

Sorry,
Olli

[StevenK2104]

Issue now resolved.
Many thanks @OllisGit for the great work on this

[vinxdb]

It works, thank you!