MadMepps Posted June 18, 2019 Share Posted June 18, 2019 Hi! I'm getting totally confused because I can't find a solution for long days for my issue already. What we have: A working PS 1.7.5 production MULTISHOP site with 2 shops, VPS (Apache/Nginx, PHP 7.2) and Transformer theme by S-T themes. The items are updated daily and we can't determine the start of this issue but it started to stop with the "error" message. I figured out that there's an Internal server error 500 by the ajax call. Even if only 2-3 columns are imported! Please see the screenshot below. Sometimes after 5 products, sometimes 15, absolutely random values. The site owner told me that sometimes he managed to finish it for 3rd-4th try, sometimes totally not. The CSV files seem to be perfect. I had a developement version of the site and I couldn't reproduce the issue. (I hardly believed the owner that the issue presists.) The biggest comedy that I cloned the site on the server to figure out what the problem was and after several tries surprisingly it started to work. They are in the same environment and I'm not able to mess it up again -> so I don't know the solution. What I tried: - To find a registry in the server error logs for the 500 error (Apache, Nginx) - PHP memory -> 512Mb - Checked input times (300-600s) - Regenerated .htaccess - Checked the product numbers inside the 2 shops (they are equal) - Turned off memcache - Turned off overrides (btw debug mode isn't working on the import page) - Turned off non-offical PS modules - Fixed all the folder and file permissions (755/644) - Tried to cut back and forth the input CSV-s - Checked for duplicated product references - Read all the forums - Tried to debug the error message with additional informations with no luck - PS service module -> DB fix and optimize - And a lot more.... Please can someone help? What should I check more? Thank you very much. You can save a man going crazy. Link to comment Share on other sites More sharing options...
MadMepps Posted June 20, 2019 Author Share Posted June 20, 2019 Hi Folks, It seems to be solved by a PS upgrade to the latest 1.7.5.2 version. As far as we tested first on the clone site and then on the production site. Sorry, sites...multishop. It's weird because nothing in the changelog of 2 latest versions is related to the issue. Link to comment Share on other sites More sharing options...
GuillermoAguilar Posted July 26, 2019 Share Posted July 26, 2019 Hi! I had this same error and found an override that was conflict. override / classes / Product.php If it exists, you could try removing it and importing. Another option is to try with the debug mode option activated, in this way the process was also done correctly. Link to comment Share on other sites More sharing options...
MadMepps Posted July 30, 2019 Author Share Posted July 30, 2019 On 7/26/2019 at 8:04 PM, GuillermoAguilar said: Hi! I had this same error and found an override that was conflict. override / classes / Product.php If it exists, you could try removing it and importing. Another option is to try with the debug mode option activated, in this way the process was also done correctly. Hi! Thanks for your reply. It seems that the issue persist still. I will give a try to your idea despite I've already tried to turn off overrides. However we have a product.php in overrides because of an extended length of product short description from 800 char to 2000. I will reply with the result. Link to comment Share on other sites More sharing options...
Presta_lover Posted January 30, 2020 Share Posted January 30, 2020 On 7/30/2019 at 10:19 PM, MadMepps said: Hi! Thanks for your reply. It seems that the issue persist still. I will give a try to your idea despite I've already tried to turn off overrides. However we have a product.php in overrides because of an extended length of product short description from 800 char to 2000. I will reply with the result. Hi, i am having this issue 1.7.2 It is an awful experience, absolutely frustrating. I can't find product.php in overrides. Did you do anything else? Thanks a lot. Link to comment Share on other sites More sharing options...
TCB-Netherlands Posted September 16, 2020 Share Posted September 16, 2020 Any solution yet? Got the same problem Link to comment Share on other sites More sharing options...
MadMepps Posted September 16, 2020 Author Share Posted September 16, 2020 3 hours ago, TCB-Netherlands said: Any solution yet? Got the same problem Hi! Unfortunetely the shop is closed already, so I can't help. We've never found the solution, always had to take care at the import process, and restart if needed. Link to comment Share on other sites More sharing options...
AlexLopatenco Posted November 17, 2021 Share Posted November 17, 2021 Hi. I'm trying to revive this topic, because this problem is very random and I was having the same error on many different versions of Prestashop (starting with 1.6.1, now on 1.7.7.3). Different servers, different settings, different templates, the same error. Maybe there's a way to see details of this error? Other errors at least give you some info on it (like "length os name is too big", "tags field too long" or "unacceptable symbols" and shows you the ID of the product with the problem, so you can figure out the issue... but this "error" is just an "error" and gives you nothing more... is it logged anywhere? Link to comment Share on other sites More sharing options...
MadMepps Posted November 17, 2021 Author Share Posted November 17, 2021 26 minutes ago, AlexLopatenco said: Hi. I'm trying to revive this topic, because this problem is very random and I was having the same error on many different versions of Prestashop (starting with 1.6.1, now on 1.7.7.3). Different servers, different settings, different templates, the same error. Maybe there's a way to see details of this error? Other errors at least give you some info on it (like "length os name is too big", "tags field too long" or "unacceptable symbols" and shows you the ID of the product with the problem, so you can figure out the issue... but this "error" is just an "error" and gives you nothing more... is it logged anywhere? Hi, I can tell the same as above. The shop is closed already, I've never been able to figure out why it has happened randomly. The most funny fact is that the same owner has a new shop developed which is based on the previous one and we haven't meet the issue since then. Link to comment Share on other sites More sharing options...
AlexLopatenco Posted November 17, 2021 Share Posted November 17, 2021 6 minutes ago, MadMepps said: Hi, I can tell the same as above. The shop is closed already, I've never been able to figure out why it has happened randomly. The most funny fact is that the same owner has a new shop developed which is based on the previous one and we haven't meet the issue since then. Thank you for the reply. I was thinking that there are some other people that had this issue (there must be) and I figured to post in this topic, rather then create a new one (though I might create a new one) This issue will be reviewed by the developers of Prestashop. This issue is random, the error doesn't give any info and is frustrating... Link to comment Share on other sites More sharing options...
MadMepps Posted November 17, 2021 Author Share Posted November 17, 2021 1 hour ago, AlexLopatenco said: Thank you for the reply. I was thinking that there are some other people that had this issue (there must be) and I figured to post in this topic, rather then create a new one (though I might create a new one) This issue will be reviewed by the developers of Prestashop. This issue is random, the error doesn't give any info and is frustrating... Sure, I just let you know about my case, as I was the topic opener. True, such a frustrating thing. It made me completely mad when I tried to fix it. Link to comment Share on other sites More sharing options...
bblues Posted August 22, 2023 Share Posted August 22, 2023 Hi. Same problem in Presta 8.0. PHP 8.0. Any solution in 2023? It's frustrating. Link to comment Share on other sites More sharing options...
AlexLopatenco Posted August 22, 2023 Share Posted August 22, 2023 (edited) 6 minutes ago, bblues said: Hi. Same problem in Presta 8.0. PHP 8.0. Any solution in 2023? It's frustrating. It seems that this issue won't be resolved (soon). The only thing that made the import more stable, was to decrease the quantity of products imported at a time. So, instead of importing 10k, I'm importing 1k products with one .csv file. Edited August 22, 2023 by AlexLopatenco (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