Symptoms
- The following message appears on phpMyAdmin home page in Plesk:
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
- When the suggested link is opened, the following appears:
General relation features: Enabled
$cfg['Servers'][$i]['favorite'] ... not OK [ Documentation ]
Persistent favorite tables: Disabled
Cause
phpMyAdmin configuration storage misconfiguration.
Resolution
Click on a section to expand
For Plesk Onyx and Plesk Obsidian below 18.0.30:
- Login to the server via SSH.
- According to the error favorite table has not OK status. Find this table from the error in configuration file:
# grep favorite /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php | grep -v “*”
$cfg[‘Servers’][$i][‘favorite’] = ”; - Set pma_<table_name> value for above output inÂ
/usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php
fileÂ
using text editor:# grep favorite /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php | grep -v “*”
$cfg[‘Servers’][$i][‘favorite‘] = ‘pma_favorite‘; -
Clear browser cache and login to phpMyAdmin again.
Click on a section to expand
For Plesk Obsidian 18.0.30 and above:
- Login to the server via SSH.
- According to the error favorite table has not OK status. Find this table from the error in configuration file:
# grep favorite /usr/local/psa/phpMyAdmin/libraries/config.default.php | grep -v “*”
$cfg[‘Servers’][$i][‘favorite’] = ”; - Set pma_<table_name> value for above output inÂ
/usr/local/psa/phpMyAdmin/libraries/config.default.php
fileÂ
using text editor:# grep favorite /usr/local/psa/phpMyAdmin/libraries/config.default.php | grep -v “*”
$cfg[‘Servers’][$i][‘favorite‘] = ‘pma_favorite‘; -
Clear browser cache and login to phpMyAdmin again.