Usr share phpmyadmin libraries sql lib php

Saved searches

Use saved searches to filter your results more quickly

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable #15574

Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable #15574

Comments

Describe the bug

Each time I switch between tables in a list for a current database I get a warning «Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable»

To Reproduce

Steps to reproduce the behavior:

1. Login to PMA as a database user
2. Choose any of your databases to expand a list of its tables
3. Click on any table to view its contents
4. See warning

Expected behavior

An expected behavior is to see database table contents without any warnings

Screenshots

Server configuration

• Operating system: Linux Mint 19.2
• Web server: Apache 2.4.29
• Database version: 5.7.27
• PHP version: 7.2.24
• phpMyAdmin version: 4.6.6deb5

Client configuration

Additional context

The bug is in the line 613 of a file ./libraries/sql.lib.php
The closing bracket of a count() function is misplaced and should be located before the «= auto»>What we have now:

The text was updated successfully, but these errors were encountered:

Hello @VikMuss this issue is already patched, we are working on packaging a new version on debian (#15236) and if you use Ubuntu you can use our PPA before Ubuntu has the version we build on Debian (#15515)

Thank you for reporting the issue

You’re always welcome, sir! 🙂
Thanks for the information. Have a lovely day

Describe the bug

Each time I switch between tables in a list for a current database I get a warning «Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable»

To Reproduce

1. Login to PMA as a database user
2. Choose any of your databases to expand a list of its tables
3. Click on any table to view its contents
4. See warning

Expected behavior

An expected behavior is to see database table contents without any warnings

Screenshots

Server configuration

• Operating system: Linux Mint 19.2
• Web server: Apache 2.4.29
• Database version: 5.7.27
• PHP version: 7.2.24
• phpMyAdmin version: 4.6.6deb5

Client configuration

Additional context

The bug is in the line 613 of a file ./libraries/sql.lib.php
The closing bracket of a count() function is misplaced and should be located before the «= auto»>What we have now:

How it should be:

Hy it worked for me thank you

Источник

Problem with phpMyAdmin and PHP 7.2: “Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable”

These errors occur if your version of phpMyAdmin is not compatible with your version of PHP. For example, when PHP 7.2 was released, there were compatibility issues with some phpMyAdmin versions in the repository (phpMyAdmin v4.6.x). You can either resolve these issues by manually upgrading phpMyAdmin or you can instead alter some lines of code in phpMyAdmin to temporarily resolve the issue.

sql.lib.php

This error is caused by a line of code in /usr/share/phpmyadmin/libraries/sql.lib.php .

If you don’t want to wait for the repositories to update with the latest version, it is strongly recommended that you manually upgrade to the latest version of phpMyAdmin yourself.

Alternatively, you can make a change to sql.lib.php to temporarily 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

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

Press CTRL + W 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 )

Import/Export issues

If you are also getting an error Warning in ./libraries/plugin_interface.lib.php#551 under import and export tabs:

sudo cp /usr/share/phpmyadmin/libraries/plugin_interface.lib.php /usr/share/phpmyadmin/libraries/plugin_interface.lib.php.bak

sudo nano /usr/share/phpmyadmin/libraries/plugin_interface.lib.php

Press CTRL + W and search for if (! is_null($options) && count($options) > 0)

If not found, try search for if ($options != null && count($options) > 0)

Replace with if (! is_null($options) && count((array)$options) > 0)

Save file and exit. (Press CTRL + X , press Y and then press ENTER )

Upgrading phpMyAdmin

You may be interested in an article I wrote on manually upgrading phpMyAdmin. Since the release of Ubuntu 18.04, the repositories have been slow to update with the latest version of phpMyAdmin causing many compatibility issues, so make sure you have the latest version:

Let me know if this helped. Follow me on Twitter, Facebook and YouTube, or 🍊 buy me a smoothie.

p.s. I increased my AdSense revenue by 200% using AI 🤖. Read my Ezoic review to find out how.

Источник

Как исправить ошибку в phpMyAdmin. «count(): Parameter must be an array or an object that implements Countable»

При установке phpMyAdmin на сервер с Debian 9 с установленной версией php7.3 может появиться ошибка count(): Parameter must be an array or an object that implements Countable . Возможно, в ближайшем будущем разработчики устранят эту ошибку, внеся исправления в официальный дистрибутив, но до сих пор для того, чтобы она не мешала работе, приходится устранять её ручками. Делать это достаточно просто. Как? Рассмотрим ниже.

Код ошибки count(): Parameter must be an array or an object that implements Countable

Данная ошибка выдаётся в виде предупреждения, которое перекрывает весь экран:

Жалобы на работу скрипта plugin_interface.lib.php :

Warning in ./libraries/sql.lib.php#551 count(): Parameter must be an array or an object that implements Countable

Номер строки может варьироваться от версии phpMyAdmin.

Для того, чтобы продолжить работу, можно просто нажать на кнопку «Игнорировать всё» или «Игнорировать», но это не иправит ситуации и диалоговое окно:

На сервере обнаружены некоторые ошибки! Пожалуйста, посмотрите вниз текущего окна.

всё равно будет появляться. Для того, чтобы данное сообщение не возникало, нужно внести небольшие правки в два файла phpMyAdmin в исходный код на сервере.

Исправления в файле sql.lib.php

Первое исправление нужно внести в файл /usr/share/phpmyadmin/libraries/sql.lib.php :

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

и вместо неё вставляем строку

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

Исправления в файле plugin_interface.lib.php

Второе исправление нужно внести в файл /usr/share/phpmyadmin/libraries/plugin_interface.lib.php :

if ($options != null && count($options) > 0) 

if ($options != null && count((array) $options) > 0) 

sudo cp /usr/share/phpmyadmin/libraries/sql.lib.php /usr/share/phpmyadmin/libraries/sql.lib.php.bak 

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

sudo apt install phpmyadmin php-mbstring php-gettext

SELECT user,authentication_string,plugin,host FROM mysql.user;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

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

Заменить (count($analyzed_sql_results[‘select_expr’] == 1) на ((count($analyzed_sql_results[‘select_expr’]) == 1

sudo nano /usr/share/phpmyadmin/libraries/plugin_interface.lib.php

Заменить ($options != null && count($options) > 0) на ($options != null && count((array)$options) > 0)