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.

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

That is a module K2 Extra Order for ordering items but its not even on the page I want to go. I disable it and the error 1064 is gone but sorting still dont work. Regardless of what I put in the backend.

Tnx,
Gorast