Php versions - I have upgrade the php version 7.2 to 7.4 now getting error in myphpadmin panel. i am attaching the screenshort

raviraj
January 24, 2020
107 views
2 votes
3 Answers

Notice in ./libraries/DisplayResults.php#1229
 Trying to access array offset on value of type bool

Backtrace

./libraries/DisplayResults.php#1349: PMAlibrariesDisplayResults->_getTableHeadersForColumns(
array,
array,
array,
array,
array,
boolean false,
string 'SELECT * FROM `wp_postmeta` ',
)
./libraries/DisplayResults.php#4427: PMAlibrariesDisplayResults->_getTableHeaders(
array,
array,
string 'SELECT * FROM `wp_postmeta` ',
array,
array,
array,
boolean false,
)
./libraries/sql.lib.php#1686: PMAlibrariesDisplayResults->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,
)

Tags: php ubuntu

Answers

Chosen as BEST ANSWER
- raviraj
- January 26, 2020 at 3:54 pm
- 0 votes
0
I have resolved the issue, whenever you are going to upgrade PHP version 7.2 to 7.4 you must upgrade all module which means PHPMyAdmin, apache et.

(Edit)

- anonymous_user
- February 11, 2020 at 4:27 pm
- 0 votes
0
You need to add the repository and run an upgrade.

Steps
1. sudo add-apt-repository ppa:phpmyadmin/ppa
2. sudo apt update
3. sudo apt upgrade
4. sudo systemctl restart apache2
Login or Signup to reply.

- BitDEVil2K16
- April 28, 2020 at 10:06 pm
- 0 votes
0
You can edit the file /usr/share/phpmyadmin/libraries/DisplayResults.php

in the specific line #XXXX
Search $col_visib[$j] and add ?? false

$col_visib[$j] ?? false

in your case
```
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. On Debian works also

have fun
Login or Signup to reply.