Forums › Forums › General › Search & Filter Error: The caching tables are missing

Viewing 4 posts - 1 through 4 (of 4 total)
  • Anonymous
    (Private)  January 3, 2020 at 1:06 pm #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
    (Private)  January 3, 2020 at 1:22 pm #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
    (Private)  January 3, 2020 at 1:40 pm #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
    (Private)  January 3, 2020 at 1:52 pm #230173

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

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)