Upgrade Failure - Very Concerned

1

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
2

What version were you previously on?

3

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?

4

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.

6

Hi Josh,

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

Thanks for your help, much appreciated.

Cheers
Ben

7

I had the same issue with the same fix.