phpmyadmin.pma_table_uiprefs doesn't exist
You are missing at least one of the phpMyAdmin configuration storage tables, or the configured table name does not match the actual table name.
See http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage.
A quick summary of what to do can be:
- On the shell:
locate create_tables.sql
. - import
/usr/share/doc/phpmyadmin/examples/create_tables.sql.gz
using phpMyAdmin. - open
/etc/phpmyadmin/config.inc.php
and edit lines 81-92: changepma_bookmark
topma__bookmark
and so on.
I came across this same problem on Ubuntu 13.10. I didn't want to hack PHP files, because normally phpMyAdmin works out of the box after installing the package from Ubuntu repositories. Instead I ran:
sudo dpkg-reconfigure phpmyadmin
During reconfigure, I said "yes" to reinstalling the phpMyAdmin database. Afterwards, the problem was gone. I have a vague memory of answering "No" to that question at some earlier time, during an install or upgrade. That is probably why the problem occurred in the first place.
You just change following line in /etc/phpmyadmin/config.inc.php
$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’;
to
$ cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs’;
And restart apache server with command,
sudo service apache2 restart