我已经将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 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    );Ps. 关于 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等。