Search & Filter Error: The caching tables are missing

Anonymous

#230164

I get this error. Still looked in the support. Created the two tables with the SQL code. The table prefix of the database is wp_ There is one table named IWP_processed_iterator, so the prefix in capitals.

Trying to create the tables ends in a white screen.

Can you help me?
Thanks in advance!

Jan

Trevor

#230165

If the table prefix is wp_ that is the default, so the guide here SHOULD work:

https://support.searchandfilter.com/forums/topic/problem-with-caching-tables/#post-73252

If this ends in a white screen, your server should be generating a system error (it might be going directly into a log file). You need to find this error.

The only issue I have seen before is that the maximum field size on a user’s server appears to have been limited by their host, which is probably why our plugin could not make the tables in the first place.

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.

Anonymous

#230170

I’m getting an old man I guess 🙁
Made the tables in the wrong database. Doing this in the right database all is working ok!

Thanks

Jan

Trevor

#230173

Thanks for letting me know. I will close this thread for now.

[Author]

Posts