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

_______________________________________________
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/4TWJQS5MZOVKPYCO6G6ZH7NDB75CLPFW/

This message sent to [email protected]

Reply via email to