Tiny Tiny RSS: Community

SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x8F\x86Th...'

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/
https://www.oneangrygamer.net/feed/?paged=2 (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

update to latest code first, at least.

Yeah, had hoped to do that already but there’s some stuff I need to do before updating stuff on the box. I’ll update the thread once updated. While somewhat stupid/risky, I temporary updated with the latest rssutils and backed (debug log looks the same, and event log throws the same error with reference to rssutil:893 and backend:123).