Problem to update from v72 to v73

Help with Setup/Upgrade
1

Hello,

I’m trying to migrate from version 72 to version 73, but I consistently get an error related to a problem with users.sqlite (see screenshot).

Capture d'écran 2025-08-09 060818
Capture d'écran 2025-08-09 0608181734×927 61.9 KB

I tried recreating a VPS from scratch, reinstalling MiaB, and restoring the backup I made just before, and I get the same error.
On a new VPS, version 73 installs correctly; the problem appears as soon as my users.sqlite file is included.
Can you help me?
I can’t afford to lose emails.
Thank you.

2

The install/update command is run from user “ubuntu”, not “root”. The “sudo -i” command is probably not a good idea. I don’t know if that’s causing your problem, but I’ve heard of similar.

It may be that’s it’s gone too far to be easily fixed, in which cause new install and restore from backup is the safest course. There are instructions for doing that on the website.

1 Like
3

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.

1 Like
4

Thank you for your suggestion.
I’m now on the v73.
Editing the mailinabox.version has work.

Have a nice day.

5

It might be good to verify that your table structure is correct.

sqlite3 /home/user-data/mail/users.sqlite
sqlite> .schema users

Output should contain
quota TEXT NOT NULL DEFAULT '0'

1 Like
6

I checked, it seems correct.
Thanks.