Last_error's Incorrect string value error

Tiny Tiny RSS Support
1

Hello

I have getting this error every 10min about, after updating (v19.2 - e981d52).
Other functions are well. How can I fix it?
…

[Event log]

SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xE9\x0A’ for column ‘last_error’ at row 1

#0 /var/www/tt-rss/classes/rssutils.php(1170): PDOStatement->execute(Array)
#1 /var/www/tt-rss/classes/rssutils.php(148): RSSUtils::update_rss_feed(‘76’, true, false)
#2 /var/www/tt-rss/update.php(205): RSSUtils::update_daemon_common(50)
#3 {main}
…

tt-rss version (including git commit id):
v19.2 (e981d52)
…

Platform (i.e. Linux distro, PHP, PostgreSQL, etc) versions:
CentOS 7
MySQL 8.0.16
PHP 7.3.4

2

Please check the sticky post about reporting errors, especially the last paragraph on how to debug a specific feed and post the output here.

3

Sorry.
I had skipped this, because no Feed with error displayed in setting page.
I’ll try to detect problematic feed first.

Thanks.

4

looks like it’s another place where non-unicode string may leak out of feed parser, thanks entirely to DOMDocument exceptions. i’ll try to take a look at this tomorrow.

you can find problematic feed by its id (76) in ttrss_feeds table or simply in the UI by opening tt-rss/index.php#f=76 in the browser.

5

Thanks, and apologize my poor skills.

Error is always id 76. I unsbscrive this feed, and then never show again same error log.
This feed include some errors, detail is below.

[RSS URL]
http://blog.btrax.com/jp/feed/

[Parsing Error]
Error: LibXML error 63 at line 476 (column 3074): CData section not finished
1日のうち、スクリーンを見てない時�

Error: LibXML error 63 at line 476 (column 3074): CData section not finished
1日のうち、スクリーンを見てない時�

Error: LibXML error 9 at line 476 (column 3074): PCDATA invalid Char value 8

Error: LibXML error 62 at line 476 (column 5816): Sequence ‘]]>’ not allowed in content

Error: LibXML error 62 at line 476 (column 5816): Sequence ‘]]>’ not allowed in content

Error: LibXML error 1 at line 476 (column 5816): internal error: detected an error in element content
…

My case is solved (I seldom read that feed unsbscrived). And this may not caused by updating TT-RSS. Should I add title solved?

6

fix for tt-rss error: https://git.tt-rss.org/fox/tt-rss/commit/9423d72f6c82f05a5c7512370ac413776747f540

won’t fix the actual feed because it has broken XML but at least tt-rss should not fail unexpectedly when trying to assign the error message anymore. thanks for reporting.

7

deleted as the admin said

8

“libxml refuses to parse an XML document with invalid unicode characters and broken markup… i guess utf-8 is the problem here”

please stop posting, your ignorance is giving me a headache.