phpMyAdmin fix savedsearches

I’m on Debian Sid (unstable) and I upgraded phpMyAdmin to 4.2.2deb1 (or maybe 1 or 2 versions earlier, according to phpMyAdmin’s documentation since 4.2.0).

The problem

After the upgrade I got the following error when I logged in on phpMyAdmin:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

If I click on the link I get:

$cfg[‘Servers’][$i][‘savedsearches’] … not OK [ Documentation ] Saving Query-By-Example searches: Disabled

At first the documentation link was broken, but later it got fixed. However, it didn’t contain any useful information.

This was the only problem I had. By using Google I could only find this page, but the tables were already created for me (possibly because I’m using Debian’s package system), so executing those commands would only break things for me.

I’ve checked:

• If the phpmyadmin user has permissions for the phpmyadmin database
• If the table (pma__savedsearches) exists
• If the table has a structure
• Some other things that are not useful enough to mention here

Actually I was really close to the solution from the beginning. The only problem was that I used a ’ instead of a ' in my configuration, causing the whole entry to be ignored.

Adding savedsearches

These steps are based on phpMyAdmin on Debian Sid using apt-get. The location of the configuration file may be somewhere else for different installation methods.

• Edit phpMyAdmin’s configuration file

  nano /etc/phpmyadmin/config.inc.php
  

• Search for the following line (the one without // in front of it):

  $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
  

• Place the following on a new line:

  $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
  

  

• Save the file
• Log out of phpMyAdmin
• Clear or refresh your PHP cache (if you have any)
• Log in on phpMyAdmin

Now the error should be fixed. If it’s not, please follow the other checks I’ve done in order to solve this problem under The problem.

Update

I’ve reported this bug and it’ll be fixed in the next version of phpMyAdmin (4.4.2deb2).

phpmyadmin: savedsearches not configured causing error message