Upgrade to 017.5 failed, content folder/database disappeared

Support Kolibri
4

Hi @cjackson,

Okay looks like Kolibri was updated okay, but there’s a database integrity error preventing startup.

Here are some next steps:

  1. Again, ensure the system installation is stopped: sudo systemctl stop kolibri
  2. Change to the kolibri user: sudo su $(cat /etc/kolibri/username)
  3. Make a backup of the sqlite database just in case: cp ~/.kolibri/db.sqlite3 ~/.kolibri/db.sqlite3.backup
  4. Open the database with sqlite, which will provide you with a shell (install sqlite3 if command does not exist): sqlite3 ~/.kolibri/db.sqlite3
  5. Run the following SQL in the sqlite shell:
DELETE FROM content_channelmetadata_included_languages AS ccil WHERE NOT EXISTS (SELECT 1 FROM content_channelmetadata AS cc WHERE cc.id = ccil.channelmetadata_id);
  1. Exit the sqlite shell: .exit
  2. Log out of the kolibri user: exit
  3. Try to start the system installation again: sudo systemctl start kolibri

If Kolibri now starts up, you can delete the database backup.

Regards,
Blaine