'PHPmyadmin pop-up error notice keeps appearing when clicking on columns of databases
I keep receiving a pop-up error, when clicking on columns in databases:
Some errors have been detected on the server, please look at the bottom of this window.
Notice in .\libraries\tbl_columns_definition_form.inc.php#55 Undefined variable: server
Backtrace
.\libraries\structure.lib.php#2433: include(.\libraries\tbl_columns_definition_form.inc.php) .\tbl_structure.php#45: PMA_displayHtmlForColumnChange( string 'registration', string 'users', NULL, string 'tbl_structure.php', )
How to solve this matter?
Solution 1:[1]
Append the following line
$cfg['SendErrorReports'] = 'never';
inside /etc/phpmyadmin/config.inc.php file to disable this annoying window.
Solution 2:[2]
This error is caused by a line of code in /usr/share/phpmyadmin/libraries/sql.lib.php.
It seems when I installed phpMyAdmin using apt, the version in the repository (phpMyAdmin v4.6.6) is not fully compatible with PHP 7.2. There is a newer version available on the official website (v4.8 as of writing), which fixes these compatibility issues with PHP 7.2.
You can download the latest version and install it manually or wait for the repositories to update with the newer version.
Alternatively, you can make a small change to sql.lib.php to fix the error.
Firstly, backup sql.lib.php before editing.
sudo cp /usr/share/phpmyadmin/libraries/sql.lib.php /usr/share/phpmyadmin/libraries/sql.lib.php.bak
Edit sql.lib.php using vi:
sudo vi /usr/share/phpmyadmin/libraries/sql.lib.php
Using nano:
sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php
Press CTRL + W (for nano) or ? (for vi/vim) and search for:
(count($analyzed_sql_results['select_expr'] == 1)
Replace it with:
((count($analyzed_sql_results['select_expr']) == 1)
Save file and exit. (Press CTRL + X, press Y and then press ENTER for nano users / hit ESC then type :wq and press ENTER)
Solution 3:[3]
Just add this line in /etc/phpmyadmin/config.inc.php
$cfg['SendErrorReports'] = 'never';
Solution 4:[4]
if exists then update other wise add this line in /etc/phpmyadmin/config.inc.php file
$cfg['SendErrorReports'] = 'never';
Solution 5:[5]
Strangely, none of the above solutions worked for me.
So I had to edit this file:
sudo vim /usr/share/phpmyadmin/libraries/common.inc.php
Which is getting included in every phpmyadmin script files.
And place this line at the very bottom:
$cfg['SendErrorReports'] = 'never';
Solution 6:[6]
I just solved the same problem, every time I enter on my database tables that errors occurs. It seems that PhpMyadmin is not compatible with php version. I have php 7.3 upgrade from 7.0 and NOW PhpMyadmin 4.8.5 from 4.6.
Solution 7:[7]
for me it worked....
just add this line $cfg['SendErrorReports'] = 'never';
inside C:\xampp\phpMyAdmin/config.inc.php
(FOR WINDOWS!!!!)
and /etc/phpmyadmin/config.inc.php for other
Solution 8:[8]
no need to do any thing in ubunto just set SQL compatibility mode: =MYSQ40 while importing your tables. it solved my problem
Solution 9:[9]
just add this line $cfg['SendErrorReports'] = 'never'; inside C:\xampp\phpMyAdmin/config.inc.php
(FOR WINDOWS!!!!)
It's work for me
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow