我已经上传了备份到一个表，打开表我看到这个:
Warning in ./libraries/sql.lib.php#601
count(): Parameter must be an array or an object that implements Countable
Backtrace
./libraries/sql.lib.php#2038: PMA_isRememberSortingOrder(array)
./libraries/sql.lib.php#1984: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'alternativegirls',
string 'tgp_photo',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tgp_photo`',
NULL,
NULL,
)
./sql.php#216: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'alternativegirls',
string 'tgp_photo',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tgp_photo`',
NULL,
NULL,
)
./index.php#53: include(./sql.php)
在phpMyAdmin……
PHP是7.2，服务器是Ubuntu 16.04，昨天安装的。
我看到一些人在他们的代码中有这个错误，但我没有发现任何人在phpMyAdmin中收到它…
我该怎么办?这是我的错误吗?phpmyadmin错误?等待更新?回到PHP 7.1?
在ubuntu-18.04上执行以下步骤:
步骤1)定位sql.lib.php
它将显示如下内容:
/usr/share/phpmyadmin/libraries/sql.lib.php
步骤2)打开终端(Alt t)并写入:
sudo /usr/sbin/pma-configure
步骤3)执行gedit /usr/share/phpmyadmin/libraries/sql.lib.php
和搜索下面的函数:
function PMA_isRememberSortingOrder($analyzed_sql_results)
{
return $GLOBALS['cfg']['RememberSorting']
&& ! ($analyzed_sql_results['is_count']
|| $analyzed_sql_results['is_export']
|| $analyzed_sql_results['is_func']
|| $analyzed_sql_results['is_analyse'])
&& $analyzed_sql_results['select_from']
&& ((empty($analyzed_sql_results['select_expr']))
|| (count($analyzed_sql_results['select_expr'] == 1)
&& ($analyzed_sql_results['select_expr'][0] == '*')))
&& count($analyzed_sql_results['select_tables']) == 1;
}
步骤4)将上述功能替换为:
function PMA_isRememberSortingOrder($analyzed_sql_results)
{
return $GLOBALS['cfg']['RememberSorting']
&& ! ($analyzed_sql_results['is_count']
|| $analyzed_sql_results['is_export']
|| $analyzed_sql_results['is_func']
|| $analyzed_sql_results['is_analyse'])
&& $analyzed_sql_results['select_from']
&& ((empty($analyzed_sql_results['select_expr']))
|| (count($analyzed_sql_results['select_expr']) == 1)
&& ($analyzed_sql_results['select_expr'][0] == '*'))
&& count($analyzed_sql_results['select_tables']) == 1;
}
步骤4)在终端上保存并关闭文件和以下命令
sudo /usr/sbin/pma-secure
步骤5)sudo service mysql reload
步骤6)sudo service apache2重载
这对我有用。
古德勒克
我认为最好的选择是将Phpmyadmin更新到一个已经修复了这个问题的版本。
在它作为deb发布之前，你可以像@crimson-501那样做，我将在下面复制:
Your first step is to install PMA (phpMyAdmin) from the official Ubuntu repo: apt-get install phpmyadmin.
Next, cd into usr/share directory: cd /usr/share.
Third, remove the phpmyadmin directory: rm -rf phpmyadmin.
Now we need to download the latest PMA version onto our system (Note that you need wget: apt-get install wget): wget -P /usr/share/ "https://files.phpmyadmin.net/phpMyAdmin/4.9.4/phpMyAdmin-4.9.4-english.zip"
Let me explain the arguments of this command, -P defines the path and "the link.zip" is currently (7/17/18) the latest version of PMA. You can find those links HERE.
For this next step you need unzip (apt-get install unzip): unzip phpMyAdmin-4.9.4-english.zip. We just unzipped PMA, now we will move it to it's final home.
Lets use the cp (copy) command to move our files! Note that we have to add the -r argument since this is a folder. cp -r phpMyAdmin-4.9.4-english phpmyadmin.
Now it's time to clean up: rm -rf phpMyAdmin-4.9.4-english.
继续阅读!
在登录到PMA之后，您现在可能会注意到两个错误。
the configuration file now needs a secret passphrase (blowfish_secret). phpmyadmin
The $cfg['TempDir'] (./tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.
然而，这些问题相对容易解决。对于第一个问题，你所要做的就是抓取你选择的编辑器，编辑/usr/share/phpmyadmin/config.inc.php，但有一个问题，我们删除了它!没关系，你要做的就是:cd /usr/share/phpmyadmin & cp config.sample.inc.php config.inc.php。
现在我们将添加河豚秘密!Nano config.inc.php并从该页底部附近复制动态生成的秘密:https://www.question-defense.com/tools/phpmyadmin-blowfish-secret-generator。
示例phpMyAdmin Blowfish秘密变量入口:
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = '{^QP+-(3mlHy+Gd~FE3mN{gIATs^1lX+T=KVYv{ubK*U0V';
/* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
现在保存并关闭文件。
现在我们将为PMA创建一个tmp目录:mkdir tmp & chown -R www-data:www-data /usr/share/phpmyadmin/tmp。最后一个命令允许Apache web服务器拥有tmp目录并编辑它的内容。
打开/usr/share/phpmyadmin/libraries/sql.lib.php
sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php
按ctrl+w搜索(count($analyzed_sql_results['select_expr'] ==
1)
Find: count($analyzed_sql_results['select_expr'] == 1)
Replace With: (count($analyzed_sql_results['select_expr']) == 1)
重新启动服务器
sudo service apache2 restart
此外，如果你仍然面临同样的问题，那么就做下面的事情。
打开/usr/share/phpmyadmin/libraries/plugin_interface.lib.php文件
sudo nano /usr/share/phpmyadmin/libraries/plugin_interface.lib.php
查找:if ($options != null && count($options) > 0) {
Ctrl+w : if ($options != null && count($options) > 0) {
替换为以下代码
if ($options != null && count((array)$options) > 0) {
现在保存并重新启动服务器
sudo /etc/init.d/apache2 restart