Error: MySQL server has gone away
Posted: Sat Jun 04, 2011 4:35 pm
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.
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.