PHP Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result

  • Resolved jaypabs

    (@jaypabs)


    3 years ago

    Hi,

    When I use your plugin, there was an option to “reset keys now” with a checkbox and a description as follows:

    pn_posts has unexpected keys, so you cannot rekey it without resetting it first.
    ?Found an unexpected definition for key type_status_date. It should be ADD KEY type_status_date (post_type, post_status, post_date, ID), but is ADD KEY type_status_date (post_type).

    When I check it and click the Reset Keys Now, the site return a 502 error I think (sorry I forgot the exact description) and an error log as follows:

    2021/11/26 18:32:39 [error] 26151#26151: *112259 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 49.147.197.108, server: mysite.com, request: “GET /wp-admin/tools.php?page=imfs_settings HTTP/1.1”, upstream: “fastcgi://127.0.0.1:9041”, host: “mysite.com”

    Did the plugin successfully execute what it suppose to execute? If no, what is the negative impact of this on the database?

    Then I also execute the Add keys but this time using WP-CLI command “wp index-mysql enable –all” to avoid timeout again when using the UI.

    But after executing it, it returns an error as follows:

    web32@server:~$ wp index-mysql enable --all
PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Index WP MySQL For Speed 1.3.3
Versions MySQL:10.3.16-MariaDB-1:10.3.16+maria~bionic-log WordPress:5.8.2 php:7.4.26
PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
PHP Warning:  mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, bool given in /var/www/clients/client1/web32/web/wp-includes/wp-db.php on line 3402
enable pn_postmeta complete. (6 MySQL commands, 317.34s)

    There are other errors but it was similar to the error above.

    Is this something to worry or this is natural?

    BTW, I execute this on a test website. Just want to make sure that all the errors I see is natural before I execute this on a live site.

    Thank you

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author OllieJones

    (@olliejones)

    Please upload your metadata from the plugin’s About tab.

    And please do wp index-mysql status then wp index-mysql tables

    Then reply to this item showing the output from those commands and the upload id. I’ll take a look.

    Your first operation from the dashboard tool definitely timed out.

    Plugin Author OllieJones

    (@olliejones)

    Version 1.4.1 of the plugin deals with this issue.

    In it, the wp index-mysql reset command is gone.

    You can now use wp index-mysql enable wp_whatever to add the high-performance keys, or wp index-mysql disable wp_whatever to remove keys from another source and restore the WordPress standard keys. Or, if you know you need those keys from another source you can avoid touching that table.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘PHP Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result’ is closed to new replies.