Prestashop Backend Internal Error 500

[rhath127]

Hey guys, I am facing some intermitent issues when uploading or amending an item. Once every few minutes while adding or amending, the server or the connection to the database will crash and throw a Internal Server error 500. It will come back pretty much right away but the waiting can get annoying when I am adding alot of items. 

And also it seems the SQL DB has ballooned from 2.x GB to 4 GB in a matter of weeks. I am not sure how or why. I have added a few items but just pictures are the big items. No Files or videos or anything.

I have spoken to the hosting guys and they say it looks all good oin their end. 

Any insight would greatly help

www.partyandyou.com.au is the website in case you needed to see

TIA

Edited June 2 by rhath127
update (see edit history)

[Prestashop Addict]

Please can you specify PS, PHP and theme versions. Turn debug mode on to have more error details.

[rhath127]

Ps 8.2, php 8.0 version, classic theme. I’ll turn it on and post back.

im now getting email error Mail delivery system error, 

“This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:”

 

I also started getting user not found error - when I tried to log in. Found out it was due to Recaptcha module. I will have to disable that. This is also causing similar error when using the contact us form.

 

[El Patron]

for mysql bloat:

https://prestaheroes.com/blogs/prestashop-how-to-use-phpmyadmin-to-find-large-or-growing-database-tables/prestashop-how-to-use-phpmyadmin-to-find-large-or-growing-database-tables

for  removing 'some' common PrestaShop table data (drop)

https://prestaheroes.com/blogs/prestashop-how-to-use-phpmyadmin-to-find-large-or-growing-database-tables/which-large-prestashop-tables-can-be-dropped-or-emptied-safely

 

for 500 errors,  enable PrestaShop debut  mode, admin-->advanced  parms-->performance-->enable debug

[rhath127]

Thanks for the response. I’ve managed to shrink the database to within the allocated gb.

I'm still facing intermittent disconnection. The hosting provider mentioned something about there’s a limit to simultaneous connections? That’s why it’s spitting out 500 error when it disconnects from the db. 
 

any insight?

[Prestashop Addict]

Il y a 4 heures, rhath127 a dit :

I'm still facing intermittent disconnection. The hosting provider mentioned something about there’s a limit to simultaneous connections? That’s why it’s spitting out 500 error when it disconnects from the db. 
any insight?

Yes that can be the cause 😞

[rhath127]

1 hour ago, Prestashop Addict said:

Yes that can be the cause 😞

Any way to check this? Or allow more connections? 

 

Edited June 3 by rhath127 (see edit history)