Error "table users has no column named has_invite" when using "Send login link to alternate email address." during email creation.

Symptoms

You may see an error similar to the following when using the

Send login link to alternate email address.

Option for the password when creating an email account

Error: The system failed to create the user: The system received an error from “SQLite”: SQLITE_ERROR (table users has no column named has_invite)

Description 

This is due to missing column data in the /home/<user>/.subaccounts/storage.sqlite database. Below is how this can be corrected.

Workaround

First backup the database in question.

cp -vi storage.sqlite{,.backup}

Then modify the database with the following commands. (Do not include the parts that say sqlite>)

sqlite3 storage.sqlite

sqlite> CREATE TABLE meta (key text, value text);
sqlite> ALTER TABLE users ADD COLUMN has_invite integer;
sqlite> ALTER TABLE users ADD COLUMN invite_expiration integer;
sqlite> .exit