www/tt-rss: Update to g20250427 f097c5ed97

- Update to g20250427 f097c5ed97 [1]
- UPDATING entry for future mysql removal [2].

[1] https://gitlab.tt-rss.org/tt-rss/tt-rss/-/compare/bfdfea88b988778db59fb112bbd07a4cd2aefd69...f097c5ed97671f66be71e52c13917c23528ba308
[2] https://community.tt-rss.org/t/support-for-mysql-is-no-more/6897

PR:		286734

4 files changed, 29 insertions, 10 deletions

diff --git a/UPDATING b/UPDATING
index c2183a0d2ac6..2e4df7ac89c8 100644
--- a/UPDATING
+++ b/UPDATING
@@ -5,6 +5,18 @@ they are unavoidable.
 You should get into the habit of checking this file for changes each time
 you update your ports collection, before attempting any port upgrades.
 
+20250511:
+  AFFECTS: users of www/tt-rss
+  AUTHOR: dereks@lifeofadishwasher.com
+
+  tt-rss has dropped support for mysql/mariadb starting with commit
+  4cb8a84df46d46b.  The next update (mid-June) to www/tt-rss will include this
+  update.
+
+  https://community.tt-rss.org/t/support-for-mysql-is-no-more/6897
+
+  You should migrate your data to databases/postgresqlXY-server.
+
 20250510:
   AFFECTS: users of net-p2p/bitcoin and/or net-p2p/bitcoin-daemon
   AUTHOR: kbowling@FreeBSD.org
diff --git a/www/tt-rss/Makefile b/www/tt-rss/Makefile
index b6c91f2ef6f8..90f2e16e73ce 100644
--- a/www/tt-rss/Makefile
+++ b/www/tt-rss/Makefile
@@ -1,5 +1,5 @@
 PORTNAME=	tt-rss
-DISTVERSION=	g20250220
+DISTVERSION=	g20250427
 PORTEPOCH=	2
 CATEGORIES=	www
 MASTER_SITES=	LOCAL/meta
@@ -17,11 +17,11 @@ USES=		gettext-tools php:cli,web,flavors shebangfix
 
 USE_GITLAB=	yes
 GL_SITE=	https://gitlab.tt-rss.org
-GL_TAGNAME=	bfdfea88b988778db59fb112bbd07a4cd2aefd69
+GL_TAGNAME=	f097c5ed97671f66be71e52c13917c23528ba308
 # phe json/openssl extension is required but it's statically linked in default php
 USE_PHP=	ctype dom exif fileinfo filter iconv intl mbstring pcntl pdo \
-		phar posix session simplexml sockets tokenizer xml xmlwriter \
-		zip
+		phar posix session simplexml sockets sodium tokenizer xml \
+		xmlwriter zip
 USE_RC_SUBR=	ttrssd
 
 SHEBANG_FILES=	update.php update_daemon2.php
diff --git a/www/tt-rss/distinfo b/www/tt-rss/distinfo
index 8f80c6abb1dc..41aa613d9a2b 100644
--- a/www/tt-rss/distinfo
+++ b/www/tt-rss/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1740342260
-SHA256 (tt-rss-tt-rss-bfdfea88b988778db59fb112bbd07a4cd2aefd69_GL0.tar.gz) = 7424ea2d810ad6d9dd499adcd62e7358f24cda951b493090ee2b05a2bd63e8d8
-SIZE (tt-rss-tt-rss-bfdfea88b988778db59fb112bbd07a4cd2aefd69_GL0.tar.gz) = 8583787
+TIMESTAMP = 1747000425
+SHA256 (tt-rss-tt-rss-f097c5ed97671f66be71e52c13917c23528ba308_GL0.tar.gz) = 996189e8a7acdc5e8b44fb181b0ff7f6ce746acca77a43e300c0af56efa40b6f
+SIZE (tt-rss-tt-rss-f097c5ed97671f66be71e52c13917c23528ba308_GL0.tar.gz) = 8712416
diff --git a/www/tt-rss/pkg-plist b/www/tt-rss/pkg-plist
index 0cbc91f943f5..5818ba98cf63 100644
--- a/www/tt-rss/pkg-plist
+++ b/www/tt-rss/pkg-plist
@@ -36,6 +36,7 @@
 %%WWWDIR%%/classes/Cache_Local.php
 %%WWWDIR%%/classes/Config.php
 %%WWWDIR%%/classes/Counters.php
