On Sat, 2023-09-23 at 18:56 -0700, Mark Sapiro wrote: On 9/23/23 17:51, Mark wrote:
For example, on searching for the word "Derbyshire" (which is mentioned in one of the archived messages) the results page displays:
"Sorry no email could be found for this query."
The logs show:
+++++++++++++++++++++++++++++++++++++ /var/log/mailman3/web/mailman-web.log +++++++++++++++++++++++++++++++++++++
[pid: 1156|app: 0|req: 55/55] 2001:8004:5310:2405:ce66:5ff:41fc:60db () {76 vars in 1537 bytes} [Sat Sep 23 23:57:43 2023] GET /mailman3/hyperkitty/search?mlist=LISTNAME- 1%40DOMAIN.COM&q=Derbyshire => generated 13752 bytes in 3188 msecs (HTTP/1.1 200) 5 headers in 164 bytes (1 switches on core 0)
...
mlist = MailingList.objects.get(name=mlist_name) File "/usr/lib/python3/dist- packages/django/db/models/manager.py", line 82, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 406, in get raise self.model.DoesNotExist( hyperkitty.models.mailinglist.MailingList.DoesNotExist: MailingList2023-09-21 08:55:36.385239+10 matching query does not exist.
What does this database query return
select * from hyperkitty_mailinglist where name like
'LISTNAME-1@DOMAIN.COM';
If it returns a row, does case match for the name in the row and the query?
Yes, the query returns a result and the case in "name" matches that in the query ...
select * from hyperkitty_mailinglist where name like 'listname@domain.com'
id | 91 name | listname@domain.com display_name | Listname description | ... subject_prefix | [Listname] archive_policy | 1 created_at | 2023-09-21 08:55:36.385239+2 list_id | listname@domain.com