不是phpmyadmin出现#1142错误吗？

这个错误很久之前就遇到了，但是却无法解决……

不过就在昨天，在上传图片到刚建立的图站的时候出现了“裂图”，前期遇到的通过重新替换文件解决了但是有一个因为文件指向不正确而不得不去修改数据库。（不想删除数据导致ID不连续，强迫症！！！！）。但是在操作时出现#1142错误，多次无法解决。

但是天无绝人之路，在不断努力下终于在VestaCP的论坛下找到了解决方案。不过那个方案是开启高级功能的……

Fixes for phpmyadmin (configuration storage and some extended features)

If you're tired of the message "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated", this patch for you ;-)

What do you get?
- Tracking pages (version control MySQL table structure and data);
- Bookmarks allow you to save predefined queries and execute them later;
- You can show recently used tables in the navigation panel. It helps you jump across the table directly, without the need to select the database and the table;
- Triggers - code which is automatically executed in response to certain events.
- Designer mode (visually display your tables and a graphical way of creating, editing, and displaying phpMyAdmin relations);
- Relation support (allows relationships (similar to foreign keys) using MySQL-native (InnoDB) methods);
- PDF schema (phpMyAdmin can produce PDF schema of your database);
- You can store comments to describe each column for each table. These will then be shown on the “printview”;
- phpMyAdmin can be configured to remember several things, column order, and column visibility from a database table) for browsing tables;
- Since release 3.4.x phpMyAdmin allows users to set most preferences by themselves and store them in the database;
- Since release 4.2.0 you can save and load query-by-example searches from the Database > Query panel;
- Since release 4.5.0 you can save and load export templates;
- no message about "storage is not completely configured";

_(information source - phpMyAdmin FAQ page)_

Installation:

Universal installer with OS Checker

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma.sh && chmod +x pma.sh && ./pma.sh

或者

sudo wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma.sh && chmod +x pma.sh && ./pma.sh

Ubuntu

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-ubuntu.sh && chmod +x pma-ubuntu.sh && ./pma-ubuntu.sh

或者

sudo wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-ubuntu.sh && sudo chmod +x pma-ubuntu.sh && sudo ./pma-ubuntu.sh

Debian

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-debian.sh && chmod +x pma-debian.sh && ./pma-debian.sh

或者

wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-debian.sh && chmod +x pma-debian.sh && ./pma-debian.sh

CentOS

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-centos.sh && chmod +x pma-centos.sh && ./pma-centos.sh

或者

wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-centos.sh && chmod +x pma-centos.sh && ./pma-centos.sh

What the script does:
- we don't use pwgen for generation password anymore, no extra utilities;
- check wget/curl before downloading dump for database;
- universal installer with os detector by Sergey Rodin (VestaCP - https://vestacp.com);
- options savedsearches / navigationhiding / users / usergroups are set (for 4.x phpmyadmin);
- added table pma__usergroups (for 4.x phpmyadmin);
- sql dump on github now;
- sh files on github too.

Tested on different servers: Debian 7/8, Ubuntu 12/14/15, CentOS 6/7

Support 3.x and 4.x version of phpmyadmin

当然，可以直接访问相关社区获取更多帮助：https://forum.vestacp.com/viewtopic.php?f=14&t=10307

超越自我吧

2017年7月16日