On Wed, Nov 06, 2024 at 08:24:35AM +0000, Mikolaj Kucharski wrote:
> Hi,
> 
> While browsing generated HTML pages, I've noticed that some ports have
> categories duplicated. Initially I saw this with devel/apktool. With
> below diff, categories are unique.
> 
> 
> Index: Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/ports-readmes/Makefile,v
> retrieving revision 1.12
> diff -u -p -u -r1.12 Makefile
> --- Makefile	11 Mar 2022 18:31:37 -0000	1.12
> +++ Makefile	6 Nov 2024 08:20:16 -0000
> @@ -1,7 +1,7 @@
>  COMMENT =		readmes.html
>  
>  PKG_ARCH = *
> -DISTNAME =		ports-readmes-3.1
> +DISTNAME =		ports-readmes-3.2
>  DISTFILES =
>  
>  CATEGORIES =		databases
> Index: files/make-readmes
> ===================================================================
> RCS file: /cvs/ports/databases/ports-readmes/files/make-readmes,v
> retrieving revision 1.9
> diff -u -p -u -r1.9 make-readmes
> --- files/make-readmes	11 Mar 2022 18:31:37 -0000	1.9
> +++ files/make-readmes	6 Nov 2024 08:20:16 -0000
> @@ -108,7 +108,7 @@ $not_for->bind_columns(\($arch));
>  
>  my $category;
>  my $cat_req = $db->prepare(
> -	q{select
> +	q{select distinct
>  		_categorykeys.value
>  	    from _categories
>  	    	join _categorykeys on _categorykeys.keyref=_categories.value
> 
> -- 
> Regards,
>  Mikolaj
> 
> 
looks good to me.

I would usually recommend using ports-readmes-dancer instead, but whatever