+%%WWWDIR%%/classes/Crypt.php
 %%WWWDIR%%/classes/Db.php
 %%WWWDIR%%/classes/Db_Migrations.php
 %%WWWDIR%%/classes/Db_Prefs.php
@@ -1979,6 +1980,8 @@
 %%WWWDIR%%/locale/ru_RU/LC_MESSAGES/messages.po
 %%WWWDIR%%/locale/sv_SE/LC_MESSAGES/messages.mo
 %%WWWDIR%%/locale/sv_SE/LC_MESSAGES/messages.po
+%%WWWDIR%%/locale/ta/LC_MESSAGES/messages.mo
+%%WWWDIR%%/locale/ta/LC_MESSAGES/messages.po
 %%WWWDIR%%/locale/tr_TR/LC_MESSAGES/messages.mo
 %%WWWDIR%%/locale/tr_TR/LC_MESSAGES/messages.po
 %%WWWDIR%%/locale/uk_UA/LC_MESSAGES/messages.mo
@@ -2045,7 +2048,6 @@
 %%WWWDIR%%/public.php
 %%WWWDIR%%/schema/ttrss_schema_mysql.sql
 %%WWWDIR%%/schema/ttrss_schema_pgsql.sql
-%%WWWDIR%%/sql/mysql/schema.sql
 %%WWWDIR%%/sql/mysql/migrations/3.sql
 %%WWWDIR%%/sql/mysql/migrations/4.sql
 %%WWWDIR%%/sql/mysql/migrations/5.sql
@@ -2191,7 +2193,9 @@
 %%WWWDIR%%/sql/mysql/migrations/145.sql
 %%WWWDIR%%/sql/mysql/migrations/146.sql
 %%WWWDIR%%/sql/mysql/migrations/147.sql
-%%WWWDIR%%/sql/pgsql/schema.sql
+%%WWWDIR%%/sql/mysql/migrations/148.sql
+%%WWWDIR%%/sql/mysql/migrations/149.sql
+%%WWWDIR%%/sql/mysql/schema.sql
 %%WWWDIR%%/sql/pgsql/migrations/3.sql
 %%WWWDIR%%/sql/pgsql/migrations/4.sql
 %%WWWDIR%%/sql/pgsql/migrations/5.sql
@@ -2337,6 +2341,9 @@
 %%WWWDIR%%/sql/pgsql/migrations/145.sql
 %%WWWDIR%%/sql/pgsql/migrations/146.sql
 %%WWWDIR%%/sql/pgsql/migrations/147.sql
+%%WWWDIR%%/sql/pgsql/migrations/148.sql
+%%WWWDIR%%/sql/pgsql/migrations/149.sql
+%%WWWDIR%%/sql/pgsql/schema.sql
 %%WWWDIR%%/templates.local/index.html
 %%WWWDIR%%/templates/digest_template.txt
 %%WWWDIR%%/templates/digest_template_html.txt
@@ -2407,8 +2414,8 @@
 %%WWWDIR%%/vendor/chillerlan/php-qrcode/src/Data/Hanzi.php
 %%WWWDIR%%/vendor/chillerlan/php-qrcode/src/Data/Kanji.php
 %%WWWDIR%%/vendor/chillerlan/php-qrcode/src/Data/Number.php
-%%WWWDIR%%/vendor/chillerlan/php-qrcode/src/Data/QRData.php
 %%WWWDIR%%/vendor/chillerlan/php-qrcode/src/Data/QRCodeDataException.php
+%%WWWDIR%%/vendor/chillerlan/php-qrcode/src/Data/QRData.php
 %%WWWDIR%%/vendor/chillerlan/php-qrcode/src/Data/QRDataModeAbstract.php
 %%WWWDIR%%/vendor/chillerlan/php-qrcode/src/Data/QRDataModeInterface.php
 %%WWWDIR%%/vendor/chillerlan/php-qrcode/src/Data/QRMatrix.php