Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

cPanel user manager error

Discussion in 'General Discussion' started by Havri, Oct 24, 2017.

Tags:
  1. Havri

    Havri Well-Known Member

    Joined:
    Oct 28, 2013
    Messages:
    80
    Likes Received:
    17
    Trophy Points:
    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 general@mydomain.tld, I get the following error:

    Code:
    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.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    Havri likes this.
  3. Havri

    Havri Well-Known Member

    Joined:
    Oct 28, 2013
    Messages:
    80
    Likes Received:
    17
    Trophy Points:
    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 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:

    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.
     
    cPanelMichael likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice