Removing an email account produces an error from “SQLite”: SQLITE_ERROR (no such table: annotations)

Symptoms

When removing an email account in the cPanel user interface, you encounter an SQLite error where SQLite cannot find the table annotations, but you still see the email account was removed from the interface. 

Error: The system received an error from “SQLite”: SQLITE_ERROR (no such table: annotations)

Description 

When the SQLite database for the subaccount is corrupted or missing tables, the above error will be produced. If you navigate to the "User Manager" section within the cPanel account, and this fails to load any users, this is further signs the database will need to be recreated.  

Workaround

1. Create a backup directory in root or the user's home folder. 
   mkdir ~/sqlitebackup
2. Move the existing SQLite database for the subaccount to the newly created folder. 
   mv -v /home/$user/.subaccounts/storage.sqlite ~/sqlitebackup/
3. Run the upgrade script for the subaccount database. 
   /scripts/upgrade_subaccount_databases --user $username
4. Next, navigate to the Users Manager page to populate the database. 
5. When the page is loaded, you can verify the database with the sqlite3 command.
   sqlite3 /home/beatrizs/.subaccounts/storage.sqlite
   

   sqlite> .tables
   annotations meta users

6. The email account page will now successfully remove the accounts without producing an error.