Hello,
I'm pretty new to mailman3, especially it's internals.
I upgraded a (running fine) mailman3 service from NixOS 20.03 https://nixos.wiki/wiki/Mailman
to NixOS 20.09 https://nixos.org/manual/nixos/stable/index.html#module-services-mailman
After the upgrade I got this very same issue: https://gitlab.com/mailman/hyperkitty/-/issues/328
--8<---------------cut here---------------start------------->8---
mailman mailman-web-setup-start[1832]: raise utils.IntegrityError( mailman mailman-web-setup-start[1832]: django.db.utils.IntegrityError: The row in table 'hyperkitty_attachment' with primary key '1' has an invalid foreign key: hyperkitty_attachment.email_id contains a value '7' that does not have a corresponding value in hyperkitty_email__old.id.
--8<---------------cut here---------------end--------------->8---
I was not able to fix the migration issue so I recreated the mailman-web sqlite database (/var/lib/mailman-web) using the "migrate" function.
After that, and after recreating the database many times, I'm getting this error when trying to access the web interface:
--8<---------------cut here---------------start------------->8---
Jan 26 11:34:30 OMISSIS env[18167]: django.db.utils.OperationalError: no such table: django_site
--8<---------------cut here---------------end--------------->8---
Actually the django_site table is in the database so I can't understand why of this message.
Please is there a way to recreate the mailman-web database from scratch or to fix this kind of problems?
Thanks! Giovanni
-- Giovanni Biscuolo