How to hide lacking phpmyadmin warnings?

Question

On a remote ubuntu 18 server when opening data in phpmyadmin from one of the tables, it displays the warnings and popup window(like that https://imgur.com/a/b5HGGV0), which is very lacking ... Is there a way to ignore/hide them?

Server: Localhost via UNIX socket Server type: MySQL Server version: 5.7.23-0ubuntu0.18.04.1 - (Ubuntu) Protocol version: 10 User: root@localhost Server charset: UTF-8 Unicode (utf8)

Apache/2.4.29 (Ubuntu) Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $ PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation PHP version: 7.2.10-0ubuntu0.18.04.1

phpMyAdmin Version information: 4.6.6deb5

Thank!

Answer 1

The best way to turn off Phpmyadmin errors is to go go config.inc.php and set (or comment out ie removing the // lines in front of the value, which is set to "ask" by default.)

$cfg['SendErrorReports'] = 'never';

Hit save and that's it.

More info https://docs.phpmyadmin.net/en/latest/config.html#cfg_SendErrorReports

Answer 2

This is a common error on this phpMyAdmin version. To solve this open this file

sudo pico /usr/share/phpmyadmin/libraries/sql.lib.php

Find this line:

|| (count($analyzed_sql_results['select_expr'] == 1)

and replace with:

|| (count($analyzed_sql_results['select_expr']) == 1