[PROBLEM] Problem with editing and duplication of products in prestashop 8- error 500, error 2006- any suggestions?

[Damons]

Hello,

I have been experiencing an issue with error 500 for a few weeks now, and unfortunately, the problem is getting worse. It started occurring two weeks after migrating to PrestaShop version 8 and adding new products to the store. Since these were similar products, I didn't hesitate to create duplicates, especially since the specifications were similar. After some time, these duplications began to slow down more than usual (there were no logs in PrestaShop). I initially blamed it on the internet due to the weather conditions at that time, but even after the weather improved, the situation did not get better. My colleagues were the first to notice this – we share some of the same responsibilities and often exchange them, so they were the first to see the error message. I then started searching the internet for "truth" and various tips that could help with diagnostics. I began with the PHP server, but the parameters seemed to be even better than those described in forum threads. I then started looking into the PHP server files to see if any changes had occurred, but none had – I hadn't added any new queries to the server or any new modules. Of course, I also checked all the modules connected to the site, disabling and checking them one by one.

Initially, error 500 was not very persistent, appearing sporadically with some changes as a pop-up at the top of the screen, but now it has become serious. Additionally, there was an interleaving message Doctrine\DBAL\Exception\ConnectionLost Code 0 (sometimes with a comment referring to a database query – usually an UPDATE), and of course, GENERAL ERROR 2006 MySQL Server Has Gone Away – why? I have no idea. Since the 500 error message led to enabling the debug mode, we haven’t touched the products at all – apart from duplicating, we were also working on SEO in the department, but as I mentioned, we haven't done any work on products since then.

PHP server parameters:
Memory limit: 1024M
Maximum execution time: 900
Maximum upload file size: 1G

Do you have any ideas on how to tackle this issue? "Server has gone" appears in the logs, but all settings seem to be within the norm. Debug mode from the admin panel unfortunately doesn't give me any clues, and I can't find anything specific in other threads that could help me with this problem.

What is causing the problem to worsen?

The admin panel, which should work flawlessly in Lightning McQueen mode, currently moves like a dragging ox, and some transitions between options end with a total error 500, suggesting enabling the debug mode. I get messages in Presta logs about missing templates, e.g., No template found for catalog/_partials/product-flags and not only this. If someone could tell me the path where the _partials folder should be located so I can find it on the FTP server, I would be grateful. I have a problem with editing products – I still need to perform many duplications and SEO section edits, and performance issues and errors make this impossible.

I don't know if I missed any aspect, but I would be grateful for any help on this matter.

Edited August 6, 2024 by Damons (see edit history)

[Dani1989]

Hi, I seem to be having the same problem. Did you find a solution? If you can share it, I'd appreciate it since I am also trying to work on the site and at this moment its impossible.

[Damons]

1 hour ago, Dani1989 said:

Hi, I seem to be having the same problem. Did you find a solution? If you can share it, I'd appreciate it since I am also trying to work on the site and at this moment its impossible.

We found it. It was not satisfied as we wanted but we deactivated some modules- like for European Doctrine- Omnibus- and modified php parameters. It works after that, so please check first if debug didn't send you some information about modules collisions- because in my situation didn't- but in your maybe will show you something. Also you can check if your hosting is enough for your website (I saw we claim for now 75% of free space, so in the future we need to expand it), it also may be the problem.