Error The table '#__finder_tokens' is full

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Locked
User avatar
simfomet
Joomla! Intern
Joomla! Intern
Posts: 84
Joined: Mon Feb 02, 2009 8:19 pm

Error The table '#__finder_tokens' is full

Post by simfomet » Tue Aug 23, 2016 10:35 am

Hi everybody,

I have a Joomla site in 3.6.2, recently I have been working in a long article, like other times, last saturday that I would like to complete yesterday. When I save appears a long long error, this is the beginning and a capture:

Can't save with the following error: The table '#__finder_tokens' is full SQL=INSERT INTO `#__finder_tokens` (`term`,`stem`,`common`,`phrase`,`weight`,`context`,`language`) VALUES ('marqués', 'marqués', 0, 0, 0.4667, 2, 'ca'),('no', 'no', 0, 0, 0.1333, 2, 'ca'),('ho', 'ho', 0, 0, 0.1333, 2, 'ca'),('he', 'he', 0, 0, 0.1333, 2, 'ca'),('de', 'de', 0, 0, 0.1333,

Image

I have contact with my host company who increase the php limit and empty the table, finally restore a backup from las saturday. Yesterday Joomla don't save the article but today the article is saved but appears the error (this is the error of the capture).

I don't know what it is and how can I fix?

Thanks.

itoctopus
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4026
Joined: Mon Nov 25, 2013 4:35 pm
Location: Montreal, Canada
Contact:

Re: Error The table '#__finder_tokens' is full

Post by itoctopus » Tue Aug 23, 2016 1:43 pm

Disable all the Smart Search plugins if you're not using them - this will fix the problem immediately as data will no longer be saved to these tables when the Smart search plugins are disabled.
http://www.itoctopus.com - Joomla consulting at its finest
https://twitter.com/itoctopus - Follow us on Twitter

User avatar
simfomet
Joomla! Intern
Joomla! Intern
Posts: 84
Joined: Mon Feb 02, 2009 8:19 pm

Re: Error The table '#__finder_tokens' is full

Post by simfomet » Tue Aug 23, 2016 2:29 pm

Sorry but, you mean all the search plugins that Joomla have? or the smart plugins are concrete ones?

This are the ones I have

Image

UPDATE- I try to disable all the search plugins and appears the same error
Last edited by simfomet on Tue Aug 23, 2016 2:38 pm, edited 1 time in total.

itoctopus
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4026
Joined: Mon Nov 25, 2013 4:35 pm
Location: Montreal, Canada
Contact:

Re: Error The table '#__finder_tokens' is full

Post by itoctopus » Tue Aug 23, 2016 2:36 pm

In English you should search for "Smart" - I'm not sure which language is that but you should search for the equivalent of "Smart" in your language and disable all the "Smart Search" plugins.

The regular search plugins should not be disabled, just the smart search plugins.
http://www.itoctopus.com - Joomla consulting at its finest
https://twitter.com/itoctopus - Follow us on Twitter

User avatar
simfomet
Joomla! Intern
Joomla! Intern
Posts: 84
Joined: Mon Feb 02, 2009 8:19 pm

Re: Error The table '#__finder_tokens' is full

Post by simfomet » Tue Aug 23, 2016 2:44 pm

My language is catalan. I change the language to english and finally find the plugins and disabled. As you said it works!!!

Image

Thank you. Is something about the article is very long or what?

klabog
Joomla! Apprentice
Joomla! Apprentice
Posts: 29
Joined: Wed May 03, 2006 3:21 pm

Re: Error The table '#__finder_tokens' is full

Post by klabog » Tue Apr 11, 2017 5:20 pm

Hello,

just had the same problem and the hint of itoctopus worked for me too. Thanks!
But I would be interested to know what is the reason for this error, which seems to be a bug, and what's the solution. I can't believe, that Joomla is unable to handle large articles with smart search plugins enabled.
Any idea?

Regards, Klaus


Locked

Return to “General Questions/New to Joomla! 3.x”