Havri

Well-Known Member
Oct 28, 2013
86
19
8
cPanel Access Level
Root Administrator
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:

Code:
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

Administrator
Staff member
Apr 11, 2011
47,909
2,224
463
Hello,

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

Code:
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.
 
  • Like
Reactions: Havri

Havri

Well-Known Member
Oct 28, 2013
86
19
8
cPanel Access Level
Root Administrator
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:

Code:
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.
 
  • Like
Reactions: cPanelMichael