query to run

[Steve Machol]

My guess:

DELETE FROM forumsubscription WHERE userid = 250

Stupid server time is messed up. :(

[Smoothie]

to unsubscribe a user from a certain forum? Example, userid=250, forumid=64. For some reason a former mod is still subscribed to our mod forum and is receiving email notification of new posts. Even though he has been removed as a mod from all forums.

[filburt1]

DELETE FROM forumsubscription WHERE userid = 250 AND forumid = 64;

[Boofo]

Is there a way to do this forumwide, instead of having to do it for each forum?

[Boofo]

I thought that might be it, but I wanted confirmation just to be sure. Thank you, sir. ;)

LOL I almost missed this message. When I clicked on the link in the email notification, the message I was taken to was my last one. Good thing I scrolled up. ;)

[Steve Machol]

Yep, the server time was messed up for a few minutes. Thankfully not much longer than that.

[Smoothie]

Hmm, got this after I ran the query;
Table 'vbulletin.forumsubscription' doesn't exist

[Smoothie]

Ah well, I just went into the table subscribeforum and manually deleted the userid from that forumid.

[Boofo]

Today at 10:31 PM Smoothie said this in Post #8 (https://vborg.vbsupport.ru/showthread.php?postid=406860#post406860)
Ah well, I just went into the table subscribeforum and manually deleted the userid from that forumid.

How did you do that? I just went into phpmyadmin, but I don't know how to get inside the table to delete anything.

[Smoothie]

table subscribeforum, click browse. Sort by userid or forumid.

[Boofo]

I should have known that. Dohh!!! ;)

Thank you, sir. ;)

I guess the query should be:

DELETE FROM subscribeforum WHERE userid = 250 AND forumid = 64;

[Steve Machol]

Actually it should have been:

DELETE FROM subscribeforum WHERE userid = 250

That's what we get for trusting filburt! :p

[filburt1]

Crickey, considering vB's forum subscriptions in vB2 are next-to-uselss, what did you expect :p