หน้าเว็บ

วันอาทิตย์ที่ 24 พฤศจิกายน พ.ศ. 2562

PHPmyadmin Error เพราะ Bug php.ini ที่พบตอนจะ Restore

PHPmyadmin Error เพราะ Bug php.ini ที่พบตอนจะ Restore Database พบ 2 Case
1.
Warning in ./libraries/plugin_interface.lib.php#551
count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/display_import.lib.php#371: PMA_pluginGetOptions(
string 'Import',
array,
)
./libraries/display_import.lib.php#456: PMA_getHtmlForImportOptionsFormat(array)
./libraries/display_import.lib.php#691: PMA_getHtmlForImport(
string '5dd649bc92f3e',
string 'database',
string 'sci_phpbb',
string '',
integer 8388608,
array,
NULL,
NULL,
string '',
)
./db_import.php#43: PMA_getImportDisplay(
string 'database',
string 'sci_phpbb',
string '',
integer 8388608,
)

วิธีแก้
  1. nano /usr/share/phpmyadmin/libraries/plugin_interface.lib.php
  1. ctrl+w
count($options)
if ($options != null && count($options) > 0) {
แก้เป็น
if ($options != null && count((array)$options) > 0) {

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

Backtrace

./libraries/sql.lib.php#2128: PMA_isRememberSortingOrder(array)
./libraries/sql.lib.php#2079: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'sci_phpbb',
string 'phpbb_blogs_plugins',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `phpbb_blogs_plugins`',
NULL,
NULL,
)
./sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'sci_phpbb',
string 'phpbb_blogs_plugins',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `phpbb_blogs_plugins`',
NULL,
NULL,
)

วิธีแก้
  1. nano /usr/share/phpmyadmin/libraries/sql.lib.php

go to line 613
|| (count($analyzed_sql_results['select_expr'] == 1)
&& ($analyzed_sql_results['select_expr'][0] == '*')))
&& count($analyzed_sql_results['select_tables']) == 1;
แทนที่ด้วย
|| count($analyzed_sql_results['select_expr']) == 1
&& ($analyzed_sql_results['select_expr'][0] == '*'))
&& count($analyzed_sql_results['select_tables']) == 1;

แล้ว Restart apache
  1. /etc/init.d/apache2 restart


Fix Bug Phpmyadmin [plugin_interface.lib.php] + Php7.2 + Ubuntu 18.04
http://libtechnophile.blogspot.com/2019/08/m.html
https://medium.com/@chaloemphonthipkasorn/%E0%B9%81%E0%B8%81%E0%B9%89-bug-phpmyadmin-php7-2-ubuntu-16-04-92b287090b01

ไม่มีความคิดเห็น:

แสดงความคิดเห็น