The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated:

Date Posted: 28-05-2017

When we install phpmyadmin on linux machine and we might have seen the following error on the login page. If we click on the error page, we might have get the following information on the phpmyadmin page.

$cfg[‘Servers’][$i][‘relation’] … not OK [ Documentation ]
General relation features: Disabled

$cfg[‘Servers’][$i][‘table_info’] … not OK [ Documentation ]
Display Features: Disabled

$cfg[‘Servers’][$i][‘table_coords’] … not OK [ Documentation ]

$cfg[‘Servers’][$i][‘pdf_pages’] … not OK [ Documentation ]
Creation of PDFs: Disabled

$cfg[‘Servers’][$i][‘column_info’] …not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled

$cfg[‘Servers’][$i][‘bookmarktable’] … not OK [ Documentation ]
Bookmarked SQL query: Disabled

$cfg[‘Servers’][$i][‘history’] …not OK [ Documentation ]
SQL history: Disabled

$cfg[‘Servers’][$i][‘designer_coords’] … not OK [ Documentation ]
Designer: Disabled

$cfg[‘Servers’][$i][‘tracking’] … not OK [ Documentation ]
Tracking: Disabled

The basic phmyadmin installation doesn’t have default configuration which is why we are getting the above error.

Solution:

Inorder to fix the issue, follow the below mentioned steps.

Take a copy of existing configuration file. The default location will be (/etc/phpmyadmin/config.inc.php). If the installation path is different then you need to update corresponding configuration.

vi /etc/phpmyadmin/config.inc.php

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';


$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates']  = 'pma__export_templates';

There is two underscore(__) after pma.

Save the file and logout from phpmyadmin page.

Restart the webserver. Incase, if its apache2 on ubuntu host, execute the below command.

/etc/init.d/apache2 restart

Now, the error must be vanished on phpmyadmin page.