By Oswaldo Mendes on Thursday, 06 June 2019
Posted in General Issues
Replies 4
Likes 0
Views 781
Votes 0
Hello,
every time I update an article through the control panel, I get an error message: The table#_finder_tokens is full
(see attached image)
Can you help me solve this?
Tks
Oswaldo
Regarding this error The table '#__finder_tokens' is full mean is this table #__finder_tokens already disk space is full.

If your site do not allow user to search your blog post through your site Joomla search module/page, you can disable this smart search finder plugin 'Smart Search - EasyBlog Posts' from your site backend > Extension > plugin manager.

In other word, if you would like your site user able to search your blog post, you have to take a look this thread and see whether can do something about it from your database. https://dev.mysql.com/doc/refman/5.7/en/full-table.html , you can try consult with your webhosting provider regarding this as well.
·
Friday, 07 June 2019 09:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

I have a similar problem. I get the error message "the table '#__finder_tokens' is full" when I try to open a specific article on the frontend. There is no "searching" involved.
I have created a new blog entry in the same category and this doesn't raise an error.

My site is in test mode, thus I don't run with 1000s of blog entries, perhaps 50. I don't get the point that a table is running over its limits.

- What is the purpose of this table?
- What are the limitations, which raise this error?

Kind regards
Andre
·
Wednesday, 24 July 2019 05:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Additionally, I have found this table in the DB. It has 24,888 entries. This doesn't sound like a huge table...:-)
Where is the limitation of additional entries?

Kind regards
Andre
·
Wednesday, 24 July 2019 06:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Andre,

Currently I am not really sure what is the whole purpose of this Joomla #__finder_tokens table, but it related with the Joomla smart search functionality.

And this table is not only store 1 extension data, you can check this from your site backend > plugins > filter type to finder (screenshot : https://take.ms/xhK7G) so you can see which finder plugin is enable now, mean user can able to search all these data through Joomla smart search in frontend.

I found one of the thread similar with this issue from Joomla forum https://forum.joomla.org/viewtopic.php?t=954273 , perhaps you can try increase these following directives from your mysql my.cnf file and see how it goes?

- max-heap-table-size 64MB
- tmp-table-size 64MB


You can consult with your webhosting provider regarding this and see where is your mysql my.cnf file location.
·
Wednesday, 24 July 2019 10:26
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post