我已经将php版本7.2升级到7.4，现在在myphpadmin面板中出现错误。我正在附加屏幕短传

Question

使用字符串函数。对于降序排序：order by right(week, 4) desc,         substring_index(week, '/', 1) + 0 desc另一种方法不会转换为数字：order by right(week, 4) desc,         length(week) desc,         week descNotice in ./libraries/DisplayResults.php#1229 Trying to access array offset on value of type boolBacktrace./libraries/DisplayResults.php#1349: PMA\libraries\DisplayResults->_getTableHeadersForColumns(array,array,array,array,array,boolean false,string 'SELECT * FROM `wp_postmeta` ',)./libraries/DisplayResults.php#4427: PMA\libraries\DisplayResults->_getTableHeaders(array,array,string 'SELECT * FROM `wp_postmeta` ',array,array,array,boolean false,)./libraries/sql.lib.php#1686: PMA\libraries\DisplayResults->getTable(,array,array,boolean false,)./libraries/sql.lib.php#1980: PMA_getHtmlForSqlQueryResultsTable(,string './themes/pmahomme/img/',NULL,array,boolean true,string '476770',integer 25,NULL,,array,)./libraries/sql.lib.php#2199: PMA_getQueryResponseForResultsReturned(,array,string 'tren_wp2',string 'wp_postmeta',NULL,NULL,,string './themes/pmahomme/img/',string '476770',integer 25,NULL,NULL,NULL,NULL,NULL,string 'SELECT * FROM `wp_postmeta`',NULL,)./libraries/sql.lib.php#2062: PMA_executeQueryAndGetQueryResponse(array,boolean true,string 'tren_wp2',string 'wp_postmeta',NULL,NULL,NULL,NULL,NULL,NULL,string '',string './themes/pmahomme/img/',NULL,NULL,NULL,string 'SELECT * FROM `wp_postmeta`',NULL,NULL,)./sql.php#221: PMA_executeQueryAndSendQueryResponse(array,boolean true,string 'tren_wp2',string 'wp_postmeta',NULL,NULL,NULL,NULL,NULL,NULL,string '',string './themes/pmahomme/img/',NULL,NULL,NULL,string 'SELECT * FROM `wp_postmeta`',NULL,NULL,)

Answer 1

您可以编辑文件/usr/share/phpmyadmin/libraries/DisplayResults.php

在特定行中搜索并添加#XXXX$col_visib[$j]?? false

$col_visib[$j] ?? false

在您的情况下

list($order_link, $sorted_header_html)

    = $this->_getOrderLinkAndSortedHeaderHtml(

        $fields_meta[$i], $sort_expression,

        $sort_expression_nodirection, $i, $unsorted_sql_query,

        $session_max_rows, $comments,

        $sort_direction, $col_visib,

        $col_visib[$j] ?? false

    );

Ps. 关于 Debian 也有效

玩得愉快

Answer 2

您需要添加存储库并运行升级。

步骤

1. sudo add-apt-repository ppa:phpmyadmin/ppa

2. sudo apt update

3. sudo apt upgrade

4. sudo systemctl restart apache2

Answer 3

我已经解决了这个问题，每当你要将PHP版本7.2升级到7.4时，你必须升级所有模块，这意味着PHPMyAdmin，apache等。