Database has gone away ...

Discussions that don't fit elsewhere & discussions not related to phpList (This does not mean spam is allowed).

Database has gone away ...

Postby dkaip » 10:28am, Fri 13 Jan, 2012

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?
dkaip
phpLister
 
Posts: 6
Joined: 9:35pm, Wed 09 Mar, 2011

Re: Database has gone away ...

Postby Dragonrider » 11:11am, Fri 13 Jan, 2012

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.
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom


Return to Other

Who is online

Users browsing this forum: No registered users and 1 guest

cron