phpMyAdmin处理请求时出错错误代码:500错误文本:Internal Server Error [英] phpMyAdmin Error in processing request Error code: 500 Error text: Internal Server Error

问题描述

当我运行phpMyAdmin并单击导出/导入"时，总是出现错误:

When i'm running phpMyAdmin and click to Export/Import I always get an error:

处理请求时出错错误代码:500错误文本:Internal Server Error. 操作系统-Ubuntu 18.04

Error in processing request Error code: 500 Error text: Internal Server Error. OS - Ubuntu 18.04

推荐答案

我遇到了问题.我的php版本是 7.2 .实际上，此错误来自phpmyadmin库.库名称为/usr/share/phpmyadmin/libraries/sql.lib.php .在此文件行中，没有 614 .因此，您需要修改文件

I faced problem. My php version was 7.2. Actually this error comes from a phpmyadmin library. The library name is /usr/share/phpmyadmin/libraries/sql.lib.php. In this file line no 614. So you need to modify the file

发件人&& ($ analyzed_sql_results ['select_expr'] [0] =='*')))

From && ($analyzed_sql_results['select_expr'][0] == '*')))

要&& ($ analyzed_sql_results ['select_expr'] [0] =='*'))

to && ($analyzed_sql_results['select_expr'][0] == '*'))

或者您也可以替换下面的完整方法:

or you can replace full method bellow:

/**
* 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;
}

我希望这会有所帮助.谢谢.

I hope this may help. Thank you.

这篇关于phpMyAdmin处理请求时出错错误代码:500错误文本:Internal Server Error的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！