Tiny Tiny RSS: Community

Integrity constraint violation after fresh install on Centos 7 VPS


#1

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!!


#2

you can PM me your OPML, i’ll take a look (tomorrow, most likely)