[Forum] Vbulletin sending old emails

[DeanoUk]

Hi all,

I have a problem on a forum where it is sending old emails out constantly. I'm not quite sure where the problem lies, having tried repairing the DB/flushing caches etc.

I notice the mailqueue table is around 20mb, and considering the very small load on the forum mail-wise, that seems large.

Any tips?

Thanks.

[Mark.B]

Never repair database tables as a routine diagnostic step. It won't solve your problem and can permanently damage your database.

There are clearly queued emails. You can delete these by running this query:

TRUNCATE TABLE mailqueue

Back up your database first.

[DeanoUk]

Hi Mark, thanks for your reply - sorry for the delay in responding.
Running that query states 0 rows have been affected. Thus I am unsure what else the problem is? Additionally all of these emails are old and have been sent before.

[Mark.B]

If the mailqueue table is empty then this is a server issue of some sort. vBulletin has no ability to revisit old emails that have already been sent.