phpmyadmin。pma_table_uiprefs不存在

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.

我搜索了互联网，但找不到任何与这个特定错误/表相关的东西。当我试图查看phpMyAdmin中的一个表时，它就会弹出。我以root身份登录，phpMyAdmin的安装(在ubuntu13.10下)是新鲜的，至今未受影响。

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?

是安装坏了还是我漏了什么?

15 个解决方案

#1

115

You are missing at least one of the phpMyAdmin configuration storage tables, or the configured table name does not match the actual table name.

您缺少至少一个phpMyAdmin配置存储表，或者配置的表名与实际表名不匹配。

See http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage.

见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.
在shell中:找到create_tables.sql。
import /usr/share/doc/phpmyadmin/examples/create_tables.sql.gz using phpMyAdmin.
进口/usr/share/doc/phpmyadmin/examples/create_tables.sql。广州使用phpMyAdmin。
open /etc/phpmyadmin/config.inc.php and edit lines 81-92: change pma_bookmark to pma__bookmark and so on.
/etc/phpmyadmin/config.inc开放。php和编辑行81-92:将pma_bookmark更改为pma__bookmark，以此类推。

#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:

我在Ubuntu 13.10上遇到了同样的问题。我不想破解PHP文件，因为通常phpMyAdmin在从Ubuntu存储库中安装包之后就会自动运行。而是我跑:

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.

在重新配置期间，我说“是”重新安装phpMyAdmin数据库。后来，问题就解决了。在安装或升级过程中，我有一个模糊的记忆，在早期的时候回答“不”这个问题。这可能就是问题发生的原因。

#3

You just change following line in /etc/phpmyadmin/config.inc.php

您只需在/etc/phpmyadmin/config.inc.php中更改以下代码。

$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’;

来

$ cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs’;

And restart apache server with command,

使用命令重新启动apache服务器，

sudo service apache2 restart

#4

Try sudo dpkg-reconfigure phpmyadmin

尝试sudo dpkg-reconfigure phpmyadmin

To Replace config file /etc/phpmyadmin/config-db.php with new version

替换配置文件/etc/phpmyadmin/config-db。php与新版本

#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'

添加:“pma__”到['bookmarktable']和"_"到'pma_bookmark'

#6

you should reconfigure the phpmyadmin On terminal:

您应该在终端重新配置phpmyadmin:

sudo dpkg-reconfigure phpmyadmin
sudo dpkg-reconfigure phpmyadmin

#7

I found a solution to fix this.

我找到了解决这个问题的办法。

Edit your /etc/phpmyadmin/config.inc.php file.

编辑你的/etc/phpmyadmin/config.inc。php文件。

Find:

发现:

if (!empty($dbport) || $dbserver != 'localhost') {
        $cfg['Servers'][$i]['connect_type'] = 'tcp';
        $cfg['Servers'][$i]['port'] = $dbport;
    }

Add after:

添加后:

$cfg['Servers'][$i]['pmadb'] = null; // Apurba

Restart your apache service and try. Hope it helps. Thanks.

重新启动apache服务并尝试。希望它可以帮助。谢谢。

#8

I use Windows 7 Xampp's version of phpmyadmin and none of the above, or below if this post gets upvoted, answers worked. I have tried uninstalling Xampp and upgrading to a higher version, manually changing values in the config folder, importing .sql files from some github page, and even viewing youtube videos but none of the suggestions worked.

我使用的是Windows 7 Xampp的phpmyadmin版本，如果这篇文章得到了支持，那么以上的内容都不会被使用。我尝试过卸载Xampp并升级到更高版本，手动更改配置文件夹中的值，从github页面导入.sql文件，甚至查看youtube视频，但没有一个建议有效。

Solution:

解决方案:

Delete EVERYTHING in the C:\xampp\phpMyAdmin folder > go to https://www.phpmyadmin.net/ and download the latest version > extract everything to the C:\xampp\phpMyAdmin folder and your problem is solved.

删除所有的C:\xampp\phpMyAdmin文件夹>到https://www.phpmyadmin.net/并下载最新版本>将所有内容提取到C:\xampp\phpMyAdmin文件夹，您的问题就解决了。

^^^^^ Read this if you don't want to waste hours searching Google for tons of failed solutions. It's far simpler too! ^^^^^^

