Product page loading for a full minute, then showing a 500 error on Save

[Hissvard]

Just the other day, I upgraded a client's store from 1.5.x to 1.6.1.7, and all seemed okay.

However, this evening the product page started taking 50 seconds to load after clicking on the "Save" button, just to show an "Error 500" page. The changes *are* made even though the 500 error is shown, but it is still an unnerving issue.

This is what I get after switching on _PS_DEBUG_PROFILING:

How could I solve this matter?

[Apium]

Does this log an error? If so, could you show us the relevant error logs?

[Hissvard]

After enabling error reporting, I get this message after 30 seconds when trying to edit a product:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/znppanpo/public_html/tools/htmlpurifier/HTMLPurifier.standalone.php on line 18446

 

It has also been reported that t editing a product once made it disappear.

Edited September 30, 2016 by Hissvard (see edit history)

[Rasq]

Maybe your hosting closes the connection in 30 sec.

[Hissvard]

Maybe your hosting closes the connection in 30 sec.

 

I don't think the issue lies with the hosting. There's no reason for a product edit to take more than 10 seconds, is there?

 

EDIT:

I set memory_limit to -1 since it was running out of memory, now after the loading I get a 404 page showing:

Edited October 3, 2016 by Hissvard (see edit history)

[El Patron]

try this

 

back office-->preferences-->general

 

disable htmlpurifier, re-test post results.

 

happy day, el

[Hissvard]

try this

 

back office-->preferences-->general

 

disable htmlpurifier, re-test post results.

 

happy day, el

 

I have already tried disabling HTMLPurifier as the script freezed on it, however it sadly changes nothing.

[El Patron]

I apologize I did not see the error information from debug.

 

https://www.prestashop.com/forums/uploads/monthly_10_2016/post-1320441-0-83406700-1475491188_thumb.png

 

I looked at 1617 native db but could not find product_reductions table.

 

Did you have 3rd party module that handled reductions?

 

try this, bo-->performance panel

disable 3rd party modules overrides,  see if problem persist, we are trying to determine if 3rd party module create issue.

 

also is there more info in error, like stack  trace so we can see who is calling?

[El Patron]

also see this:

https://www.prestashop.com/forums/topic/542409-r%C3%A9solu-p-1615-ps-product-reductions-doesnt-exist/

 

use chrome or other xlator to your language.

[Hissvard]

Sorry for the late reply and thank you for your assistance.

 

Disabling third-party modules does indeed bring the loading time after editing a product down to 4-5 seconds!

 

Only enabling the _PS_MODE_DEV gives me:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/znppanpo/public_html/classes/db/Db.php on line 547

 

While enabling both _PS_MODE_DEV and _PS_DEBUG_PROFILING_ gives me the following: 

 

I'll try and find out which module is causing the issue, thank you very much!

[El Patron]

also see this:

https://www.prestashop.com/forums/topic/542409-r%C3%A9solu-p-1615-ps-product-reductions-doesnt-exist/

 

use chrome or other xlator to your language.

 

 

Sorry for the late reply and thank you for your assistance.

 

Disabling third-party modules does indeed bring the loading time after editing a product down to 4-5 seconds!

 

Only enabling the _PS_MODE_DEV gives me:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/znppanpo/public_html/classes/db/Db.php on line 547

 

While enabling both _PS_MODE_DEV and _PS_DEBUG_PROFILING_ gives me the following: stacktrace.pbg.png

 

I'll try and find out which module is causing the issue, thank you very much!

 

for the error, see my original link,  that is a strange issue...and unique to only a very small number...

 

Please let us know how it goes!  el

[Hissvard]

I followed the instructions given in the other thread, but both cpanel and the query I tried tell me that the user does have the permission to create temporary tables.

()

 

I'm gonna keep searching for the faulty module and let the world know when I do find it, I guess!

 

EDIT

After an endless loop of deactivate module/try to edit product/reactivate module, it turns out the one that was giving issues was SEO Auto Fill. Thank you very much, and sorry for bothering you.

Edited October 4, 2016 by Hissvard (see edit history)

[El Patron]

I followed the instructions given in the other thread, but both cpanel and the query I tried tell me that the user does have the permission to create temporary tables.

(temp.png)

 

I'm gonna keep searching for the faulty module and let the world know when I do find it, I guess!

 

I'd download all the files on to local, get a good free search program, and then  search for product_reductions...I checked a 1617 db but did not see that table...

 

being able to search code base makes things much easier...