On 10/11/25 00:18, Mark Sapiro wrote:
On 10/10/25 1:47 PM, Flo via Mailman-users wrote:
:/var/lib/mailman3/data# sqlite3 mailman.db SQLite version 3.46.1 2024-08-13 09:16:08 Enter ".help" for usage hints. sqlite> SELECT * from django_mailman3_maildomain JOIN django_site ON site_id = django_site.id; Parse error: no such table: django_mailman3_maildomain sqlite>
Is there a second database? Something like mailmanweb.db. If so, use that one.
I found it, it's in a different directory:
/var/lib/mailman3/web# sqlite3 mailman3web.db SQLite version 3.46.1 2024-08-13 09:16:08 Enter ".help" for usage hints. sqlite> SELECT * from django_mailman3_maildomain JOIN django_site ON site_id = django_site.id; ... ... 8|lists.example.com|7|7|Lists of Example|lists.example.com sqlite>
The two working domains are first (...) . The problematic domain (renamed to lists.example.com) appears when I create it in Postorius.
For me the only conspicuous is that the numbers are 8|.|7|7 while at the other two entries they are the same for the whole line: 2|.|2|2 and 4|.|4|4 .
Flo