I received this error today in phpMyAdmin,
我今天在phmypadmin收到这个错误，
1146 - Table 'phpmyadmin.pma__tracking' doesn't exist
nginx/1.6.2 | Database client version: libmysql - 5.5.41-MariaDB | PHP extension: mysqli
数据库客户端版本:libmysql - 5.51 - mariadb | PHP扩展:mysqli
It's rendered it inaccessible as whenever I try to create the table using SQL query i get that same error, #1146 - Table 'phpmyadmin.pma__tracking' doesn't exist.
当我尝试使用SQL查询创建表时，它就无法访问，我得到了同样的错误#1146 -表'phpmyadmin。pma__tracking”根本不存在。
I can't select a database or do anything in phpMyAdmin, is there a way to delete the tables manually or a workaround?
我不能选择数据库或在phpMyAdmin中做任何事情，是否有办法手动删除表或解决方法?
Using any SQL i.e DROP DATABASE results in, #1146 - Table 'phpmyadmin.pma__tracking' doesn't exist.
我使用任何SQL。删除数据库结果，#1146 -表'phpmyadmin。pma__tracking”根本不存在。
Thanks
谢谢
1 个解决方案
#1
7
I just tested this with the phpMyAdmin I have installed and even when I deleted the table manually and got the error message, I could clear it up by logging out and logging back in again. So my first suggestion is to make sure your phpMyAdmin is rather up to date, as this feature has received some improvements in recent versions.
我刚刚用我安装的phmypadmin测试了这一点，甚至当我手动删除表并得到错误消息时，我也可以通过注销和再次登录来清除它。因此，我的第一个建议是确保您的phpadmin myis是最新的，因为这个特性在最近的版本中得到了一些改进。
Next, I suggest you log out, clear your browser cache (at least as it relates to the phpMyAdmin page), and log in again.
接下来，我建议您注销，清除浏览器缓存(至少与phpMyAdmin页面相关)，然后再次登录。
You can either fix the table or disable that feature.
您可以修复该表或禁用该特性。
Repairing the phpMyAdmin Configuration Storage
Simply run the create_tables.sql file included in the examples or sql folder of your phpMyAdmin installation. You should edit the file if you wish to use a non-default database name or table names.
简单地运行create_tables。在phpMyAdmin安装的示例或sql文件夹中包含的sql文件。如果希望使用非默认数据库名称或表名，则应该编辑该文件。
This could be more difficult if, for some reason, your phpMyAdmin still doesn't let you log in. In that case, you can either do it from the mysql command line client or disable the feature (see below) in order to gain access. That shouldn't be necessary, though; phpMyAdmin should automatically disable the feature on login if the table is missing.
如果因为某些原因，phpMyAdmin仍然不允许您登录，这可能会更加困难。在这种情况下，您可以从mysql命令行客户端进行此操作，或者禁用该特性(参见下面)以获得访问权限。但这是不必要的;如果表丢失，phpMyAdmin应该在登录时自动禁用该功能。
Then edit config.inc.php and make sure the values assigned for each table correspond to the table names you just created. See http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_pmadb for the list if you have any question about the default values.
然后编辑config.inc。并确保为每个表分配的值与您刚才创建的表名相对应。如果您对默认值有任何疑问，请参见http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_pmadb。
Disabling the feature outright
Simply edit config.inc.php and remove the line $cfg['Servers'][$i]['tracking']. This will disable the feature entirely so that phpMyAdmin doesn't look for the tracking table.
简单的编辑config.inc。删除行$cfg['Servers'][$i]['tracking']。这将完全禁用该特性，以便phpadmin myadmin不会查找跟踪表。
#1
7
I just tested this with the phpMyAdmin I have installed and even when I deleted the table manually and got the error message, I could clear it up by logging out and logging back in again. So my first suggestion is to make sure your phpMyAdmin is rather up to date, as this feature has received some improvements in recent versions.
我刚刚用我安装的phmypadmin测试了这一点，甚至当我手动删除表并得到错误消息时，我也可以通过注销和再次登录来清除它。因此，我的第一个建议是确保您的phpadmin myis是最新的，因为这个特性在最近的版本中得到了一些改进。
Next, I suggest you log out, clear your browser cache (at least as it relates to the phpMyAdmin page), and log in again.
接下来，我建议您注销，清除浏览器缓存(至少与phpMyAdmin页面相关)，然后再次登录。
You can either fix the table or disable that feature.
您可以修复该表或禁用该特性。
Repairing the phpMyAdmin Configuration Storage
Simply run the create_tables.sql file included in the examples or sql folder of your phpMyAdmin installation. You should edit the file if you wish to use a non-default database name or table names.
简单地运行create_tables。在phpMyAdmin安装的示例或sql文件夹中包含的sql文件。如果希望使用非默认数据库名称或表名，则应该编辑该文件。
This could be more difficult if, for some reason, your phpMyAdmin still doesn't let you log in. In that case, you can either do it from the mysql command line client or disable the feature (see below) in order to gain access. That shouldn't be necessary, though; phpMyAdmin should automatically disable the feature on login if the table is missing.
如果因为某些原因，phpMyAdmin仍然不允许您登录，这可能会更加困难。在这种情况下，您可以从mysql命令行客户端进行此操作，或者禁用该特性(参见下面)以获得访问权限。但这是不必要的;如果表丢失，phpMyAdmin应该在登录时自动禁用该功能。
Then edit config.inc.php and make sure the values assigned for each table correspond to the table names you just created. See http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_pmadb for the list if you have any question about the default values.
然后编辑config.inc。并确保为每个表分配的值与您刚才创建的表名相对应。如果您对默认值有任何疑问，请参见http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_pmadb。
Disabling the feature outright
Simply edit config.inc.php and remove the line $cfg['Servers'][$i]['tracking']. This will disable the feature entirely so that phpMyAdmin doesn't look for the tracking table.
简单的编辑config.inc。删除行$cfg['Servers'][$i]['tracking']。这将完全禁用该特性，以便phpadmin myadmin不会查找跟踪表。