Can't create tables

Trevor

#141841

Hi

At what point did this happen for you? When you installed the plugin, or …

This thread might be an indicator of the issue (and maybe the suggestions might help fix it):

https://stackoverflow.com/questions/30761867/mysql-error-the-maximum-column-size-is-767-bytes

It seems like a database configuration issue, which might mean you need to talk with your host.

Anonymous

#186104

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

Trevor

#186114

Are they using MySQL or MariaDB? If they are running MySQL, do they offer the option of running MariaDB (which is what I always use)?

Anonymous

#186116

They are running MariaDB for all of their hosted sites and we cannot change it. They do not allow changing the configurations of the databases.

Trevor

#186122

Odd, but it is what it is. Thanks for letting us know.

[Author]

Posts