Error 1114 The table 'jospk_finder_tokens' is full when I try to save a product

  • Posts: 67
  • Thank you received: 5
  • Hikashop Business
4 days 15 hours ago #368277

-- url of the page with the problem -- : www.mirablebeauty.com/
-- HikaShop version -- : 6.1.0
-- Joomla version -- : 5.3.3
-- PHP version -- : 8.4
-- Browser(s) name and version -- : All
-- Error-message(debug-mod must be tuned on) -- : 1114 The table 'jospk_finder_tokens' is full

Hi,
in hikashop product administration, when I save a product, it appers the following error message:
"1114 The table 'jospk_finder_tokens' is full"
It happens in 2 sites with different joomla and php versions (one has Joomla 5.3.3 and PHP 8.4. the other is a older site with Joomla 3.5 and PHP 7.4).
Despite the message, the product is still saved.
Thank you

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 84243
  • Thank you received: 13687
  • MODERATOR
4 days 3 hours ago #368278

Hi,

This indicates that you have a problem with Joomla's smart search and your database.
There is an issue about this here:
github.com/joomla/joomla-cms/pull/36749
It says that a patch has been added to improve things in Joomla 4.
Based on www.joomshaper.com/forum/question/20343 it says that you need to increase the max_heap_table_size parameter of your MySQL.

Unfortunately, HikaShop is not involved in this so we can't do much from our end for this issue.

Please Log in or Create an account to join the conversation.

  • Posts: 67
  • Thank you received: 5
  • Hikashop Business
3 days 23 hours ago #368284

Thank you,
I've written to the hosting provider to increase the parameter.

The following user(s) said Thank You: nicolas

Please Log in or Create an account to join the conversation.

Time to create page: 0.050 seconds
Powered by Kunena Forum