From 29446a29f58b484817e6c9798c736e5f531c21ee Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Sun, 14 Sep 2025 22:36:01 +0200 Subject: Recovery: skip broken entries during CLI export/import (#7949) * Recovery: skip broken entries during CLI export/import fix https://github.com/FreshRSS/FreshRSS/discussions/7927 ``` 25605/25605 (48 broken) ``` Help with *database malformed* or other corruption. * Compatibility multiple databases --- app/Models/EntryDAOPGSQL.php | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'app/Models/EntryDAOPGSQL.php') diff --git a/app/Models/EntryDAOPGSQL.php b/app/Models/EntryDAOPGSQL.php index e7999f601..68b52d071 100644 --- a/app/Models/EntryDAOPGSQL.php +++ b/app/Models/EntryDAOPGSQL.php @@ -23,6 +23,12 @@ class FreshRSS_EntryDAOPGSQL extends FreshRSS_EntryDAOSQLite { return rtrim($sql, ' ;') . ' ON CONFLICT DO NOTHING'; } + #[\Override] + protected static function sqlLimitAll(): string { + // https://www.postgresql.org/docs/current/queries-limit.html + return 'ALL'; + } + #[\Override] public static function sqlRandom(): string { return 'RANDOM()'; -- cgit v1.2.3