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