How to clear VB Mail Que System..

[vortech1]

yea I just ran what you posted table is there.. that full error is to long to post it had all the html + emails from the news letter as well in it.. Was there something at the bottom that might be useful?


--------------- Added [DATE]1264026595[/DATE] at [TIME]1264026595[/TIME] ---------------

here is the full error I took out most of the body as it had all that in there.. It also did it at the same point the 65 user in the news letter.

Database error in vBulletin 3.8.4:

Invalid SQL:

INSERT INTO mailqueue
(dateline, toemail, fromemail, subject, message, header)
VALUES

(1264026469,
'removed',
'removed',
'StuntUSA',
'<!-- If you can\'t see this message properly, then you are unable to see HTML formatted emails. Please change your setting in the control panel to receive the community bulletin in Text format. \nhttp://www.stuntusa.com/forums/profile.php?do=editoptions -->\n\n</html>',
'From: \"nightshades@stuntusa.com\" <removed>\nSender: nightshades@stuntusa.com\nReturn-Path: removed\nMessage-ID: <20100120222758.9a724d34b6bc@www.stuntusa.com>\nMI ME-Version: 1.0\nContent-Type: text/html; charset=\"UTF-8\"\nContent-Transfer-Encoding: 8bit\nX-Priority: 3\nX-Mailer: Stunt USA\n');

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Wednesday, January 20th 2010 @ 05:27:49 PM
Error Date : Wednesday, January 20th 2010 @ 05:27:58 PM
Script : http://www.stuntusa.com/forums/admin...ll.php?do=send
Referrer : http://www.stuntusa.com/forums/admincp/commbull.php
IP Address : 70.121.133.157
Username : NightShades
Classname : vB_Database
MySQL Version : 5.0.87-community

--------------- Added [DATE]1264030850[/DATE] at [TIME]1264030850[/TIME] ---------------

ok now I am getting this error and has takenmy site down some how, mysql is up and running.

Database error in vBulletin 3.8.4:

Invalid SQL:
LOCK TABLES mailqueue WRITE;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, January 20th 2010 @ 06:28:13 PM
Error Date : Wednesday, January 20th 2010 @ 06:28:40 PM
Script : http://www.stuntusa.com/forums/rss-f...g-bicycle.html
Referrer : http://www.stuntusa.com/forums/searc...archid=1142775
IP Address : 69.125.137.99
Username : scott_f4i
Classname : vB_Database
MySQL Version :

[Adrian Schneider]

Sounds like the email you are sending contains too much information for MySQL to handle at once.

If you edit your MySQL config you can bump up the setting for 'max_allowed_packet'.

[vortech1]

ok I fixed that problem, but now if I turn on send email with locking it just kills the forum. Is there a way to remove the mailqueue table and re-add it fresh? I have tried running repair and it just dies at mailqueue.

I have cleaed it out but with the setting not set to locking the forum NEVER sends any email it just sits in the mailqueue in vb no idea why..

[Adrian Schneider]

Why not ask over at vb.com for support?