I ran into this same issue with Pantheon as my host. Of course they are absolutely not going to change their database settings for one site so I had to seek a different solution.
The only way I could solve this was to change how those two tables are created by adjusting the size of the VARCHAR
in the CREATE TABLE
from 255
to 191
. The odds that the data in those fields is that big are pretty slim.
Of course it is not ideal to edit the plugin’s code so I am wondering if there is a better way to resolve this?
The lines where that change was made are:
/search-filter/admin/class-search-filter-admin.php
lines 1069-1070, 1092-1093
/search-filter/includes/class-search-filter-activator.php
lines 83-84, 106-107