A search reveals messages where the word is used in the subject or the body. Allow the option to search for key words in the subject only also.

If you lock a topic, and the topic has a hashtag, and then you click on that hashtag anywhere, the topic appears in the hashtag search but the lock icon does not appear. I just went through re-locking a bunch of topics that I thought I'd already locked, and it turned out that I HAD already locked them. It's just that when looking for them by clicking on any hashtag they have, the locked icon had disappeared.
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

Shal, I don't mean anything negative by this. I am just done with it, is all. I simply wanted to point out that it is not a simple thing. I am not interested in designing the fix. 
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

Shal,
You can design this to your heart's content. I'm fine with whatever is decided and am done with it.
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

J,

All depends what you mean by “nearly instantaneous.”

I explained exactly what I meant, in some detail.

And yes, in my case and in my group, and no doubt in others, there are
times when it is in no way instantaneous.

Would this work for you? In those cases where, upon reading the "Message Approval Needed" notice, you begin a non-instantaneous process (that is, you do something other than immediately accept or reject) you could step through to the Pending list on site and claim that message.

Or, maybe part of this suggestion (or a separate #suggestion) should be to add a "Claim this message" link to the Message Approval Needed notice, akin to the existing Reject and Delete links. That would cover the case of moderators who can't or don't want to go on site.

Now your process can proceed in a protected fashion. Which, I think, is what you have asked for - a means to avoid investing time in a response only to have the message disappear (be accepted/rejected by someone else) in the meantime.

You can’t wish the problem away.

No, but I can suggest means to minimize the problem (other than by investing the site with the clairvoyance to know that you're considering a message off line).

Shal

JohnF wrote:

How about a way to attach a note to the moderator for a message
that's pending approval?

I supported that idea and J wrote:

How is that possible if the member has posted via the web, since the
sender can't see the pending message and has no access to it
whatsoever?

I also agree with the notion of having a "sent" or "pending" folder on site where a member can access their own messages posted (via web or email) while still pending. I skimmed back through this topic because I thought someone had already suggested it, but if so I missed it - my apologies.

I'm leaning a bit more to the general case of "sent" as an on site way to provide the equivalent function of an email "sent" folder. But that's a rich enough suggestion in itself that it probably deserves its own #suggestion topic (and there may be that suggestion in beta's history already, I didn't search that out but it sounds familiar).

Shal

Shal,

All depends what you mean by “nearly instantaneous.” If it’s not “instantaneous enough,” you have a problem, and an ugly, messy one.

And yes, in my case and in my group, and no doubt in others, there are times when it is in no way instantaneous.

You can’t wish the problem away.

My two cents.

--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

J,

*However,* I'm not sure about the logistics of blocking approval and
rejection via email. It seems you still have the problem that the
moderator may start working on the message, and only after finishing
and attempting to send the approval or rejection do they find out that
the member has "claimed" (i.e., deleted) the message.

Both accepting and rejecting by email are nearly instantaneous events: you click Reply or Forward and Send - there is no time spent in an edit session. Now you may have spent some time thinking about the message before taking action, but there's really no way to handle that: no signal from you to say "I'm thinking about this pending notice in my inbox".

So unless I'm missing something, the basic problem still remains if
the mod is working by email.

I really don't see it as a problem. But that may just be my style being different than yours.

If I approve or reject by email it is usually because the decision for that message was instantly obvious to me. When a message needs consideration I tend to click through to the site to deal with it. If I'm lucky I remember to claim it before beginning to compose a message to the member, another moderator, or a rejection notice. If the message needs some trimming, redaction, or a mod note that edit has to be done on site anyway (and is the one action that currently does claim a pending message).

Shal

.... and we are back again.

Daily summaries did not go out for the past 3 hours because the database query to get summary subscriptions was erroring out with an out of memory error from the database that indicated some kind of corruption on the database again. This was a different problem than the one I saw yesterday. Instead of just restarting the database, I restarted the entire machine this time. If this doesn't fix it, I will have to do something more serious. Again, it doesn't appear that there's any corruption or loss of data in the database; right now this appears to just be a machine issue.

Thanks, Mark

Something we do at work is to use database replication to form a chain of three database hosts: alpha-beta-gamma.  If something goes wrong with the alpha host, we simply take it offline, promote the beta to alpha (e.g., change DNS, undo the read-only status of the beta), promote gamma to beta and then debug the old alpha offline and/or just make a new gamma.

I realize that there is a cost involved to this that groups.io may or may not be able to sustain, but perhaps an alpha-beta model would work also.

Best,

Glenn

.... and we are back again.

Daily summaries did not go out for the past 3 hours because the database query to get summary subscriptions was erroring out with an out of memory error from the database that indicated some kind of corruption on the database again. This was a different problem than the one I saw yesterday. Instead of just restarting the database, I restarted the entire machine this time. If this doesn't fix it, I will have to do something more serious. Again, it doesn't appear that there's any corruption or loss of data in the database; right now this appears to just be a machine issue.

Thanks, Mark

Looking forward to cat pics! Hoping you get that misbehaving database under control. :-)
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

Hi All,

The database is misbehaving again. I need to restart the database machine to see if that fixes it. The site will be down for about 5-10 minutes, starting at 8:50am Pacific Time.

Thanks, Mark

Just adding that in the situation that caused me to discover this problem (which I have since reproduced through tests), the reason I unbanned the member was that banning caused the Display Name to reappear (as mentioned before in a previous thread), and I wanted it to remain blank, as with all other Past (not banned) members.
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

Previously, the fact that removal or banning wiped out the member's Notes in either the Past Members or the Banned list was only an inconvenience: all you had to do to access them was go to the other one in which they still existed and copy them over. (Note: originally the Notes were wiped out only in the Past Members list, which led me to the hack of banning the member if I wanted to see the Notes, because the Notes were accessible in the Banned list. Subsequent to that, a change was made that caused the opposite situation: Notes were no longer accessible in the Banned list, but only in the Past Members list; so to see the, that's where you had to go.)