如果你不想浪费时间在谷歌上寻找大量的失败的解决方案，你就会读到这篇文章。这是更简单!^ ^ ^ ^ ^ ^

#9

in linux os such as Debian or Ubutu you can simply try this ways, for first time remove phpmyadmin with --purge parameter:

在诸如Debian或Ubutu这样的linux操作系统中，您可以简单地尝试这种方法，第一次删除phpmyadmin和—清除参数:

sudo apt-get remove --purge phpmyadmin

then install again

然后再安装

sudo apt-get install phpmyadmin

thats work fine :)

这工作很好:)

#10

You just need to change the table names as per the error in - /etc/phpmyadmin/config.inc.php

您只需要根据- /etc/phpmyadmin/config. php .php中的错误来更改表名称。

$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’;

来

$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma__table_uiprefs’;

assign the table names accordingly and everything will be fine.

相应地分配表名，一切都会很好。

For me,sudo dpkg-reconfigure phpmyadmin caused more trouble when I chose the option to re-install the database

对我来说，当我选择重新安装数据库的选项时，sudo dpkg-reconfigure phpmyadmin会带来更多的麻烦。

#11

I had the same problem with latest Lampp with MariaDB on Ubuntu Server 14.04, and @iceberg's solution worked very well:

我在Ubuntu服务器14.04上遇到了与MariaDB最新的Lampp相同的问题，@iceberg的解决方案工作得很好:

You just change following line in /etc/phpmyadmin/config.inc.php

您只需在/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,

使用命令重新启动apache服务器，
sudo service apache2 restart

Lampp config.inc.php is located in /opt/lampp/phpmyadmin/config.inc.php and to make it work, I also needed to change

Lampp config.inc。php位于/opt/lampp/phpmyadmin/config.inc。php和它的工作，我也需要改变。

$ cfg ['Servers'] [$ i] ['tracking'] = ‘pma__tracking’;

来

$ cfg ['Servers'] [$ i] ['pma__tracking'] = ‘pma__tracking’;

and restart the lampp:

并重新启动lampp:

sudo /opt/lampp/lampp stop
sudo /opt/lampp/lampp start

#12

Steps:

步骤:

Just download create_table.sql from GitHub and save that file in your system.
只是下载create_table。来自GitHub的sql并将该文件保存在您的系统中。
Then go to your phpMyAdmin.
然后去你的phpMyAdmin。
And click on Import from upper tab.
然后点击从上标签导入。
At last select create_table.sql and upload that.
最后选择create_table。sql和上传。

After all it works for me and hopefully work for you.

毕竟它对我有用，希望对你有用。

#13

I just located the create_tables.sql, saved to my desktop, opened phpMyAdmin, selected the import tab, selected the create_tables.sql, clicked ok

我刚刚找到了create_tables。sql保存到我的桌面，打开phpMyAdmin，选择import选项卡，选择create_tables。sql,点击ok

#14

To elaborate on multiple reply here above, there is an error in the config.inc.php shipped, where a "_" is missing, which is what this reply sais.

要详细说明上面的多个回复，config.inc.有一个错误。php发送了一个“_”丢失，这就是这个回复sais。

To fix that, you can add a "pma__table_uiprefs.inc.php" in the "/etc/phpmyadmin/conf.d" folder, leaving main configuration files untouched...

为了解决这个问题，您可以添加一个“pma__table_uiprefs.inc”。php”“/ etc / phpmyadmin / conf。“文件夹，留下主要的配置文件未动……”

<?php foreach($cfg['Servers'] as $i => $v) { $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; }

< ?php foreach($ cfg(“服务器”)作为我= > v)美元{ $ cfg[“服务器”][$ i][' table_uiprefs ']=“pma__table_uiprefs”;}

#15

A really simple solution is to edit /etc/phpmyadmin/config.inc.php and put

一个非常简单的解决方案是编辑/etc/phpmyadmin/config.inc。php和把

$cfg['Servers'][$i]['table_uiprefs'] = '';

美元$ cfg[“服务器”][我][‘table_uiprefs]= ";

It just manages the UI and who needs the UI if its interfering with display of actual data.

它只是管理UI，如果它干扰实际数据的显示，则需要UI。

cheers

干杯

#1

115