Problem with Caching Tables

Ross Moderator

#152266

Hi Nils

The code should be the same on multisite, however, you must use the correct multisite prefix for your table name.

So
CREATE TABLE wp_search_filter_cache (
would become
CREATE TABLE wp_1_search_filter_cache (

and
CREATE TABLE wp_search_filter_term_results
would become
CREATE TABLE wp_1_search_filter_term_results

You would need to repeat this for each site in your multisite and use the correct ID of the multisite in the table names.

I imagine this must be a pain getting setup especially with a new plugin.

And on personal level I would like to get this solved once and for all.

Would you be willing to let me do some testing (early next week) on your (dev) site to try to resolve this issue within our plugin?

Thanks

Anonymous

#180699

Thanks! (still) works, don’t forget to change the prefix if necessary.

[Author]

Posts