phpmyadmin.pma_table_uiprefs doesn't exist
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?
Solution 1:
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.
Solution 2:
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.
Solution 3:
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
Solution 4:
Try sudo dpkg-reconfigure phpmyadmin
To Replace config file /etc/phpmyadmin/config-db.php with new version
Solution 5:
I had to change this rows:
$cfg['Servers'][$i]['pma__bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['pma__relation'] = 'pma__relation';
$cfg['Servers'][$i]['pma__table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['pma__table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pma__pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['pma__column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['pma__history'] = 'pma__history';
$cfg['Servers'][$i]['pma__table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['pma__designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['pma__tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['pma__userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['pma__recent'] = 'pma__recent';
$cfg['Servers'][$i]['pma__table_uiprefs'] = 'pma__table_uiprefs';
add: "pma__" to ['bookmarktable'] and "_" to 'pma_bookmark'