Forums › Forums › General › Cannot create Cache Tables

Viewing 3 posts - 1 through 3 (of 3 total)
  • Ross Moderator
    (Private)  May 28, 2019 at 11:03 am #212595
    This reply has been marked as private.
    Anonymous
    (Private)  May 28, 2019 at 12:00 pm #212611

    Thanks for letting me know. I watched “The Big Short” last week and am not sure the bankers deserve a holiday unless it’s behind bars…grrr.

    I actually had quite a long discussion with Pantheon support, but did not get a lot of detail (in my mind).

    Basically I was asking if you guys needed any further info in order to understand what their platform limitations are and they seemed think that the error message I sent to you was sufficient info. I hope that is the case!

    Kind regards from Australia…

    JBrisbin

    Trevor
    (Private)  May 29, 2019 at 2:37 pm #212749

    You will need to create the tables manually, as the maximum field size appears to have been limited by your host. See this post (but note my comment just below this link), but ignore the part about the uppercase characters in the table prefix:

    https://support.searchandfilter.com/forums/topic/caching-tables-missing-creating-opens-an-empty-page/#post-199787

    Note: 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.

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