Hello !
After a fresh installation on a Centos 7 VPS running PHP 5.4.16, I noticed that I could not import my OPML file. The feeds would not get added. Then logging in as Admin, I noticed a bunch of errors in the System tab (very useful, thanks for adding this!)
Uncaught exception 'PDOException' with message 'There is no active transaction' in /var/www/html/tinytinyrss/classes/opml.php:592 Stack trace: #0 /var/www/html/tinytinyrss/classes/opml.php(592): PDO->commit() #1 /var/www/html/tinytinyrss/classes/dlg.php(25): Opml->opml_import(1) #2 /var/www/html/tinytinyrss/backend.php(123): Dlg->importOpml() #3 {main} thrown PDOStatement::execute(): SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`tinytinyrss`.`ttrss_filters2_actions`, CONSTRAINT `ttrss_filters2_actions_ibfk_1` FOREIGN KEY (`filter_id`) REFERENCES `ttrss_filters2` (`id`) ON DELETE CASCADE) 1. classes/opml.php(474): execute(Array) 2. classes/opml.php(542): opml_import_filter([DOMElement]) 3. classes/opml.php(525): opml_import_category([DOMDocument], [DOMElement], 1, 0) 4. classes/opml.php(591): opml_import_category([DOMDocument], , 1, ) 5. classes/dlg.php(25): opml_import(1) 6. backend.php(123): importOpml()
I’m no PHP or database Guru but it looks like an incompatibility of some sort. Strange thing is that the previous TTRSS setup worked on the same VPS, I just wanted to upgrade it because it had been 3 years without update…
Am I missing something?
Thanks!!