Unofficial Version upgrade

[vele]

I was running an unofficial version with quotas on one of my boxes.
Since quotas are now supported I cannot upgrade outright

This is the version I am running:

✖	
A new version of Mail-in-a-Box is available. You are running version 0cd8e4db62b237c170f4688b7d07ef2f0cbd03a5. The latest version is v73. For upgrade instructions, see https://mailinabox.email.

And this is the message after tryong to upgrade.

 curl -s https://mailinabox.email/setup.sh | sudo bash
Updating Mail-in-a-Box to v73 . . .
fatal: couldn't find remote ref refs/tags/v73
error: pathspec 'v73' did not match any file(s) known to git
Update failed. Did you modify something in /root/mailinabox?

Any thoughts how to successfully upgrade?
Thanks

[KiekerJan]

See Cannot upgrade to V73 - #6 by Amedee for instructions on how to reset the git repository.

You might also run into Problem to update from v72 to v73, if your users database has been modified to support quotas.

[vele]

@KiekerJan

You might also run into Problem to update from v72 to v73, if your users database has been modified to support quotas.

Hmmm I get this:

 curl -s https://mailinabox.email/setup.sh | sudosh
Updating Mail-in-a-Box to v73 . . .
remote: Enumerating objects: 132, done.
remote: Counting objects: 100% (132/132), done.
remote: Compressing objects: 100% (64/64), done.
remote: Total 68 (delta 57), reused 8 (delta 4), pack-reused 0 (from 0)
Unpacking objects: 100% (68/68), 21.87 KiB | 361.00 KiB/s, done.
From https://github.com/mail-in-a-box/mailinabox
 * [new tag]         v73        -> v73


Running migration to Mail-in-a-Box #15...
Error: in prepare, duplicate column name: quota (1)

Error running the migration script:

Command '['sqlite3', '/home/user-data/mail/users.sqlite', "ALTER TABLE use COLUMN quota TEXT NOT NULL DEFAULT '0';"]' returned non-zero exit status

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

Is backup restore the smartest thing to do in this case?

[vele]

Thanks @KiekerJan
I confirm it all went well as per this

Problem to update from v72 to v73

The error looks like it is part of the new functionality to set quotas for users. Somehow, your database already has the required table structure. Did you in the past already try that functionality? (it has been in beta very long) You might get away with this by either: Editing /home/user-data/mailinabox.version. It should contain 14, set it to 15 Edit your sqlite database directly, removing the quota column. No guarantees, and of course make sure you have backups.

No need to edit sql databases.
Confirming also the check
quota TEXT NOT NULL DEFAULT '0'

Thanks again