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]

[sql]
DELETE FROM forumsubscription WHERE userid = 250 AND forumid = 64;
[/sql]

[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;

PHP Code:

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
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.