On 7/25/24 7:04 PM, Mark Sapiro wrote:
On 7/25/24 11:20, Bryan Fields wrote:
When this happens, I get an email error below.
This is really wierd. See below.
line 88, in reverse return resolver._reverse_with_prefix(view, prefix, *args, **kwargs) File "/opt/mailman/venv/lib/python3.10/site-packages/django/urls/resolvers.py", line 828, in _reverse_with_prefix raise NoReverseMatch(msg)
Exception Type: NoReverseMatch at /archives/list/nanog@nanog-mm3.keekles.org/ Exception Value: Reverse for 'hk_archives_with_month' with keyword arguments '{'year': 999, 'mlist_fqdn': 'nanog@nanog-mm3.keekles.org', 'month': 12}' not found. 2 pattern(s) tried: ['archives/list/(?P<mlist_fqdn>[^/@]+@[^/@]+)/(?P<year>\\d{4})/(?P<month>\\d\\d?)/$', 'hyperkitty/list/(?P<mlist_fqdn>[^/@]+@[^/@]+)/(?P<year>\\d{4})/(?P<month>\\d\\d?)/$'] Raised during: hyperkitty.views.mlist.overview
It appears to be trying to get the threads for December, 999.
What do these queries show?
SELECT * FROM hyperkitty_thread WHERE EXTRACT(year FROM date_active) < 1000;
SELECT id FROM hyperkitty_email WHERE EXTRACT(year FROM date) < 1000;
mailman=> \c mailmanweb You are now connected to database "mailmanweb" as user "mailman". mailmanweb=> SELECT * FROM hyperkitty_thread WHERE EXTRACT(year FROM date_active) < 1000; id | thread_id | date_active | category_id | mailinglist_id | starting_email_id -------+----------------------------------+------------------------+-------------+----------------+------------------- 35670 | GHLCKUC7TDEBAI27SKRQN5PWX3TGB26Q | 0102-04-15 20:06:12+00 | | 3 | 150555 (1 row)
mailmanweb=> SELECT id FROM hyperkitty_email WHERE EXTRACT(year FROM date) < 1000; id
136872 150555 (2 rows)
Does this mean it imported archives with an invalid date somehow?
Thanks,
Bryan Fields
727-409-1194 - Voice http://bryanfields.net