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