I searched the internet but cannot find anything related to this specific error/table. It pops up when I try to view a table in phpMyAdmin. I am logged in as root and the installation (under ubuntu 13.10) of phpMyAdmin is fresh and untouched so far.
Here is the whole message:
SELECT `prefs`
FROM `phpmyadmin`.`pma_table_uiprefs`
WHERE `username` = 'root'
AND `db_name` = 'symfony'
AND `table_name` = 'users'
MySQL reports: #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist
Is the installation just broken or am I missing something?
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:
locate create_tables.sql
./usr/share/doc/phpmyadmin/examples/create_tables.sql.gz
using phpMyAdmin./etc/phpmyadmin/config.inc.php
and edit lines 81-92: change pma_bookmark
to pma__bookmark
and so on.