#1146 - Table 'phpmyadmin.pma__table_uiprefs' doesn't exist

Hi there I recently updated the server with

Code:

apt-get update and apt-get upgrade

and one of the updates was phpmyadmin.

The apt history log shows the following:

Code:

phpmyadmin:amd64 (4.2.12-2+deb8u2, 4.2.12-2+deb8u3)

Now my problem is, every time I try to edit a one of the database in phpmyadmin I get the following error:

Code:

SELECT `prefs` FROM `phpmyadmin`.`pma__table_uiprefs` WHERE `username` = 'root' AND `db_name` = 'db-name' AND `table_name` = 'table-name'

#1146 - Table 'phpmyadmin.pma__table_uiprefs' doesn't exist

The following is shown on the main page when loged in as "root":

Code:

$cfg['Servers'][$i]['pmadb'] ...    OK
$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]['recent'] ...    not OK [ Documentation ]
Persistent recently used tables: Disabled

$cfg['Servers'][$i]['table_uiprefs'] ...    not OK [ Documentation ]
Persistent tables' UI preferences: Disabled

$cfg['Servers'][$i]['tracking'] ...    not OK [ Documentation ]
Tracking: Disabled

$cfg['Servers'][$i]['userconfig'] ...    not OK [ Documentation ]
User preferences: Disabled

$cfg['Servers'][$i]['users'] ...    not OK [ Documentation ]
$cfg['Servers'][$i]['usergroups'] ...    not OK [ Documentation ]
Configurable menus: Disabled

$cfg['Servers'][$i]['navigationhiding'] ...    not OK [ Documentation ]
Hide/show navigation items: Disabled

$cfg['Servers'][$i]['savedsearches'] ...    not OK [ Documentation ]
Saving Query-By-Example searches: Disabled

Quick steps to setup advanced features:

Create the needed tables with the examples/create_tables.sql. Documentation
Create a pma user and give access to these tables. Documentation
Enable advanced features in configuration file (config.inc.php), for example by starting from config.sample.inc.php. Documentation
Re-login to phpMyAdmin to load the updated configuration file.

In this thread the guy fixed it by issueing the following command:

Code:

dpkg-reconfigure -plow phpmyadmin

Will this work in my situation? I'm only asking because the thread is a couple of years old and we currently host a couple of site on that server so breaking the databases is kind of not the goal here

 

Thanks Till, it did indeed work.