You might have already worked in phpMyAdmin. PHP 7 or newer version, when you click any table or columns in phpMyAdmin, you might get pop-up error message "Some errors have been detected on the server, please look at the bottom of this window."
This error caused phpMyAdmin not compatibility with PHP 7.2 or newer version.
You can fix this issue with small change in the file /usr/share/phpmyadmin/libraries/sql.lib.php. First, backup sql.lib.php before editing with below command.
sudo cp /usr/share/phpmyadmin/libraries/sql.lib.php /usr/share/phpmyadmin/libraries/sql.lib.php.backup
Now edit sql.lib.php file using nano command.
sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php
Press CTRL + W and find the line
(count($analyzed_sql_results['select_expr'] == 1)
And replace it with:
((count($analyzed_sql_results['select_expr']) == 1)
Press CTRL + X, and then SHIFT + Y and then press ENTER. That's it. The error should have gone.
There is also one other method to ignore the errors in phpMyAdmin.
Open the /etc/phpmyadmin/config.inc.php file in nano editor.
sudo nano /etc/phpmyadmin/config.inc.php
And add the below lines at the end of file
$cfg['SendErrorReports'] = 'never';
Save file and exit. This will ignore and hide all errors in phpMyAdmin.
Hi, My name is Harsukh Makwana. i have been work with many programming language like php, python, javascript, node, react, anguler, etc.. since last 5 year. if you have any issue or want me hire then contact me on [email protected]
How to get One Day Old Records in Laravel using Carbon?
In this article, I will share with you h...How to add elements to the beginning of an array in PHP
Use the PHP array_unshift() fu...Laravel 7 Send Mail Using Markdown Example
Today, markdown laravel 7 mail is our ma...How to Call Multiple JavaScript Functions in onClick Event
Use the addEventListener() Method If...Create CRUD Application Example with REST Web API in Angular
In this article, I will share with you h...