Cannot create Cache Tables

Anonymous

#212532

Hi guys, new user here, and a pretty non-technical one.
I have just installed the developer version of Search & Filter on my site which is hosted on the Pantheon Platform ( ).
When I click to create the cache tables the browser refreshes to a blank white screen.
I checked with the Pantheon folk to see if there is any reason that the module would be blocked from creating those tables, and they have said “NO”.
I checked the PHP error logs on the server and got this…not sure what to do next:
——————-
[26-May-2019 12:17:16 UTC] WordPress database error Index column size too large. The maximum column size is 767 bytes. for query 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)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action(‘wp_ajax_search_filter_build_cache_table’), WP_Hook->do_action, WP_Hook->apply_filters, Search_Filter_Admin->search_filter_build_cache_tables, Search_Filter_Admin->db_install, dbDelta
[26-May-2019 12:17:16 UTC] WordPress database error Index column size too large. The maximum column size is 767 bytes. for query 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 mediumtext NOT NULL,
PRIMARY KEY (id),
KEY field_name_index (field_name),
KEY field_value_index (field_value),
KEY field_value_num_index (field_value)

) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action(‘wp_ajax_search_filter_build_cache_table’), WP_Hook->do_action, WP_Hook->apply_filters, Search_Filter_Admin->search_filter_build_cache_tables, Search_Filter_Admin->db_install, dbDelta

Ross Moderator

#212595

This reply has been marked as private.

Anonymous

#212611

Thanks for letting me know. I watched “The Big Short” last week and am not sure the bankers deserve a holiday unless it’s behind bars…grrr.

I actually had quite a long discussion with Pantheon support, but did not get a lot of detail (in my mind).

Basically I was asking if you guys needed any further info in order to understand what their platform limitations are and they seemed think that the error message I sent to you was sufficient info. I hope that is the case!

Kind regards from Australia…

JBrisbin

Trevor

#212749

You will need to create the tables manually, as the maximum field size appears to have been limited by your host. See this post (but note my comment just below this link), but ignore the part about the uppercase characters in the table prefix:

https://support.searchandfilter.com/forums/topic/caching-tables-missing-creating-opens-an-empty-page/#post-199787

Note: Change the SQL so that the size of the VARCHARs in the CREATE TABLE is reduced from 255 to 191. The odds that the data in those fields is that big are pretty slim.

[Author]

Posts