Support Forums

Support Forums Forums Search & Filter Pro Problem when trying to activate plugin

This topic is: not resolved
Viewing 9 posts - 1 through 9 (of 9 total)
  • Anna Sophia Schenk

    Hi there,

    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!

    Trevor Moderator

    Hi Anna

    This is an InnoDB error from your server, which is most odd. Are you trying to network activate it or activate it on one site?

    Anna Sophia Schenk

    Thanks Trevor,

    Trying to activate it on a WordPress multisite, so first network activating it. Don’t I have to do this in order to use it on one WordPress instance? Just planning to use it on one site ;)….

    Thanks for any help!

    Trevor Moderator

    It should, I think, be installed at network level but NOT network activated. Then in each site (in your case just the one), you need to activate it.

    Anna Sophia Schenk

    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

    This has to be a server setup issue. I would a lot more information about the server, but I suspect that Ross may need to take a look.

    Anna Sophia Schenk

    Thanks – do you think it the error might be related to the innodb_large_prefix option? Maybe you or someone else has come across something similar. Thanks!

    Trevor Moderator


    Is the server a dedicated or VPS and who is the host?

    Trevor Moderator


    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.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.