cPanel user manager error

[Havri]

Hello,

We are encountering an issue with the cPanel User Manager interface. If I try to edit anything for the email account [email protected], I get the following error:

Eroare:The system failed to update the “[email protected]” user with the following error: The system failed to edit the user: Cpanel::Exception::Database::Error/(XID hfjq5k) The system received an error from “SQLite”: SQLITE_ERROR (no such column: has_invite) at /usr/local/cpanel/Cpanel/Exception/CORE.pm line 330. Cpanel::Exception::create("Database::Error", ARRAY(0x1629908)) called at /usr/local/cpanel/Cpanel/Exception.pm line 46 Cpanel::Exception::ANON (CPANEL_HIDDEN , ARRAY(0x1629908)) called at /usr/local/cpanel/Cpanel/DBI.pm line 189 Cpanel::DBI::_create_exception(Cpanel::DBI::db=HASH(0x2752930), "DBD::SQLite::db do failed: no such column: has_invite", undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 177 Cpanel::DBI::_error_handler("DBD::SQLite::db do failed: no such column: has_invite", Cpanel::DBI::db=HASH(0x2752930), undef) called at /usr/local/cpanel/Cpanel/UserManager/Storage.pm line 116 Cpanel::UserManager::Storage::amend(Cpanel::UserManager::Record=HASH(0x25dcd30)) called at /usr/local/cpanel/Cpanel/UserManager.pm line 429 Cpanel::UserManager::edit_user(HASH(0x2154620)) called at /usr/local/cpanel/Cpanel/API/UserManager.pm line 262 eval {...} called at /usr/local/cpanel/Cpanel/API/UserManager.pm line 262 Cpanel::API::UserManager::edit_user(Cpanel::Args=HASH(0x2153fa0), Cpanel::Result=HASH(0x2153e38)) called at /usr/local/cpanel/Cpanel/API.pm line 276 Cpanel::API::ANON () called at /usr/local/cpanel/Cpanel/API.pm line 348 eval {...} called at /usr/local/cpanel/Cpanel/API.pm line 348 Cpanel::API::_eval_guard(Cpanel::Result=HASH(0x2153e38), CODE(0x219b268)) called at /usr/local/cpanel/Cpanel/API.pm line 276 Cpanel::API::_run_module_function(Cpanel::Args=HASH(0x2153fa0), Cpanel::Result=HASH(0x2153e38), "UserManager", "edit_user") called at /usr/local/cpanel/Cpanel/API.pm line 139 Cpanel::API::execute("UserManager", "edit_user", HASH(0x2178628)) called at /usr/local/cpanel/Cpanel/API.pm line 547 Cpanel::API::run_api_mode(HASH(0x2178628)) called at uapi.pl line 266 main::script() called at uapi.pl line 85

Can someone point me in the right direction to solve this?

Let me know if you need any other info.

Thank you.

 

[cPanelMichael]

Hello,

You can try creating the missing column with the following commands to see if that helps solve the issue:

cd /home/$username/.subaccounts/
sqlite3 storage.sqlite
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
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

Thank you.

 

[Havri]

Hello Michael,

Thank you for your help. I created the missing column using your tutorial, but I still couldn't edit any details of the email account [email protected] becuase of some duplicate entries for the same account. In the end, I ended up emptying the users table from the sqlite database:

cd /home/$username/.subaccounts/
sqlite3 storage.sqlite
delete from users;
.exit

After that, I recreated the account and restored the content from a backup and it worked fine.

Best regards.