Systers-mailman

Mixed Case Email addresses

Bug #991984 reported by Rosario Robinson
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Systers-mailman
New
Undecided
Unassigned
Systers-mailman gsocmigration

Bug Description

There is a bug in Systers customized version of Mailman where people can subscribe with mixed-case email addresses even though they have applied with the same email address before.

I wrote a script, update_subscribers.py, to read from the SUBSCRIBERS table and
1) identify all subscribers with mixed-case email addresses,
2) change their email addresses to all lower-case email address,
3) write the results to a file.

This bug is similar to the bug reported before #583379.

Location of script: ABIWT --> /home/rosarior/Systers/update_subscribers.py

Robin and Rose tested script August 2011.

Rose retesting script currently.

Revision history for this message
Robin J (robin-jeffries) wrote :

To be clear -- the bug is fixed, so that new subscribers get their address lowercased, but there are existing subscribers with mixed case addresses and mailman crashes when they try to make changes to their record. the goal of this bug is to fix those email addresses.

Revision history for this message
Garima Ahuja (garimaahujaishere) wrote :

Hi I am Garima Ahuja, I am new to Systers. I would like to fix this bug.
I think the fix here should be to take the mixed-case email addresses, make them lowercase and store them temporarily somewhere.
Then drop the column containing these email addresses. Create a new column and fill it using the temporarily stored addresses.
Correct me if I am wrong.
Please guide me how to proceed.

Thanks,
Garima

Revision history for this message
Robin J (robin-jeffries) wrote :

Reiterating. This bug is fixed. The remaining problem (which I think has been fixed, but we need to see if it comes back) is to correct the data of the people whose emails were impacted. That has to be done by someone who has direct access to the database, which is restricted to a small number of people

Rosario Robinson (rosario-robinson)
Changed in systers:
milestone: none → gsocmigration
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.