时间戳

首页 > 解决方案 > 我已将 php 版本 7.2 升级到 7.4，现在在 myphpadmin 面板中出现错误。我附上屏幕短片

php - 我已将 php 版本 7.2 升级到 7.4，现在在 myphpadmin 面板中出现错误。我附上屏幕短片

问题描述

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,
)

在此处输入图像描述

标签： phpubuntu

解决方案

你可以编辑文件/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 上也可以

玩得开心

推荐阅读