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/EntryDAOSQLite.php | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'app/Models/EntryDAOSQLite.php') diff --git a/app/Models/EntryDAOSQLite.php b/app/Models/EntryDAOSQLite.php index c2470f0d6..d46b48f27 100644 --- a/app/Models/EntryDAOSQLite.php +++ b/app/Models/EntryDAOSQLite.php @@ -28,6 +28,12 @@ class FreshRSS_EntryDAOSQLite extends FreshRSS_EntryDAO { return str_replace('INSERT INTO ', 'INSERT OR IGNORE INTO ', $sql); } + #[\Override] + protected static function sqlLimitAll(): string { + // https://sqlite.org/lang_select.html#the_limit_clause + return '-1'; + } + #[\Override] public static function sqlRandom(): string { return 'RANDOM()'; -- cgit v1.2.3