cPanel user manager error

Havri

• October 24, 2017 03:10

Hello, We are encountering an issue with the cPanel User Manager interface. If I try to edit anything for the email account general@mydomain.tld, I get the following error:
Eroare:The system failed to update the "general@mydomain.tld" 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

  • October 25, 2017 15:22

  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.

  0
• 

  Havri

  • October 26, 2017 10:00

  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 contact@mydomain.tld 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.

  0

Please sign in to leave a comment.