Customized version of FreshRSS, a self-hosted RSS feed aggregator https://git.rdnlsmith.com/fresh-rss-custom/atom?h=1.22.1 2023-10-26T14:33:50+00:00 2023-10-26T14:33:50+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-10-26T14:33:50+00:00 urn:sha1:619d3f54a3faaff1b9adf172e090f36faea408c7 fix https://github.com/FreshRSS/FreshRSS/issues/5749 2023-09-26T20:38:09+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-09-26T20:38:09+00:00 urn:sha1:89a3d36c3e680bcbaf361ff60ca96b3e79f42968 fix https://github.com/FreshRSS/FreshRSS/issues/5668 2023-09-14T18:24:22+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-09-14T18:24:22+00:00 urn:sha1:db53d2655b1771bd32fe2eb2c042b6b89f981c74 fix https://github.com/FreshRSS/FreshRSS/issues/5651 2023-09-14T18:23:56+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-09-14T18:23:56+00:00 urn:sha1:36173608832653ecc1dadb4bdd30e7573675b224 MariaDB requires an `ANALYZE TABLE` to refresh the size information in the metadata. At the same time, include `DATA_FREE` in the calculation. https://mariadb.com/kb/en/information-schema-tables-table/ 2023-09-12T11:44:17+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-09-12T11:44:17+00:00 urn:sha1:0bf33abac8cf83dfece4ccd7f3146c373effae2c * SQL: Same updateCacheUnreads for all DBs Use same SQL update request for MySQL / MariaDB than the one we already used for PostgreSQL / SQLite (i.e. using a sub-query). Testing on a DB of 688MB with 270k entries, 199 feeds, 19 categories, using MySQL 8.1.0. The new SQL update using a sub-query took in average 0.02s, while the old SQL update using a join took in average 0.05s. SQL cache was properly invalidated between each run. The new SQL request is thus about twice faster. Another advantage of the SQL update using a sub-query is that it works identically in PostgreSQL, SQLite, MariaDB, MySQL, so we do need different versions anymore. Contributes to https://github.com/FreshRSS/FreshRSS/issues/5008#issuecomment-1709755370 * Force USE INDEX * Use same SQL methods also for markReadEntries, markReadCat 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-09-06T19:41:17+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-09-06T19:41:17+00:00 urn:sha1:98559cebc367648195080c1588ea197607c216f7 Remove `updateTTL` function used to help migration to 5+ year-old FreshRSS 1.10 and FreshRSS 0.7.3 https://github.com/FreshRSS/FreshRSS/pull/1750 This function contributed to locking the database https://github.com/FreshRSS/FreshRSS/pull/5574 Subset of https://github.com/FreshRSS/FreshRSS/pull/3558 2023-09-05T15:33:38+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-09-05T15:33:38+00:00 urn:sha1:2e1d45a88d2cfd439f4f9e7d92ca9c8cbdb39466 fix https://github.com/FreshRSS/FreshRSS/issues/5632 In the SQL search, parentheses should not be escaped. Escaped parenthesis in the SQL search were tolerated by PostgreSQL but not by SQLite. 2023-09-04T08:09:37+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-09-04T08:09:37+00:00 urn:sha1:1c7c1016f4a5147003ed1c438b8a386a63a53cab * Fix import with empty content fix https://github.com/FreshRSS/FreshRSS/issues/5622 Cherry picks on https://github.com/FreshRSS/FreshRSS/pull/5584 * Fix export of tags / labels Article-defined tags were wrongly exported as user-defined labels. * Fix export of tags / labels Article-defined tags were wrongly exported as user-defined labels. * Fix bug with many labels * Better typing * Comments 2023-08-13T13:11:22+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-08-13T13:11:22+00:00 urn:sha1:d165ed1fb6096d5bd0558d3ed637e53bc728baa7 * Fix hash of articles with loadCompleteContent The detection of modified articles was wrong for feeds using loadCompleteContent. Indeed, the hash is supposed to computed on the content provided by the server of the RSS feed, excluding further modifications. Furthermore, read hash from database instead of recomputing it all the time. Slightly related to https://github.com/FreshRSS/FreshRSS/pull/5574 * Explicit SQL alias * PHPDocs