使用字符串函數。對于降序排序：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,)
3 回答
哆啦的時光機
TA貢獻1779條經驗 獲得超6個贊
您可以編輯文件/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 也有效
玩得愉快
繁星淼淼
TA貢獻1775條經驗 獲得超11個贊
您需要添加存儲庫并運行升級。
步驟
sudo add-apt-repository ppa:phpmyadmin/ppasudo apt updatesudo apt upgradesudo systemctl restart apache2
- 3 回答
- 0 關注
- 163 瀏覽
添加回答
舉報
0/150
提交
取消