I had problem with error The table '#finder_tokens' is full when I was trying to put lots of text in the items.
As suggested on the joomla site forums I turned off ALL Smart search plugins. The error was gone BUT now categories are not sorted at all. Changing the Sorting type of the category in the backend does not do anything at all. Pagination don't work on some modules. It is not working at all even after enabling all Smart search plugins.

I'm on PHP 7.2 (I tried 71, 7.0, still same) on GK Game template and using K2 as article engine.

Also I get this error when I try go access the items over jEvents module:

1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0)) WHERE m.published = 1 AND module = 'mod_k2_eo' LIMIT 1' at line 1

I'm starting to panic since half of my client site is not working.
Any suggestions?

TNX!
Gorast

Hi Gorast,

You can share the credentials of your site and clarify the detailed steps so I can replicate the issue, I will check for you.

Regards

    saguaros
    Should I write them here or there is another email, forum that I should share this?
    tnx

      I have fixed the thin... or rather it fixed himself. I Disabled a module I just installed and set limit of tmp_table_size=128M and max_heap_table_size=128M.
      tnx

      skullmonkey Hi. I've just visited Your site, but was not able to spot the error. Can You please direct me to where to see it?

      Also I do not think mentioned issues are related. My guess is that those are couple of different functions not responding to new PHP version. Can You revert back to previous PHP You were using just to test if those issues are there as well?

        skullmonkey Hi. Och, sorry I missunderstood You. Great to hear that. Closing this thread in such case.

        Write a Reply...
        You need to Login to view replies.