On 2/23/21 9:40 PM, Morris Jones wrote:

I typo'd some full names in a mailing list. I want to correct them ...

I can't see a way to do that in the Member Options, so I thought I'd try "remove" and re-add, either from the command line or the UI.

But the name gets readded with the typo intact.  :(

Is there a way to fix it without writing SQL?

You can do it with mailman shell. The basic issue is the display name is a property of the user or the user's address, which ever is subscribed to the list. When you add a previously unknown user to a list, Mailman creates these user and address records, but they belong to the user, not the list. There are some threads around this at <https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/thread/AMCNP46A6ESUK655KAO2U2AF4XOEXM4R/>, <https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/thread/EDXRRGM752TY67HHVYYJ577B5APL727G/> and a somewhat protracted one at <https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/thread/HIZQY5CX5WIVGHT53PNJQSVNW66QKS4L/>.

-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

On 2/24/21 10:13 AM, Peter Adebahr via Mailman-users wrote:

On 2/24/21 6:40 AM, Morris Jones wrote:

...

I typo'd some full names in a mailing list. Is there a way to fix it without writing SQL?

I understand it is just the name itself, which has been typo'd, not the mail address: Couldn't you just edit the field "display_name" of table "address" in the MM3 database? Easy with phpmyadmin or adminer...

Of course you can do that if that's where the typo is. The actual display name you see may be the one in the address table, or it may be the one in the user table depending on whether the subscription is by address or by user.

-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan