Tiny Tiny RSS: Community

DB schema 134->135: Invalid text representation


#1

Describe the problem you’re having:

After update of DB schema 134->135

Event log starts adding

E_USER_NOTICE (1024) /var/www/html/xxx/classes/rssutils.php:788 SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: “”
#0 /var/www/html/xxx/classes/rssutils.php(788): PDOStatement->execute(Array)
#1 /var/www/html/xxx/classes/rssutils.php(190): RSSUtils::update_rss_feed(78, true, false)
#2 /var/www/html/xxx/update.php(209): RSSUtils::update_daemon_common(50)
#3 {main} 20:47

E_USER_NOTICE (1024) /var/www/html/xxx/classes/rssutils.php:788 SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: “”
#0 /var/www/html/xxx/classes/rssutils.php(788): PDOStatement->execute(Array)
#1 /var/www/html/xxx/classes/rssutils.php(190): RSSUtils::update_rss_feed(72, true, false)
#2 /var/www/html/xxx/update.php(209): RSSUtils::update_daemon_common(50)
#3 {main} 20:45

(…)

Log was clean before

If possible include steps to reproduce the problem:

happens by itself

tt-rss version (including git commit id):

Tiny Tiny RSS v18.12 (4cbc62d)

Platform (i.e. Linux distro, PHP, PostgreSQL, etc) versions:

PHP 7.2.10-0ubuntu0.18.04.1
postgres (PostgreSQL) 10.4 (Debian 10.4-2.pgdg90+1)


#2

this would be a case of my bad

and even this

like i said, my bad

in my defense the whole (?,?,?,?,?) shit you need to do with pdo (and only pdo) is terribly dumb


#3

Problem no longer exists on Tiny Tiny RSS v18.12 (a68b150)