CODEWITHSUNDEEP
phpmyadminserver
n.morgana
n.morgana

Reputation: 609

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?

Upvotes: 48

Views: 62564

Answers (10)

Kelvin Mboto
Kelvin Mboto

Reputation: 370

Its a php and phpMyAdmin compatibility issue.

Which PHP versions does phpMyAdmin support? https://docs.phpmyadmin.net/en/latest/faq.html#faq1-31 Could be helpful.

Eitherway, you can turn off Error Reporting by adding the rule below to your config.inc.php and your errors will disappear.

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

If you are using WampServer on Windows, you can find the file here C:\wamp64\apps\phpmyadmin5.1.1\config.inc.php.

C:\ is your disk where you have installed wampserver and phpmyadmin5.1.1 is my version. This will be variable based on the phpMyAdmin version in your local server.

For those using Xampp, your file is here C:\xampp\phpMyAdmin/config.inc.php.

Upvotes: 1

Yassine Moumen
Yassine Moumen

Reputation: 105

just add this line $cfg['SendErrorReports'] = 'never'; inside C:\xampp\phpMyAdmin/config.inc.php (FOR WINDOWS!!!!) It's work for me

Upvotes: 0

Sumit Wadhwa
Sumit Wadhwa

Reputation: 3217

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';

Upvotes: 6

Santosh Dangare
Santosh Dangare

Reputation: 755

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

Upvotes: 3

Abhinav Singh
Abhinav Singh

Reputation: 209

Just add this line in /etc/phpmyadmin/config.inc.php

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

Upvotes: 20

LETSCMS Private Limited
LETSCMS Private Limited

Reputation: 534

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)

Upvotes: 28

zhekanax
zhekanax

Reputation: 1258

Append the following line

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

inside /etc/phpmyadmin/config.inc.php file to disable this annoying window.

Upvotes: 101

Ayan Ahmad
Ayan Ahmad

Reputation: 1

no need to do any thing in ubunto just set SQL compatibility mode: =MYSQ40 while importing your tables. it solved my problem

Upvotes: 0

Jignesh Joisar
Jignesh Joisar

Reputation: 15125

if exists then update other wise add this line in /etc/phpmyadmin/config.inc.php file

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

Upvotes: 12

KirtJ
KirtJ

Reputation: 594

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.

Upvotes: 2

Related Questions