Posted on May 6, 2019 - 31 sec read
At the time of this writing the latest version of phpmyadmin contains a very annoying bug. Luckily there is a really simple fix available for this issue.
I suggest you to backup the file
libraries/sql.lib.php in the root directory of your phpmyadmin installation so you can restore it if anything goes wrong while running the following command.
sudo sed -i "s/|\s*\((count(\$analyzed_sql_results\['select_expr'\]\)/| (\1)/g" /usr/share/phpmyadmin/libraries/sql.lib.php
This command fixes the syntax error in the given file. After this command finished successfully, reload phpmyadmin. If everything went right, the error is gone!