Problem with Caching Tables

Trevor

#69325

It is something to do with the way the database is setup on your server.

These (amongst many others) threads discuss this:

https://support.searchandfilter.com/forums/topic/problem-when-trying-to-activate-plugin/

https://support.searchandfilter.com/forums/topic/no-results-found-13/

And also check out these comments on twitter from Justin Mazzi –

https://twitter.com/jmazzi/status/743116381185576960
https://twitter.com/jmazzi/status/743116653764960256

I may need to ask the developer tomorrow. Give me a ‘bump’ tomorrow to do this unless it makes sense to you?

Anonymous

#73047

Same problem here – looks like a major problem and I really hope that you can find a quick solution! Otherwise I would like to have a refund.

Anonymous

#73215

Help yourself or you are lost here!

I have created the tables manually via SQL – seems to work now..

Ross Moderator

#73235

Hi Christian

We’re absolutely happy to help.

The problem with this particular issue is that there is only one “official” way to create table in WordPress from plugins –

https://codex.wordpress.org/Creating_Tables_with_Plugins

We do it this way, so when it fails its nearly impossible to tell why – the real issue in solving is recreating it in the first place.

If you can share some info on your setup, then perhaps I can recreate it and solve.

Would you be able to supply your server config, including DB & PHP versions etc?

Thanks

Anonymous

#73252

Thanks for your reply.

You can provide this -working- solution:

Execute the following SQL:

CREATE TABLE wp_search_filter_cache (
                        id bigint(20) NOT NULL AUTO_INCREMENT,
                        post_id bigint(20) NOT NULL,
                        post_parent_id bigint(20) NOT NULL,
                        field_name varchar(255) NOT NULL,
                        field_value varchar(255) NOT NULL,
                        field_value_num bigint(20) NULL,
                        field_parent_num bigint(20) NULL,
                        term_parent_id bigint(20) NULL,
                        PRIMARY KEY  (id),
            KEY field_name_index (field_name),
            KEY field_value_index (field_value),
            KEY field_value_num_index (field_value_num)
                )

And:

CREATE TABLE wp_search_filter_term_results (
                        id bigint(20) NOT NULL AUTO_INCREMENT,
                        field_name varchar(255) NOT NULL,
                        field_value varchar(255) NOT NULL,
                        field_value_num bigint(20) NULL,
                        result_ids text NOT NULL,
                        PRIMARY KEY  (id),
            KEY field_name_index (field_name),
            KEY field_value_index (field_value),
            KEY field_value_num_index (field_value)

                )

Done!

Ross Moderator

#73818

Thanks for the update still looking into how to solve this permanently.

Best

Anonymous

#150614

Do I add this to the wordpress database?

Trevor

#150622

You will need to use something like phpmyadmin in your control panel, or maybe the ARI Adminer plugin from inside WP Admin.

If you are not confident of doing this, talk to your host and ask them for assistance. If you are using a prefix in your WordPress tables, the code would have to be modified.

Anonymous

#152252

HI. I have the same issue and the sql execution did not work. May I need a different solution for a wordpress multisite environment?

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

[Author]

Posts