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

Question

Notice in ./libraries/DisplayResults.php#1229

 Trying to access array offset on value of type bool

Backtrace

./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

您需要添加存储库并运行升级。脚步sudo add-apt-repository ppa:phpmyadmin/ppasudo apt updatesudo apt upgradesudo systemctl restart apache2

Answer 3

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