[Solved] Database error 2006 Solution

Solutions for other phpList version 2 users
Forum rules
Please do not ask questions here, this is for Solutions you have discovered or come across.

[Solved] Database error 2006 Solution

Postby Guest » 1:52am, Sat 13 Sep, 2008

I want to share my solution to the Database error 2006 problem. I got the solution from another thread, but almost missed it.

SYMPTOMS:
    I made no changes to my PHPList. It was running fine for a long time.
    One day it started only sending one email each time the cron fired. When I manually processed the queue, it would only send one email then appear to hang.
    I could occasionally see the error Database error 2006 while doing query MySQL server has gone away appear in red boxes before the process queue page refreshed.
    My shared host -- siteground -- insisted that they made no changes on their end and suggested that the script was trying to "execute slow and heavy MySQL queries."


SOLUTION:
In my config.php I had ...

Code: Select all
define('MAILQUEUE_THROTTLE',9);


... so that the emails would be sent 9 seconds apart. I changed it to ...

Code: Select all
define('MAILQUEUE_THROTTLE',1);


... and I'm back up and running! The host must have changed a setting that would kill processes that slept or delayed.

Good luck!
Last edited by Guest on 8:24pm, Wed 17 Sep, 2008, edited 1 time in total.
Guest
 

Postby J_S » 1:44pm, Tue 16 Sep, 2008

Thank you for this ;)
J_S
Admin
 
Posts: 674
Joined: 10:18pm, Fri 11 Apr, 2003


Return to Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 4 guests