Hi,

Running when a command like

	hut lists archive -l ~emersion/hut-dev -d 5 > archive.mbox
	mutt -f archive.mbox

shows that every mail is duplicated several times.

It looks like it's making a GET request to
https://lists.sr.ht/query/list/10793.mbox
not sure if the bug is before or after that.

cc Thorben who wrote this

On Thu, Jan 25, 2024 at 11:55:13AM +0100, Johannes Altmanninger wrote:
> cc Thorben who wrote this

I swear I am innocent, Drew wrote the backend!

> Hi,
>
> Running when a command like
>
> 	hut lists archive -l ~emersion/hut-dev -d 5 > archive.mbox
> 	mutt -f archive.mbox
>
> shows that every mail is duplicated several times.

Some quick investigation shows, that the mails are duplicated times the
number of subscriptions to the mailing list.
This is caused by this line in the SQL query [1].
I am honestly not sure why it is there even, seems unused.
Maybe Simon has an idea?

[1]: https://git.sr.ht/~sircmpwn/lists.sr.ht/tree/af91e37ea15ee0da4056867c0be03e2628900b07/item/api/server.go#L186

This problem is fixed with the next lists.sr.ht deployment:
https://git.sr.ht/~sircmpwn/lists.sr.ht/commit/c98bfc015ada8024dc95a8b6efab25ca43a1c1a2