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.

[Terrablade]

Well the second query also returned 0 as a result. So dont know what to say.

[ozzy47]

Same thing, it truncates the table, and would return 0 results even if there were thousands in there.

Have you got any bounced mails lately?

[Terrablade]

yes got 1 a few mins ago

[ozzy47]

Can you check these two tables in the DB in phpmyadmin,
subscribethread and mailqueue.

[Terrablade]

yes check for what tho

[ozzy47]

If there is anything in those tables.

[Terrablade]

no. nothing.

[Lynne]

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.
Learn something new every day. :)

[ozzy47]

no. nothing.

That's really strange then, what is the exact mail that is being sent, and returned to you?

[Terrablade]

<a href="http://prntscr.com/25j0v1" target="_blank">http://prntscr.com/25j0v1</a>

[Lynne]

That is not an email from vbulletin, that is from your server.

[ozzy47]

Yup, sounds to me like someone may using your server to send out email.