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!

SQLite issue on user graphs

Discussion in 'Database Discussion' started by urgido, May 12, 2018.

  1. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    117
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    I received the following error:

    FYI: I can't see all graphs/stats on cPanel

    Can you help me?
    Regards
     
  2. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    117
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    UPDATE:
    This issue is affected to all system users.

    /scripts/upcp --force doesn't help.
     
    #2 urgido, May 12, 2018
    Last edited by a moderator: May 12, 2018
  3. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    1,855
    Likes Received:
    135
    Trophy Points:
    118
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hello @urgido


    Can you tell me if rebuilding the db resolves the issue? You can do this with the following:

    Code:
    mv /var/cpanel/bandwidth_cache.sqlite{,.bak}
    /scripts/rebuild_bandwidthdb_root_cache
    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    117
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    @cPanelLauren
    The problem still present.

    Another clue?
    Thanks
     
  5. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    1,855
    Likes Received:
    135
    Trophy Points:
    118
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @urgido

    What about the ownership of the files in /var/cpanel/bandwidth? They should all be owned by the UID root and GID associated with each user.

    So if my user is test the ownership should be root:test

    If this is correct, could you please open a ticket using the link in my signature. Once opened update this thread with the ticket ID so we can provide the outcome in this thread.


    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    117
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    9556619

    Thanks a lot.
     
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