Volker Wendt(Private) November 8, 2016 at 4:53 pm #69262
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)?
VolkerTrevor Moderator(Private) November 8, 2016 at 10:43 pm #69325
It is something to do with the way the database is setup on your server.
These (amongst many others) threads discuss this:
And also check out these comments on twitter from Justin Mazzi –
I may need to ask the developer tomorrow. Give me a ‘bump’ tomorrow to do this unless it makes sense to you?Ross Moderator(Private) November 30, 2016 at 4:01 pm #73235
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 –
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?
ThanksChristian Schaefer(Private) November 30, 2016 at 4:25 pm #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) )
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!Trevor Moderator(Private) January 4, 2018 at 7:42 pm #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.
The topic ‘Problem with Caching Tables’ is closed to new replies.
Our support hours are:10am - 5pm (GMT), Monday - Friday
Please be aware that tickets opened over the weekend will looked at on Monday.