need to fix corrupted database items on systers

[Robin J]

We've finally fixed (and pushed) the bug that caused people's SQL database email address to get out of sync with their mailman email address when they changed their address (making it impossible for them to get systers email any more). Now we need to fix the database (this probably applies to all lists on systers.org, not just systers).

Here are some leftover instructions on how to find the problem children. Kathy, if you can run this, and add the results to the bug report (there shouldn't be more people being added, as presumably we have fixed the problem), then I can try to fix them manually. (The bad data is in the SQL database, so we can fix it by doing sql commands). I hope there aren't a large number of such people.

The script is on artemis (and on abiwt.org). Located here:

/usr/local/mailman/bin/find_problems.py

to run you need to give it a list name:

find_problems.py <listname>

The output is to the screen -- shows both db and pck file. - Try running on abiwt.org to get an idea of what the output will be.

You can, of course, | the output to a file.

To make corrections:

# psql -U mailman <listname>

<enter pw>

update subscriber set mailman_key='thecorrectedemailaddress' WHERE mailman_key='incorrectname';

Don't forget the WHERE or the entire db gets hosed ;>!

It might be a good idea to just dump the db before proceeding and we can reload if necessary.

PSQL Datadump for Custom DB and write to file

Syntax: sudo pg_dump –a [listname] –U mailman –f /[dir]/[filename]

Example: sudo pg_dump -a systers -U mailman -f /home/kathyg/systers_custom_db_Jul2009