Lars Bjørndal writes:
select * from listarchiver where name = 'mhonarc';
and get:
id | mailing_list_id | name | _is_enabled ----+-----------------+---------+------------- 1 | 2 | mhonarc | f 9 | 4 | mhonarc | f 13 | 5 | mhonarc | f 17 | 6 | mhonarc | f 21 | 8 | mhonarc | f 25 | 9 | mhonarc | f 29 | 10 | mhonarc | f 33 | 7 | mhonarc | f 37 | 11 | mhonarc | f 41 | 12 | mhonarc | f 45 | 13 | mhonarc | f 49 | 14 | mhonarc | f 53 | 16 | mhonarc | f (13 rows)
mailman=#
So which lines should I remove, and how do I do that?
None of them? You have one entry per mailing list, which is as it should be.
Also, your preceding message doesn't complain about the database, it complains
raise ComponentLookupError(interface, name) zope.interface.interfaces.ComponentLookupError: (<InterfaceClass mailman.interfaces.listmanager.IListManager>, '')
That says that "python scriptname.py" need the IListManager interface but can't find it. You didn't provide enough information to explain why that might be, so I'm not going to guess.
Tell us more about the "duplicate entries" error, and if possible copy it exactly from where you found it originally, including any traceback.
Also tell us more about your installation. Is it a distro installation? If so, which one, what version of Mailman? Is it a venv installation? If so, did you activate the venv before invoking "python scriptname.py"? If you didn't, try that and run scriptname again.
Steve