phpmyadmin: Parameter must be an array or an object ...

[^rooker]

[PROBLEM]
Using default phpmyadmin with default mysql on Ubuntu 18.04.4 server, I get the following warning when opening a database and selecting the option "Import":

Warning in ./libraries/plugin_interface.lib.php#551
count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/display_import.lib.php#371: PMA_pluginGetOptions(
string 'Import',
array,
)
./libraries/display_import.lib.php#456: PMA_getHtmlForImportOptionsFormat(array)
./libraries/display_import.lib.php#691: PMA_getHtmlForImport(
string '5fcea82cb224e',
string 'database',
string 'ca_filmdb',
string '',
integer 134217728,
array,
NULL,
NULL,
string '',
)
./db_import.php#43: PMA_getImportDisplay(
string 'database',
string 'ca_filmdb',
string '',
integer 134217728,
)

[SOLUTION]
I remember I already had and fixed this in the past, but I don't find any notes here on the forum...

Ah, here it is:

1) Error in phpmyadmin Warning in ./libraries/plugin_interface.lib.php#551

Patch summary - Edit the following files in "/usr/share/phpmyadmin/libraries":

Code: Select all

--- plugin_interface.lib.php    2020-12-07 22:13:38.036457999 +0000
+++ plugin_interface.lib.php.org        2017-01-23 19:20:26.000000000 +0000
@@ -548,7 +548,7 @@
         $ret .= '<h3>' . PMA_getString($text) . '</h3>';
 
         $no_options = true;
-        if ($options != null && count((array)$options) > 0) {
+        if ($options != null && count($options) > 0) {
             foreach ($options->getProperties()
                 as $propertyMainGroup
             ) {

Then restart apache:

Code: Select all

$ sudo systemctl restart apache2

[^rooker]

And another one:
(See Github: phpmyadmin issue #15574)

Warning in ./libraries/sql.lib.php#613
count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/sql.lib.php#2128: PMA_isRememberSortingOrder(array)
./libraries/sql.lib.php#2079: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'filmdb',
string 'ca_users',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `ca_users`',
NULL,
NULL,
)
./sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'filmdb',
string 'ca_users',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `ca_users`',
NULL,
NULL,
)

Patch:

Code: Select all

--- /usr/share/phpmyadmin/libraries/sql.lib.php 2020-12-08 08:37:50.236870999 +0000
+++ /usr/share/phpmyadmin/libraries/sql.lib.php.org     2020-12-07 22:08:05.645154738 +0000
@@ -610,7 +610,7 @@
             || $analyzed_sql_results['is_analyse'])
         && $analyzed_sql_results['select_from']
         && ((empty($analyzed_sql_results['select_expr']))
-            || (count($analyzed_sql_results['select_expr']) == 1
+            || (count($analyzed_sql_results['select_expr'] == 1)
                 && ($analyzed_sql_results['select_expr'][0] == '*')))
         && count($analyzed_sql_results['select_tables']) == 1;
 }