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
_______________________________________________
Mailman-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
Archived at:
https://lists.mailman3.org/archives/list/[email protected]/message/TD4O7SZWGKETWT4MFNNDAXWONH4GCRZM/
This message sent to [email protected]
