mysqli_num_fields() expects parameter 1 to be mysqli_result, boolean

[mikeacton]

Folks,

Love the products so much I purchased the PRO calendar and PLUS tickets. I’ve also now confirmed I have a plugin conflict with W3 Total Cache and I have been reading everything in your forum and on the Internet to attempt to solve the error message I get across the top of the calendar page.

“Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, boolean given in /wp-includes/wp-db.php on line 3182”

I followed these steps https://tangerinemoons.com/using-wordpress-w3-total-cache-modern-tribes-event-calendar/ and even tried the suggestion from Yusef on August 14th. I like that less invasive approach but it did not resolve the specific issue I am having but was worth a shot.

I can also confirm that when W3 Total is active, the issue does not present itself when viewing the default events page from the admin login, and I am guessing that is because it is not cached.

I will be attaching to a separate reply the php error log which lists specific errors.

Verified cross-platform.

Any help is greatly appreciated. Before I can roll this new feature out for 2018 on this site I need to solve this puzzle, and then I have one more site which will most likely demonstrate the same issue as they are both using W3 Total Cache.

Thank you in advance.

Mike

WordPress 4.9
The Events Calendar PRO Version 4.4.19
W3 Total Cache Version 0.9.5.4
All plugins and themes up to date.

[mikeacton]

This reply is private.

[Jaime Marchwinski]

Hi Mike,

Thanks so much for reaching out and for starting off with all of that info!

As a first step, I see a few things on your site.  As you mentioned the conflict with W3 Cache, you may also be interested in exploring more about minification.  You will want to turn off magnification in all situations.  This may also be something through your theme as well:

https://theeventscalendar.com/knowledgebase/problems-with-minification/

In addition, there are a number of mixed content error messages appearing in the console, so I would recommend installing and configuring a plugin, like this one, in order to resolve those errors.

If the issue still persists, if you haven’t already done so, I would recommend switching to a default theme and seeing if the error message disappears.

Let me know how it goes!

 

Thanks,

Jaime

[mikeacton]

Jamie,

Thank you so much for getting back to me. I have followed your suggestions and read the post you recommended.

Here is what I found:

1. By reactivating W3 Total Cache then methodically going down the list of caches turning each off one at a time and re-testing my site in Incognito, I discovered that the Database Cache (Enable database caching to reduce post, page and feed creation time) was causing the error to be displayed.
2. Turning all caches back on, including Minify, but excluding Database, the error message is still gone.
3. However, I have retained the Minify exclusion settings as defined by Yusef in the tangerinemoons.com post and so far it has worked fine. See attached image.

My hunch is that the database caching using the default “Disk” setting could be complicated by the db server being on a different server altogether, but I have not troubleshot further to confirm/deny this possibility.

Again, thank you so much. I’ve documented herein so that others may avoid delays and pain. I love your products!

Best regards,

Mike

[Jaime Marchwinski]

Hi Mike,

Glad we could help, and thanks for providing that extra info!  You are welcome back in our support forums any time!

For now, I am going to close this thread.

Have a great week!

[Author]

Posts