Customized version of FreshRSS, a self-hosted RSS feed aggregator https://git.rdnlsmith.com/fresh-rss-custom/atom?h=1.26.1 2024-08-08T20:56:32+00:00 2024-08-08T20:56:32+00:00 Alexandre Alapetite alexandre@alapetite.fr 2024-08-08T20:56:32+00:00 urn:sha1:e08574a47d33c74eccc0675248a8d83ca205fed2 https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted fix https://github.com/FreshRSS/FreshRSS/issues/6602 And MySQL at the same time https://dev.mysql.com/doc/refman/9.0/en/string-literals.html 2023-10-31T01:01:50+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-10-31T01:01:50+00:00 urn:sha1:ad8bae5acadcda0291c3a6ca579303dbd4053f04 * SQL auto-update field length Follow-up of https://github.com/FreshRSS/FreshRSS/pull/5756 Only for PostgreSQL and MySQL / MariaDB. Not possible for SQLite * Account for MySQL 65535 Partial revert of https://github.com/FreshRSS/FreshRSS/pull/5756 > The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead. 2023-10-30T20:10:09+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-10-30T20:10:09+00:00 urn:sha1:21a279179a5e496082f4e43c5a2a5e10d90c0bdb * Ready for year 2038 Fix https://github.com/FreshRSS/FreshRSS/discussions/5569 Requires PHP on a 64-bit platform to take advantage of it. https://en.wikipedia.org/wiki/Year_2038_problem * Allows dates past 2038 Rework of https://github.com/FreshRSS/FreshRSS/pull/3259 https://github.com/FreshRSS/FreshRSS/issues/3258 * Auto alter columns * Changelog 2023-10-30T19:47:50+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-10-30T19:47:50+00:00 urn:sha1:0324df6f889f18500cc8d201fdc2845f3e4d1acf * SQL increase length of VARCHAR fields Increase length of all fields, keeping the limits for: * Unique indexes on UTF-8: 191 bytes for MySQL; * Unique indexes on ASCII: 767 bytes for MySQL; * Max URL for external tools: 32768 characters; * Max VARCHAR: 65535 bytes for MySQL; Follow-up of https://github.com/FreshRSS/FreshRSS/pull/5038 Fix https://github.com/FreshRSS/FreshRSS/issues/4986 * Fix length test 2023-09-12T08:43:14+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-09-12T08:43:14+00:00 urn:sha1:f050a94b48499286abfb4b69f3bcb3dee5f9ea2d Should help with some DB lock issues. Complete https://github.com/FreshRSS/FreshRSS/pull/3558 after https://github.com/FreshRSS/FreshRSS/pull/5625 already cherry-picked from it. * Removed auto-update of MySQL GUID case sensitivity https://github.com/FreshRSS/FreshRSS/pull/2078 * Contributed to a DB lock in https://github.com/FreshRSS/FreshRSS/issues/5008 Also removed the following non-problematic auto-updates, simply because they were older than the above ones * Auto-create custom labels (1.12.0) https://github.com/FreshRSS/FreshRSS/pull/2027 * Auto-add JSON column for feeds (1.11.0) https://github.com/FreshRSS/FreshRSS/pull/1838 * Auto-create temporary tables (1.7.0) https://github.com/FreshRSS/FreshRSS/pull/1470 2023-01-26T07:13:38+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-01-26T07:13:38+00:00 urn:sha1:2f027545226eca238a6a80021cb3ac0e60b51696 * Increase max feed URL length and drop unicity #fix https://github.com/FreshRSS/FreshRSS/issues/4338 Drop the unicity constraint on our feed URL. In practice, this did not add much value as identical feeds could have different URLs. And it generated several problems, for instance during renaming or automatic redirections such as from HTTP to HTTPS, with collisions for which we dot not have any elegant handling. I have kept a high limit of 32768 because cURL does not seem to have any limit except memory, which might lead to memory problems. This is the highest server-side value reported by https://www.sistrix.com/ask-sistrix/technical-seo/site-structure/url-length-how-long-can-a-url-be * Same for Web site URL For consistency 2022-07-19T13:17:08+00:00 Alexandre Alapetite alexandre@alapetite.fr 2022-07-19T13:17:08+00:00 urn:sha1:0866fdaee85bc8530437436abe7f8536b8b0f4f0 * Add database field attributes for entries Just like we already have for categories, feeds, etc. No core use yet, but allows in particular extensions to save per-entry data * Fix PHPStand * Fix wrong variable 2022-07-04T07:53:26+00:00 Alexandre Alapetite alexandre@alapetite.fr 2022-07-04T07:53:26+00:00 urn:sha1:509c8cae6381ec46af7c8303eb92fda6ce496a4a * Dynamic OPML draft #fix https://github.com/FreshRSS/FreshRSS/issues/4191 * Export dynamic OPML http://opml.org/spec2.opml#1629043127000 * Restart with simpler approach * Minor revert * Export dynamic OPML also for single feeds * Special category type for importing dynamic OPML * Parameter for excludeMutedFeeds * Details * More draft * i18n * Fix update * Draft manual import working * Working manual refresh * Draft automatic update * Working Web refresh + fixes * Import/export dynamic OPML settings * Annoying numerous lines in SQL logs * Fix minor JavaScript error * Fix auto adding new columns * Add require * Add missing 🗲 * Missing space * Disable adding new feeds to dynamic categories * Link from import * i18n typo * Improve theme icon function * Fix pink-dark 2022-05-26T21:22:06+00:00 Alexandre Alapetite alexandre@alapetite.fr 2022-05-26T21:22:06+00:00 urn:sha1:516f0c090c714d173dbaa945dce6a8d8593f6425 Revert SQLite part of https://github.com/FreshRSS/FreshRSS/pull/4387 https://github.com/FreshRSS/FreshRSS/pull/4347 Apparently INT and INTEGER are not perfectly synonym in SQLite! > An INTEGER PRIMARY KEY column is an alias for the rowid, but an INT PRIMARY KEY column is not. https://www.sqlite.org/stricttables.html#strict_tables 2022-05-23T08:45:44+00:00 Alexandre Alapetite alexandre@alapetite.fr 2022-05-23T08:45:44+00:00 urn:sha1:8668ca7230e9198981e33f9882a6030c1733e7f3 #fix https://github.com/FreshRSS/FreshRSS/issues/4386 Forgotten from https://github.com/FreshRSS/FreshRSS/pull/4347