Upgrade Failure - Very Concerned

Hi Josh,

I followed the normal process to upgrade to V0.09, however got the following error:

Updating Mail-in-a-Box to v0.09 . . .
remote: Counting objects: 41, done.
remote: Compressing objects: 100% (37/37), done.
remote: Total 41 (delta 38), reused 6 (delta 4), pack-reused 0
Unpacking objects: 100% (41/41), done.
From https://github.com/mail-in-a-box/mailinabox

  • [new tag] v0.09 -> v0.09

Running migration to Mail-in-a-Box #4
Error: duplicate column name: privileges

Error running the migration script:

Command ‘[‘sqlite3’, ‘/home/user-data/mail/users.sqlite’, “ALTER TABLE users ADD privileges TEXT NOT NULL DEFAULT ‘’”]’ returned non-zero exit status 1

Your system may be in an inconsistent state now. We’re terribly sorry. A re-install from a backup might be the best way to continue.

Would you please be able to advise, my mail appears to be working but could anything be broken?

1 Like

What version were you previously on?

Hi Josh,

I was on 0.08 going to 0.09.

I am not sure if the restore from backup would help as surely the users.sqlite is part of the personal data which is essential to the box functioning with my current setup?

It sounds like /home/user-data/mailinabox.version got reset to an earlier state. You could review what the migrations were to see if you need to apply them.Otherwise, it’s relatively safe to just delete /home/user-data/mailinabox.version and re-run setup. Backup first.

Hi Josh,

Goods news - deleting that file and running the upgrade seemed to fix the issue!

Thanks for your help, much appreciated.


I had the same issue with the same fix.