How do I remove all email subscriptions?

[firewire]

I have disabled the email features on my forum quite some time ago.
Still, vBulletin is sending out lots of notify emails.
Could it be possible that subscriptions being made before I turned off email notifies are still being delivered (I have several very huge threads on that specific forum)?
Is there a way I can remove all those ancient email subscriptions without actually touching the thread subscriptions in their control panel?

Thanks a lot.

Edit: I should add that in both subscribeforum and subscribethread mysql tables the "emailupdate" field is set to 0 on all records.
Maybe there is another reason for vBulletin sending those mails? It can't be PMs etc., it's far too many mails.

[Steve Machol]

Could it be possible that subscriptions being made before I turned off email notifies are still being delivered (I have several very huge threads on that specific forum)?
Is there a way I can remove all those ancient email subscriptions without actually touching the thread subscriptions in their control panel?

Yes, that is exactly what's happening. You can remove these subscriptions with this query:

DELETE FROM subscribethread;

However please note this will remove all subscribed threads from the User CPs.

[JUNG1999]

I am having the same problem. VB is sending out 50,000 emails a day. It's gotten so bad that there is a 4 to 5 day delay on outgoing mail from my server.

I have seen several posts here that suggest running the query:

"DELETE FROM subscribethread;"

It dosen't seem to be a valid SQL query.

I think the VB team should defeinately revisit and rethink this area of the software.

[Zachery]

Are you using table prefixes jung?

[JUNG1999]

Are you using table prefixes jung?

No.

[JUNG1999]

OK,


Here is the right SQL query to run:

DELETE FROM subscribethread where emailupdate = 0;