/**
* Function to check whether to remember the sorting order or not
*
* @param array $analyzed_sql_results the analyzed query and other variables set
* after analyzing the query
*
* @return boolean
* /
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;
}
2条答案
按热度按时间tsm1rwdh1#
编辑文件/usr/share/phpmyadmin/libraries/sql.lib.php:
替换:
使用:
重新启动服务器:
这应该管用。
2eafrhcq2#
我面临着这个问题。我的php版本是7.2。实际上,这个错误来自phpmyadmin库。库名称是/usr/share/phpmyadmin/libraries/sql.lib.php。在这个文件第614行。所以你需要修改文件
从(&&($analysed\u sql\u results['select\u expr'][0]==''))
到&($analysed\u sql\u results['select\u expr'][0]==''))
或者您可以替换以下完整方法:
我希望这能有所帮助。谢谢您。