Support Forums

Support Forums Forums Search & Filter Pro Problem with Caching Tables

This topic is: resolved

This topic contains 11 replies, has 7 voices, and was last updated by  Lourens 1 year, 3 months ago.

Viewing 10 posts - 1 through 10 (of 12 total)
  • Volker Wendt
    #69262

    Hello,

    The Plugins shows an error message: Search & Filter Error: The caching tables are missing – click here to create them.
    When i try to create the tables, there is only a white screen with no message.

    If there is a problem with the hoster, please tell me, where the plugin trys to write the tables to?

    Could it be a problem with the WordPress- or PHP Version (i´m using WP 4.61 and PHP 7)?

    Thank you,

    Volker

    Trevor Moderator
    #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?

    Christian Schaefer
    #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.

    Christian Schaefer
    #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

    Christian Schaefer
    #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

    Steffen Rasile
    #150614

    Do I add this to the wordpress database?

    Trevor Moderator
    #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.

    Nils Jischewsky
    #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?

Viewing 10 posts - 1 through 10 (of 12 total)

The topic ‘Problem with Caching Tables’ is closed to new replies.