On 10/10/25 22:35, Mark Sapiro wrote:
On 10/10/25 12:15 PM, Flo via Mailman-users wrote:
On 10/10/25 20:47, Mark Sapiro wrote:
What do you get from the following database query
SELECT * from django_mailman3_maildomain JOIN django_site ON site_id = django_site.id;
A while ago I have done a bit of database programming, however here I am lost, please help, where should I place this query to get a result?
I think you said your database is sqlite. If so, in the Debian package it is probably at /var/lib/mailman/data/mailman.db. You can point the sqlite3 command at the database and issue the query at the prompt.
:/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>
Flo