vejlupek Posted September 3, 2014 Share Posted September 3, 2014 Hi, when I assign product to some category it takes really long time (5+ minutes) to save. If I do any other changes to product and save the product it save just a little while. I tryied to do some changes in performance setting (smarty, cache, ...) but none of that seems to solve the problem. Other things works great and fast enough. Can someone help to save my nerves? Thank you Milan PrestaShop™ 1.5.6.2 Link to comment Share on other sites More sharing options...
agenceweb74 Posted September 4, 2014 Share Posted September 4, 2014 How much products/categories do you have ? If your number is not insane, this should not be a problem. Try to clear manually the cache, or make sure that the user running apache have propre permissions on cache folder. Did you tried a manual SQL insertion ? I guess the best solution would be to benchmark and debug the product/category association. Look into classes/Product.php and classes/Category.php Link to comment Share on other sites More sharing options...
vejlupek Posted September 4, 2014 Author Share Posted September 4, 2014 Well I have like 100 categories and 12000 products. But I do not think that is the reason cause other think that is funny is that once I save the product after assigning to category it will save then normally (within few seconds) even if I reassigne product to other category/ies. When I use software for mass edit and assign product/s to some category it will reflect on the site really quick. I did try to clear smarty cache manually but no change. I am no programer so benchmark and debug is for me as we say spanish village - have no idea what to do. Any suggestion? P.s.: To save product when assign to category for the first time - 8+ minutes. To save product (that has been assign to category and save before) when assigning to other category/ies - max 5 seconds what is fine to me. Link to comment Share on other sites More sharing options...
agenceweb74 Posted September 4, 2014 Share Posted September 4, 2014 (edited) With such constatation you will definitively find the bug ! Smarty cache is strictly not related to this problem. How many lines in ps_category_product table ? Edited September 4, 2014 by agenceweb74 (see edit history) Link to comment Share on other sites More sharing options...
vejlupek Posted September 5, 2014 Author Share Posted September 5, 2014 In ps_category_product table there is 15238 lines. Link to comment Share on other sites More sharing options...
agenceweb74 Posted September 5, 2014 Share Posted September 5, 2014 This should not be a problem. Does it occurs on products created with your mass update software ? Can you perform a try with a brand new product created from the prestashop backend ? Link to comment Share on other sites More sharing options...
vejlupek Posted November 8, 2014 Author Share Posted November 8, 2014 When I create brand new product from prestashop backend it works fine and product saves in few seconds. So the problem seems to be just with products imported. Any suggestions? Thank you very much for any help. Milan Link to comment Share on other sites More sharing options...
vejlupek Posted November 8, 2014 Author Share Posted November 8, 2014 There is one other funny thing. When the long time saving product occures and when I stop the saving manually and then save the product with save and stay button, it will save than in few seconds. I am really stuck here...Milan Link to comment Share on other sites More sharing options...
Recommended Posts