CriMsonK20 Posted October 23, 2009 Share Posted October 23, 2009 I'm having an issue with rebuilding the search index on my store. I have 255 products entered, and needed to change the minimum search character limit from 3 to 2, and this requires the index to be rebuilt. Well, when I went to rebuild it, it just cleared the index table as it should, and attempts to rebuild the index. The script runs for 2 minutes and then times out.Things I have tried that haven't worked:setting the max_execution_time value in the scriptsetting the script to run as a cron job on the server-- I haven't had confirmation that the script is even running. There isn't anything in the error logs and the server admins haven't responded to my ticket just yet.Does anyone have any insight on this? I have done tons of searching and can't seem to find anything related to this. Thanks in advance! Link to comment Share on other sites More sharing options...
CriMsonK20 Posted October 26, 2009 Author Share Posted October 26, 2009 nobody has any input on this? Link to comment Share on other sites More sharing options...
CriMsonK20 Posted October 26, 2009 Author Share Posted October 26, 2009 maybe a better question is, has anyone compiled this into a stored procedure or anything that I can run on the database itself, that way I can cut out the web server as the middle man? Link to comment Share on other sites More sharing options...
tuantu.t Posted November 10, 2009 Share Posted November 10, 2009 Hi, I think I have a similar problem.What does it do when it times out ? For me, the server just returns an empty php file that the browser treats like a regular file (asks me if I want to save it, select an application to open etc...)I actually have the same problem with a lot of other operations like adding a product, updating a product ... Link to comment Share on other sites More sharing options...
tuantu.t Posted November 16, 2009 Share Posted November 16, 2009 Just in case this might help someone with their problem:I have about 12000 products in 5000 categories that I imported through the csv import tool of the back-office.My problem was that after the import, the new products weren't indexed and trying to rebuild the index or add the new products to the index was probably a too heavy operation (I'm not sure) so the operation would just time out. (Actually, I think the TCP connection timed out while the script was working or something like that ...)The timeout problem also occured when adding a new product or updating an existing product.So what I did was: * Delete all the products* Re-import them in small batches (I did 1500 per batch) and update the search index after each batch.And that's it ... Now the search index is up to date and no more problem when I add or update a product ... I guess the problem came from the fact that when you add or update a product through the catalog admin tab, the search index must be updated but I had already too many unindexed products for this operation to be done within the time limit imposed by ... my server ? the tcp protocol ? ... ?A better way of course would be to modify this time limit but I don't even really know the reason why the timeout occurs so ... Link to comment Share on other sites More sharing options...
jcmarcos Posted January 27, 2010 Share Posted January 27, 2010 How about setting zero to the "indexed" field of some products, and then executing the update index script? You could do it in small batches.Which leads me to another question: Where the hell is that script? I'd like to launch it from outside the administration site. Link to comment Share on other sites More sharing options...
Arkadia Posted March 21, 2013 Share Posted March 21, 2013 Hey guys Did any of you find an easier way to solve this problem? Removing products and adding them back isn't an option. The store is on prestashop 1.4.5.1...and I only have 150 products but rebuilding the index or adding the missing products keeps timing out. Thanks! Link to comment Share on other sites More sharing options...
Loter Posted October 17, 2013 Share Posted October 17, 2013 Check visibility option. Link to comment Share on other sites More sharing options...
Tomasci Posted March 3, 2014 Share Posted March 3, 2014 There is no way to import the values and attributes? When I use the .csv import I also lose al descriptions? And my buy-in price? I've experimented too much, but I don't want to lose my 500+ products, 150+ values for combinations, all descriptions, etc. Basicly need to import the complete catalogue + localisation menu. Without all other stuff. Even better would be: A prestashop install file with my catalogue content instead of the standard demo content? Automaticly installing the tax. rules of the desired language?I could provide a hostingaccount with a copy of the shop which content needs to be used for this. Any help is greatly appreciated! Link to comment Share on other sites More sharing options...
diabolus Posted June 10, 2015 Share Posted June 10, 2015 I have this same problem with rebuild search index i have 20 000 products and what i have to delete it ? is there a solution for that i search for it on 3 days and nothing Anyone a sugestion ? Link to comment Share on other sites More sharing options...
diabolus Posted June 11, 2015 Share Posted June 11, 2015 Nevermind now working all fine For onthers with this problem: I change php from : fast-cgi to: "CGI" or "MOD-PHP" (bouth work fine with this solution ) next restart server and rebuild index mine with 20 000 products take time about 1h next i return to Fast-CGI restart server and thats all 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
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