vb.org Archive - How to clear VB Mail Que System..

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - How to clear VB Mail Que System.. (https://vborg.vbsupport.ru/showthread.php?t=233637)

vortech1

01-20-2010 03:03 PM

How to clear VB Mail Que System..

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

01-20-2010 07:24 PM

wrong info.

vortech1

01-20-2010 07:38 PM

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

01-20-2010 07:42 PM

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

Code:

TRUNCATE TABLE mailqueue;

vortech1

01-20-2010 07:46 PM

can I run that from phpmy admin?

Adrian Schneider

01-20-2010 07:47 PM

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

Cheers

vortech1

01-20-2010 07:51 PM

Quote:

Originally Posted by SirAdrian (Post 1961562)

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

01-20-2010 07:52 PM

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

01-20-2010 08:08 PM

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

Quote:

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

01-20-2010 08:13 PM

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

All times are GMT. The time now is 10:03 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01047 seconds Memory Usage 1,728KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: