On 7/26/24 1:30 PM, Bryan Fields wrote:
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?
https://nanog-mm3.keekles.org/archives/list/nanog@nanog-mm3.keekles.org/thre...
I had a look at the original MBOX import of this archive is "Date: Mon, 15 Apr 102 15:06:12 CDT". It should likely be 2002 based on the rest of the headers
-- Bryan Fields
727-409-1194 - Voice http://bryanfields.net