我已将 php 版本 7.2 升级到 7.4，现在在 myphpadmin 面板中出现错误。

Question

Notice 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

    );

附言。在 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 等。