Thanks @fox for the fever_api.php patch. Sync now seems to be working again, but I’m seeing this in the apache error log:
[Sat Dec 16 12:56:50.494304 2017] [php7:notice] [pid 78938] [client 127.0.0.1:54604] PHP Notice: Legacy connect requested to pgsql in /Library/Server/Web/Data/Sites/Default/tt-rss/classes/db.php on line 22
Something I need to worry about (or did wrong?). Or just because it’s old code?
Since the update on the newest version I always get the following error:
pi@raspberrypi2:~ $ /var/www/html/tt-rss/update.php --feeds
PHP Notice: Legacy connect requested to mysql in /var/www/html/tt-rss/classes/db.php on line 22
[13:48:49/22728] Lock: update.lock
[13:48:49/22728] Scheduled 10 feeds to update…
[13:48:49/22728] Base feed: tagesschau.de - Die Nachrichten der ARD
[13:48:49/22728] => 2017-12-15 15:00:04, 8 1
PHP Fatal error: Uncaught exception ‘PDOException’ with message ‘There is no active transaction’ in /var/www/html/tt-rss/classes/rssutils.php:1159
Stack trace: #0 /var/www/html/tt-rss/classes/rssutils.php(1159): PDO->commit() #1 /var/www/html/tt-rss/classes/rssutils.php(185): RSSUtils::update_rss_feed(‘8’, true, false) #2 /var/www/html/tt-rss/update.php(168): RSSUtils::update_daemon_common() #3 {main}
thrown in /var/www/html/tt-rss/classes/rssutils.php on line 1159
Im running tiny tiny rss on a raspberry with mysql
if this happens sometimes this could mean you run into concurrent feed updates, if its all the time then idk, could be a bug with tag inserting logic, could be something else
e: i’m yet to run into this problem on my instances but this has been reported before and its not pdo related
When I try to update my feeds via a cron job, I get the following error:
PHP Fatal error: Uncaught PDOException: There is no active transaction in /[...]/tt-rss/classes/rssutils.php:1159
Stack trace:
#0 /[...]/tt-rss/classes/rssutils.php(1159): PDO->commit()
#1 /[...]/tt-rss/classes/rssutils.php(185): RSSUtils::update_rss_feed('67', true, false)
#2 /[...]tt-rss/update.php(168): RSSUtils::update_daemon_common()
#3 {main}
In the error log there is this additional entry: PDOStatement::execute(): SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: 'NOW()' for column 'last_read' at row 1
It seems to an SQL error. My schema is already updated:
update.php --update-schema
Lock: update.lock
checking for updates (mysql)...
update not required.
I’m on commit commit 6fb5f17be69f9ff3a0e1379e64a3c7bd71ab3271 and use the following plugins: define('PLUGINS', 'auth_internal, updater, api_newsplus');
post the stack trace for the NOW() error; also you will likely need to either update or remove the newsplus plugin (search the forum this has been just discussed)