Now, however, if you remove, then ban a member (for which you must use the email address), then change your mind and unban the email address, the Notes are permanently wiped out everywhere. This is more than an inconvenience. It's a problem.
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

Hi! Not exactly a bug, but the Google Drive Integration page at https://groups.io/g/<my-group>/subintegrations has the Dropbox logo but talks about a Google Drive integration. Should be a quick fix? PS. Just clicked on the button and seems this feature isn't even available --> even quicker fix just to remove it?

On Fri, Feb 21, 2020 at 08:33 AM, Chris Jones wrote:

In the group only the first post in any topic is moderated anyway, unless something has changed.

That is one of the choices the owner can choose, they can also choose to:
Moderate every message. (I have that setting for one of my groups)
Moderate the first (1-4) messages of a member (2 for one of my groups)
Not moderate at all
Also topics can require moderation if they've been dormant for over (xxx) days

Changes to the site this week:

• NEW: Member search now also searches moderator notes.
• BUGFIX: In some cases when we do a reverse DNS lookup on the IP address of a server sending us email, the Go DNS library would return a server misbehaving error, which we treated the same as not having a reverse DNS record, causing us to reject the incoming message. In those cases, we now repeat the lookup using an alternate DNS library. Specifically, China Mobile email servers seem to suffer from this.
• BUGFIX: For some queries, wiki search would return a blank second page.
• BUGFIX: For search queries with URL encoded characters, we would not properly decode them correctly on the subsequent search pages.
• API: Misc improvements to the documentation.
• API: Added "bad_request": "no space" errors to /addphotos, /updatephoto and /addfiles endpoints.
• CHANGE: Moderators now cannot change the role of Owners.
• CHANGE: Moderators now cannot change the subscription options of Owners.
• API: Added support for extended=true to the drafts API endpoints.
• API: /updatemember can now return: "bad_request": "moderators cannot change role of owners" is returned if a non-owner attempts to change the mod_status field of an owner.
• API: /updatemember can now return: "bad_request": "moderators cannot make members owners" is returned if a non-owner attempts to make a member an owner.
• API: /updatemember can now return: "bad_request": "moderators cannot change owner subscription settings" is returned if a non-owner attempts to change an owner's subscription settings.

Have a good weekend everyone.

Mark

Yes, this feature would be welcome & helpful for my groups as well. 
Thank you Denise for posting it.  Thank you to Mark for considering the possibility.
Jennifer 
===============================