Naturel Deluxe Posted October 10, 2018 Share Posted October 10, 2018 Hi! Our prestashop (1.7.2.4) is not indexing any product anymore ... I don't know how to fix this issue.... We didn't modify any core files... It was working several months without a problem. But we did delete the entire catalog & did a re-upload, this time with more combinations, less simple products... Debug modus, doens't tell me anything, no errors where displayed. I think the problem is in the msql d-base, I checked the ps_search & there are thousands of product related to the table. But I don't know what's save to do... Can I just clear the tables related to search? Thanks in advance Link to comment Share on other sites More sharing options...
dinesh badrukhiya Posted October 17, 2018 Share Posted October 17, 2018 Hello, You can try to re-build the entire index. Go to: Back-office > Configure > General > Search and click on re-build the entire index. 3 Link to comment Share on other sites More sharing options...
efburgos Posted August 26, 2019 Share Posted August 26, 2019 On 10/17/2018 at 1:43 PM, dinesh badrukhiya said: Hello, You can try to re-build the entire index. Go to: Back-office > Configure > General > Search and click on re-build the entire index. I have the same problem but with prestashop 1.7.5.2 I tried reindexing and nothing I can't find a solution. Can someone help me? Link to comment Share on other sites More sharing options...
prestol Posted October 31, 2019 Share Posted October 31, 2019 i need help too how can fix it? Link to comment Share on other sites More sharing options...
lototo Posted November 1, 2019 Share Posted November 1, 2019 Enable Debug mode in your presta preferences and try to re-index. Link to comment Share on other sites More sharing options...
prestol Posted November 1, 2019 Share Posted November 1, 2019 debug mode does not work on this page, any clues as to why? Link to comment Share on other sites More sharing options...
lototo Posted November 1, 2019 Share Posted November 1, 2019 Some thing broken in core, obvious thats why re-index is not work. Check the error logs on server Link to comment Share on other sites More sharing options...
prestol Posted November 4, 2019 Share Posted November 4, 2019 (edited) i think its something with multistore, several of my categories are not showing up in plugins that read category informtion either guess ill reisntall prestashop and migrate my data and not turn on multistore Edited November 4, 2019 by prestol (see edit history) Link to comment Share on other sites More sharing options...
PCQUATRO Posted November 4, 2019 Share Posted November 4, 2019 On 10/10/2018 at 11:00 PM, Naturel Deluxe said: Hi! Our prestashop (1.7.2.4) is not indexing any product anymore ... I don't know how to fix this issue.... We didn't modify any core files... It was working several months without a problem. But we did delete the entire catalog & did a re-upload, this time with more combinations, less simple products... Debug modus, doens't tell me anything, no errors where displayed. I think the problem is in the msql d-base, I checked the ps_search & there are thousands of product related to the table. But I don't know what's save to do... Can I just clear the tables related to search? Thanks in advance You cat allways try to delete the cache by going to BackOffice -> Performance -> clear cache and or deleting trough FTP the contents of /var/cache/prod... You can also use the free tool that is on Modules Catalog "Prestashop Cleaner" (green icon). You can also try a database repair trough your CPANEL. Than try to reindex again. Remember to allways BACKUP EVERYTHING... Best Regards Link to comment Share on other sites More sharing options...
prestol Posted November 4, 2019 Share Posted November 4, 2019 thanks but we dont use cpanel im very hestiant to use cleaner tools.. Link to comment Share on other sites More sharing options...
dcabrol Posted April 8, 2020 Share Posted April 8, 2020 (edited) 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? Edited April 8, 2020 by dcabrol Add version of prestashop in the message and remove <br /> <br /> <pre> from error (see edit history) Link to comment Share on other sites More sharing options...
DoGGoD Posted June 15, 2020 Share Posted June 15, 2020 On 4/8/2020 at 12:15 PM, dcabrol said: 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? Hi! Thanks! It worked for me. My faceted search got an upgrade and after that my search bar stopped working. Running on prestashop 1.7.6.5 Link to comment Share on other sites More sharing options...
Antakarana Posted August 27, 2020 Share Posted August 27, 2020 (edited) Hi!!! I have a similar problem ona a PS 1.7.6.7 shop search bar doesnt work... actualy it only shows manufacturer results, but it doesnt show any product results. When activating debug mode it shows this error code when I perform any search: [PrestaShopDatabaseException] Key 'id_product' doesn't exist in table 'product_attribute_shop'<br /><br /><pre>SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` manufacturer_name ,( SELECT SUM(weight) FROM prstshp_search_word sw LEFT JOIN prstshp_search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = 1 AND sw.id_shop = 1 AND si.id_product = p.id_product AND (sw.word LIKE '%moet%') ) position, DATEDIFF( p.`date_add`, DATE_SUB( "2020-08-27 00:00:00", INTERVAL 150 DAY ) ) > 0 new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute FROM prstshp_product p INNER JOIN prstshp_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN `prstshp_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `prstshp_product_attribute_shop` product_attribute_shop FORCE INDEX (id_product) ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prstshp_manufacturer` m FORCE INDEX (PRIMARY) ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `prstshp_image_shop` image_shop FORCE INDEX (id_product) ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `prstshp_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE p.`id_product` IN (3718,4214,5271,5313,5585,5586,5587) GROUP BY product_shop.id_product ORDER BY position desc LIMIT 0,24</pre> at line 769 in file classes/db/Db.php DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 613 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 374 - classes/Search.php] - [3 Arguments] SearchCore::find - [line 85 - src/Adapter/Search/SearchProductSearchProvider.php] - [9 Arguments] PrestaShop\PrestaShop\Adapter\Search\SearchProductSearchProvider->runQuery - [line 308 - classes/controller/ProductListingFrontController.php] - [2 Arguments] ProductListingFrontControllerCore->getProductSearchVariables - [line 580 - classes/controller/ProductListingFrontController.php] ProductListingFrontControllerCore->doProductSearch - [line 82 - controllers/front/listing/SearchController.php] - [2 Arguments] SearchControllerCore->initContent - [line 292 - classes/controller/Controller.php] ControllerCore->run - [line 515 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Can anybody help me?? 🙄 thanks in advace Edited August 27, 2020 by Antakarana (see edit history) Link to comment Share on other sites More sharing options...
lototo Posted August 28, 2020 Share Posted August 28, 2020 Add index to database product_attribute_shop table Key 'id_product' doesn't exist in table 'product_attribute_shop' Link to comment Share on other sites More sharing options...
Antakarana Posted September 3, 2020 Share Posted September 3, 2020 (edited) En 28/8/2020 a las 5:50 PM, lototo dijo: Add index to database product_attribute_shop table Key 'id_product' doesn't exist in table 'product_attribute_shop' Thanks for your answer... Im not a professional of sql..... how can I make that query? Thanks in advance! PS. I have fixed it by adding the index that table.... a friend of mine who is a master on SQL fixed it Edited September 14, 2020 by Antakarana (see edit history) Link to comment Share on other sites More sharing options...
nmbhulani Posted November 29, 2020 Share Posted November 29, 2020 On 10/17/2018 at 5:13 PM, dinesh badrukhiya said: Hello, You can try to re-build the entire index. Go to: Back-office > Configure > General > Search and click on re-build the entire index. Thanks for the solution, it worked perfectly for me. Link to comment Share on other sites More sharing options...
madeinweb Posted March 30, 2021 Share Posted March 30, 2021 On 4/8/2020 at 11:15 AM, dcabrol said: 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? Saved my life Sir, Thank you! Link to comment Share on other sites More sharing options...
enkom Posted August 1, 2021 Share Posted August 1, 2021 Search did not work for me either, I made the SQL query as above and it helped! I have about 40,000 products in the store. Thanks for the solution, I hope they can solve this problem in the next version. Link to comment Share on other sites More sharing options...
Lazsa Posted December 7, 2023 Share Posted December 7, 2023 (edited) SET FOREIGN_KEY_CHECKS = 0; TRUNCATE `MYPREFIXTABLE_search_index`; TRUNCATE `MYPREFIXTABLE_search_word`; SET FOREIGN_KEY_CHECKS = 1; Great, working by 1.7.8.10 !!! THX!!! Edited December 7, 2023 by Lazsa (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now