- Anna Sophia Schenk(Private) June 3, 2016 at 1:33 pm #47400
Plugin is installed on a multi-site, but trying to activate it, I am receiving the following error:
[03-Jun-2016 11:40:35 UTC] WordPress-Datenbank-Fehler Index column size too large. The maximum column size is 767 bytes. für Abfrage CREATE TABLE wp_63_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 von activate_plugin, do_action(‘activate_search-filter-pro/search-filter-pro.php’), call_user_func_array, activate_search_filter, Search_Filter_Activator->activate, Search_Filter_Activator->db_install, dbDelta
Thanks for any insights in how to fix this!
Thanks and best wishes!Anna Sophia Schenk(Private) June 14, 2016 at 9:45 am #48268
Hi again Trevor,
Thanks for your feedback!
I just activated it for the single WordPress-Instance (not at network level), but I get then the following notice at the top of the Dashboard:
Search & Filter Error: The caching tables are missing – click here to create them
If I then click to create them, I end up on a blank page with the error notice in the log, saying: “Index column size too large“…
Hope we find a solution to get this solved 🙂
Thanks for any help!Trevor Moderator(Private) June 23, 2016 at 11:54 pm #49320
A (kind) user posted a note on Twitter regarding this thread.
Check out the comments on twitter from Justin Mazzi –
Maybe this is affecting you? It was a bit above my head.
You must be logged in to reply to this topic.
Our support hours are:10am - 5pm (GMT), Monday - Friday
Please be aware that tickets opened over the weekend will looked at on Monday.