After I’ve done migration from MySQL to Postgre into Docker, I logged into TT-RSS UI,
it stops while loading the feeds:
[04-Oct-2022 02:30:48 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42883]: Undefined function: 7 ERROR: function substring_for_date(timestamp with time zone, integer, integer) does not exist
LINE 1: …T “id”, “title”, “last_error”, “update_interval”, SUBSTRING_…
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts. in /var/www/html/tt-rss/vendor/j4mie/idiorm/idiorm.php:505
Stack trace:
#0 /var/www/html/tt-rss/vendor/j4mie/idiorm/idiorm.php(505): PDOStatement->execute()
#1 /var/www/html/tt-rss/vendor/j4mie/idiorm/idiorm.php(1909): ORM::_execute()
#2 /var/www/html/tt-rss/vendor/j4mie/idiorm/idiorm.php(718): ORM->_run()
#3 /var/www/html/tt-rss/vendor/j4mie/idiorm/idiorm.php(729): ORM->_find_many()
#4 /var/www/html/tt-rss/vendor/j4mie/idiorm/idiorm.php(705): ORM->find_result_set()
#5 /var/www/html/tt-rss/classes/pref/feeds.php(305): ORM->find_many()
#6 /var/www/html/tt-rss/classes/pref/feeds.php(113): Pref_Feeds->_makefeedtree()
#7 /var/www/html/tt-rss/backend.php(136): Pref_Feeds->getfeedtree()
}
The database looks fine. It seems like there is a difference between MySQL and PostgreSQL stored somewhere in the database? Ultimately I don’t know what to do.
Tiny Tiny RSS v22.04-b17b4a4
Debian 11 , PHP 8.1, MariaDB 10.4
Thanks.