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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Keep"MaxNavigationItems" between updates

Discussion in 'Database Discussions' started by PatrickVeenstra, Nov 15, 2017.

  1. PatrickVeenstra

    PatrickVeenstra Well-Known Member

    Joined:
    Feb 12, 2012
    Messages:
    93
    Likes Received:
    3
    Trophy Points:
    58
    Location:
    Barcelona
    cPanel Access Level:
    Root Administrator
    I'd like to preserve my phpMyAdmin settings, specifically MaxNavigationItems, and the message in phpMyAdmin links to a local copy of Installation — phpMyAdmin 4.8.0-dev documentation

    Even after reading it a couple of times I don't understand what I have to do to keep my settings between updates. What (where?) do I have to edit to keep my settings?

    p.s. Since phpMyAdmin has a filter for table names, is there really a point in paging (by default)?
     
  2. cPWilliamL

    cPWilliamL cP Technical Analyst II
    Staff Member

    Joined:
    May 15, 2017
    Messages:
    257
    Likes Received:
    27
    Trophy Points:
    103
    Location:
    America
    cPanel Access Level:
    Root Administrator
    Hi,

    I believe this value is pulled from a two locations, the current user's cookie(pma_console_config) and the '/usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php' configuration file. If no cookie is found, or if the value is not set in the cookie, then it's pulled from the configuration. I set this value as below:
    Code:
    echo "$cfg['MaxNavigationItems'] = 100;" >> /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php
    
    This should persist updates as well.

    Thanks,
     
  3. PatrickVeenstra

    PatrickVeenstra Well-Known Member

    Joined:
    Feb 12, 2012
    Messages:
    93
    Likes Received:
    3
    Trophy Points:
    58
    Location:
    Barcelona
    cPanel Access Level:
    Root Administrator
    Thanks a lot. There was no cookie value (after storing it in CPanel), so I guess it uses some server storage setting, but I think that editing config.inc.php did the job.
     
Loading...

Share This Page