Jump to content

Edit History

dcabrol

dcabrol


Add version of prestashop in the message and remove <br /> <br /> <pre> from error

Hello, I allow myself to leave the topic, following an error which can be the source of error for others.

In my case it was impossible to search from the search bar in the shop. (prestashop 1.7.4.2)

After adding DEBUG mode (thanks PCQUATRO), we got this error: 

Fatal error: Uncaught Failed to read auto-increment value from storage engine INSERT IGNORE INTO wd_search_word (id_lang, id_shop, word) VALUES ....


We have therefore reached the identifier limit available in the table ....
We are using a cron which launches the url indicated by prestashop to reconstruct the index, has anyone had this problem?

For the solution we used this sql request: 

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE `MYPREFIXTABLE_search_index`;
TRUNCATE `MYPREFIXTABLE_search_word`;
SET FOREIGN_KEY_CHECKS = 1;


Then we rebuilt the index on the site and the search bar works again.

I hope it will help others, but I do not understand why prestashop does not manage the identifiers, this problem will come back. Are we doing something wrong?

dcabrol

dcabrol


Add version of prestashop in the message

Hello, I allow myself to leave the topic, following an error which can be the source of error for others.

In my case it was impossible to search from the search bar in the shop. (prestashop 1.7.4.2)

After adding DEBUG mode (thanks PCQUATRO), we got this error: 

Fatal error: Uncaught Failed to read auto-increment value from storage engine <br /> <br /> <pre> INSERT IGNORE INTO wd_search_word (id_lang, id_shop, word) VALUES ....


We have therefore reached the identifier limit available in the table ....
We are using a cron which launches the url indicated by prestashop to reconstruct the index, has anyone had this problem?

For the solution we used this sql request: 

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE `MYPREFIXTABLE_search_index`;
TRUNCATE `MYPREFIXTABLE_search_word`;
SET FOREIGN_KEY_CHECKS = 1;


Then we rebuilt the index on the site and the search bar works again.

I hope it will help others, but I do not understand why prestashop does not manage the identifiers, this problem will come back. Are we doing something wrong?

dcabrol

dcabrol

Hello, I allow myself to leave the topic, following an error which can be the source of error for others.

In my case it was impossible to search from the search bar in the shop.

After adding DEBUG mode (thanks PCQUATRO), we got this error: 

Fatal error: Uncaught Failed to read auto-increment value from storage engine <br /> <br /> <pre> INSERT IGNORE INTO wd_search_word (id_lang, id_shop, word) VALUES ....


We have therefore reached the identifier limit available in the table ....
We are using a cron which launches the url indicated by prestashop to reconstruct the index, has anyone had this problem?

For the solution we used this sql request: 

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE `MYPREFIXTABLE_search_index`;
TRUNCATE `MYPREFIXTABLE_search_word`;
SET FOREIGN_KEY_CHECKS = 1;


Then we rebuilt the index on the site and the search bar works again.

I hope it will help others, but I do not understand why prestashop does not manage the identifiers, this problem will come back. Are we doing something wrong?

×
×
  • Create New...