Page 1 of 1

Database has gone away ...

PostPosted: 10:28am, Fri 13 Jan, 2012
by dkaip
Database error 2006 while doing query MySQL server has gone away
is the message of error from config.php settings.
My host is HostSo.com and i can not how to change sql server settings. Has CPanel.
Server has 300mails/h limits and connect_timeout=10 & wait_timeout=10
The list test has 2 emails.
I have try many settings. Now i have put the settings bellow.
define("MAILQUEUE_BATCH_SIZE",0); i have try 250
define("MAILQUEUE_BATCH_PERIOD",60); i have try ...3600
define('MAILQUEUE_THROTTLE',12); i have try...0
define('MAILQUEUE_AUTOTHROTTLE',0); i have try...1

In process queue says after 1 minute ...

Started
Processing has started, 2 message(s) to process.
It is safe to click your "stop" button now, report will be sent by email to pameaigio@gmail.com
Processing message 252
Looking for users
Found them: 717 to process
Process Killed by other process
Script stage: 5
1 messages sent in 12.56 seconds (286 msgs/hr)
Finished this run
Waiting for 60 seconds before reloading

reloading says ...

Started
A process for this page is already running and it was still alive 114 seconds ago
Sleeping for 20 seconds, aborting will quit
Sent in last run: 1
Skipped in last run: 0
<div id="dberror" style="position: relative;
background-color: #aa0000;
border: 2px solid #000000;
color: #ffffff;
">Database error 0 while doing query MySQL server has gone away</div>
Script stage: 1
Finished, Nothing to do
Finished, All done

----------------------------------------
What is wrong in list? What settings i must put?

Re: Database has gone away ...

PostPosted: 11:11am, Fri 13 Jan, 2012
by Dragonrider
Check out this thread, viewtopic.php?f=6&t=7675 and in specifically these posts viewtopic.php?f=6&t=7675&start=15#p74241 and viewtopic.php?f=6&t=7675&start=15#p83716 from NYChris.