How to clear VB Mail Que System..

[vortech1]

Our mail setting was set wrong in forum come to find out, we switched it over to send with locking well now it's sending a CRAP loud of old emails. How can I just clear out the mail que so it starts fresh. It has sent like 16,000+ messages in 12 hours to say the least some users are getting a bit ticked off..

I have no idea where vb stores mail it wants to send i just need a simple way to clear this out..

[snakes1100]

wrong info.

[vortech1]

Oh trust me I have done that but VB just keeps adding to it. Right now its sending mail from 4/2009 because the server I moved from the mail server had issues so its like its all backed up in vb not the mail server..

[Adrian Schneider]

vBulletin does have a mail queue. I'm not sure what the standard process is, but this should do the trick - TRUNCATE TABLE mailqueue;

[vortech1]

can I run that from phpmy admin?

[Adrian Schneider]

Yep, just be sure to prepend your table prefix if you have one configured.

Cheers

[vortech1]

Yep, just be sure to prepend your table prefix if you have one configured.

Cheers

How do I do that by chance.. I don't want to mess any thing up.. :)

BTW the mailque in phpmyadmin says
Showing rows 0 - 29 (526,150 total, Query took 0.0357 sec)

526,150 emails I think looks to be one per line..

[Adrian Schneider]

Yeah - it's one per line. Disregard my last post if you found the table. If you are in phpMyAdmin, just empty the table as you normally would any other table.

[vortech1]

ok now i just got this error trying testing my news letter:


Database error in vBulletin 3.8.4:

Invalid SQL:

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

(1264024644,
'email removed',
'email removed',
'StuntUSA',


Will it fix its self?

[Adrian Schneider]

Post the whole error... and you didn't delete the table did you? Just emptied it?

[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 1264026595 at 1264026595 ---------------

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>\nMIME-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/admincp/commbull.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 1264030850 at 1264030850 ---------------

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-feeds/38283-why-sex-like-riding-bicycle.html
Referrer : http://www.stuntusa.com/forums/search.php?searchid=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?