Page 1 of 1

Error: MySQL server has gone away

Posted: Sat Jun 04, 2011 4:35 pm
by Daniqwe
Hello,

I need urgent help. When i try to send an email (with opencart script) to all clients what are registred in my webpage, i got an error when around of 500 emails are sent (i have more than 1000 clients).

The error is:
Error: MySQL server has gone away
Error No: 2006
SELECT * FROM store ORDER BY url

I read in some forum that i have to change in my sql server this:
max_allowed_packet = 1M
to
max_allowed_packet = 16M

My hosting company changed it in the server, i tryed again and i still with the same problem.

I don´t know why i have this error, because when i click on send email, the webpage appears like loading.. and so around 5 minutes (i think its sending emails in that time) and latter he says me that error.

Please, i need help.

Thanks.

Re: Error: MySQL server has gone away

Posted: Sat Jun 04, 2011 6:05 pm
by i2Paq
Looks to me a MySQL issue and not OpenCart.

Have you checked your server error-logs? Ask you hoster.

Re: Error: MySQL server has gone away

Posted: Sat Jun 04, 2011 11:44 pm
by Daniqwe
Hi,

I hadn´t got any error more than what i mentioned, and my hoster says that i have to contact with opencart supporte bacause he already inserted the command.