I noticed overnight that TT could not set a feed as “updated”, which upon review seems to be related to 1 entry where readability is triggered. Not sure this is bug or if I have other issues on my server (when I need to update next I’ll be changing to PGSQL but this one is stuck with MySQL for now). I got readability on triggering on many feeds daily and have not come across this one before.
I know you did something a year ago that seemed related by coding some strip_utf8mb4 function, not sure is related and if that just needs to be extended or if this is something else alltogether.
The feed in question:
https://www.oneangrygamer.net/feed/
Page 2 – OneAngryGamer (it’s 9 of 10 atm, so will soon be on page 2)
Feed debug log from TT:
[10:36:42/29255] guid 1,https://www.oneangrygamer.net/?p=97524 / SHA1:87e21c474b5fe3856a7586adb207939b64738635
[10:36:42/29255] orig date: 1574208039
[10:36:42/29255] date 1574208039 [2019/11/20 00:00:39]
[10:36:42/29255] title Gears 5 Consulted With Microsoft’s GLEAM Team To Be More “Inclusive”
[10:36:42/29255] link https://www.oneangrygamer.net/2019/11/gears-5-consulted-with-microsofts-gleam-team-to-be-more-inclusive/97524/
[10:36:42/29255] language en
[10:36:42/29255] author Billy D
[10:36:42/29255] num_comments: 0
[10:36:42/29255] looking for tags…
[10:36:42/29255] tags found: industry news,news,pc,videos,xbox one,gears 5,microsoft,sales data,sjws,the coalition,third-person shooter
[10:36:42/29255] done collecting data.
[10:36:42/29255] article hash: ca663d18dc9709df4ad1967c1f2c1d0574a83030 [stored=ca663d18dc9709df4ad1967c1f2c1d0574a83030]
[10:36:42/29255] stored article seems up to date [IID: 19911], updating timestamp only
[10:36:42/29255] guid 1,https://www.oneangrygamer.net/?p=97503 / SHA1:c0604c826edc6c34e4f3f30fbbeed043c99955be
[10:36:42/29255] orig date: 1574202631
[10:36:42/29255] date 1574202631 [2019/11/19 22:30:31]
[10:36:42/29255] title Geoff Keighley Reveals The Game Awards 2019 Nominees
[10:36:42/29255] link https://www.oneangrygamer.net/2019/11/geoff-keighley-reveals-the-game-awards-2019-nominees/97503/
[10:36:42/29255] language en
[10:36:42/29255] author Ethan
[10:36:42/29255] num_comments: 0
[10:36:42/29255] looking for tags…
[10:36:42/29255] tags found: events,news,geoff keighley,industry news,the game awards
[10:36:42/29255] done collecting data.
[10:36:42/29255] article hash: 3030081385c4adf68435bc0d3d0c26da01b382a9 [stored=]
[10:36:42/29255] hash differs, applying plugin filters:
[10:36:42/29255] … Af_Readability
[10:36:42/29255] === 0.0000 (sec)
[10:36:42/29255] … Af_Unburn
[10:36:42/29255] === 0.0000 (sec)
[10:36:42/29255] plugin data: af_readability,af_unburn,
[10:36:42/29255] applying plugin filter actions…
[10:36:42/29255] … Af_Readability: action_inline
[10:36:44/29255] === 2.1130 (sec)
[10:36:44/29255] force catchup:
[10:36:44/29255] base guid [1,https://www.oneangrygamer.net/?p=97503 or SHA1:c0604c826edc6c34e4f3f30fbbeed043c99955be] not found, creating…
System Event Log:
E_ERROR (1) in classes/rssutils.php:859
Uncaught PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x8F\x86Th…’ for column ‘content’ at row 1 in /var/www/html/tt-rss/classes/rssutils.php:859 Stack trace: #0 /var/www/html/tt-rss/classes/rssutils.php(859): PDOStatement->execute(Array) #1 /var/www/html/tt-rss/classes/feeds.php(835): RSSUtils::update_rss_feed(42, true) #2 /var/www/html/tt-rss/backend.php(123): Feeds->update_debugger() #3 {main} thrown
The Setup:
Tiny Tiny RSS v19.2, PHP 7.2, MySQL Ver 14.14 Distrib 5.7.28, Ubuntu 18.04.2 LTS, VPS