Mail

[Terrablade]

Folks,
I have set the DO NOT SUBSCRIBE option using the option available in query.
I have also set the same option in user registration BUT im still getting bounced mail from people because they are getting sent mail for thread subscription. No they have not subscribe themselves to the threads where they have posted. Any clue on whats going on,

Not fun receiving 200+ mail every 30 seconds.

[Terrablade]

Anyone? come on help a fellow member

[ozzy47]

Try running this query.

truncate subscribethread;

[Terrablade]

<a href="http://prntscr.com/24xlsf" target="_blank">http://prntscr.com/24xlsf</a>

[ozzy47]

That should do it, the table is now empty.

[Terrablade]

They still showing.. Not i cant even uninstall Ez Bounce without it messing my templates and colors go all to crap need to re-upload it for colors to go back to normal. How can I uninstall that MOD without messing things up?

[ozzy47]

Wait, so you are still getting bounced emails for thread subscription after running that query? Maybe you have emails in the queue, try running this query.

TRUNCATE TABLE mailqueue;

As for the mod I am not sure, I never have had it installed.

[Terrablade]

Ran it, hopefully it gets fixed. Still need to find a way to uninstall the MOD without messing up th templates :/

[Lynne]

The image you posted after you ran the query the first time did nothing - it said Affected Rows: 0. That means no rows were effected by the query. If you had a bunch of stuff in that table that you were trying to truncate, the number of rows would have not been 0.

[ozzy47]

No Lynne, that is a truncate on the table, it does not return any results, I tried it on my site, and got the same thing, 0 but the table was in fact emptied.