How do you stop email alerts to everyone?

LeftBrain

Hello. For some reason everyone on my list had every discussion bookmarked and now they get an email on every post.

How do I stop this? Basically, how do I en mass remove bookmarks from all users?

UnderDog

if you want to delete the bookmarks from all users, just empty the bookmarks table.

You can also delete from the bookmarks table where users are not equal to certain id's, for example the id's of the administrator and moderators.

UnderDog

You're right, it's not completely clear. It's certainly not GDN_Activity GDN_ActivityType GDN_AnalyticsLocal GDN_Ban GDN_Category GDN_Comment GDN_Conversation and a bunch of others, so filter out which ones you think it is and maybe you can conclude the correct one.

It's a database table which stores information per user

UnderDog

if you want to delete the bookmarks from all users, just empty the bookmarks table.

You can also delete from the bookmarks table where users are not equal to certain id's, for example the id's of the administrator and moderators.

LeftBrain

How would one go about emptying the bookmarks table? I searched through the database but couldn't find anything related to the bookmarks

UnderDog

Maybe google will know the answer to that question:

https://www.google.com/search?hl=en&as_q=phpmyadmin+how+do+I+empty+a+table&as_epq=&as_oq=&as_eq=&as_nlo=&as_nhi=&lr=&cr=&as_qdr=all&as_sitesearch=&as_occt=any&safe=images&tbs=&as_filetype=&as_rights=

LeftBrain

Thank you so much for your assistance. I don't mean to be so daft. I completely understand now how to empty a table. Now, I just need to know which one of these is the 'bookmarks' table. It's just not clear to me.

GDN_Activity
GDN_ActivityType
GDN_AnalyticsLocal
GDN_Ban
GDN_Category
GDN_Comment
GDN_Conversation
GDN_ConversationMessage
GDN_Discussion
GDN_Draft
GDN_Invitation
GDN_Log
GDN_Message
GDN_Permission
GDN_Photo
GDN_Pocket
GDN_Regarding
GDN_Role
GDN_Session
GDN_Spammer
GDN_Tag
GDN_TagDiscussion
GDN_User
GDN_UserAuthentication
GDN_UserAuthenticationNonce
GDN_UserAuthenticationProvider
GDN_UserAuthenticationToken
GDN_UserCategory
GDN_UserComment
GDN_UserConversation
GDN_UserDiscussion
GDN_UserMeta
GDN_UserRole
GDN_zCategory
GDN_zComment
GDN_zConversation
GDN_zConversationMessage
GDN_zDiscussion
GDN_zRole
GDN_zUser
GDN_zUserConversation
GDN_zUserDiscussion
GDN_zUserRole

Thanks again for your help.

UnderDog

You're right, it's not completely clear. It's certainly not GDN_Activity GDN_ActivityType GDN_AnalyticsLocal GDN_Ban GDN_Category GDN_Comment GDN_Conversation and a bunch of others, so filter out which ones you think it is and maybe you can conclude the correct one.

It's a database table which stores information per user