Export / import not working?

Describe the problem you’re having:

Migrating tt-rss to a new VPS. Exported 79 articles, only 3 got imported.

If possible include steps to reproduce the problem:

preferences - feeds - export my data on one server (exported 79 articles)
preferences - feeds - import on second server (processed 79 articles but only 3 show up in starred/published and 0 in archived)

tt-rss version (including git commit id):

e888879a on both servers

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

Debian 9 / php 7.0.27 / postgres 9.6.7 / nginx on both servers

If nothing has actually changed with your setup other than re-locating to a new machine, you could always just dump the database itself and import that. You’d have the benefit of keeping existing articles, users, etc. as well. The import/export plugin is good when you need to migrate (say between mysql and postgresql) or if you’re having difficulties and want a fresh start without losing starred articles.

That being said, did any errors show up or is there anything in the logs?

you could always just dump the database itself and import that

I’ll do just that, thanks.

I don’t see any errors in nginx log. On importing it says processed 79, imported 79 new feeds 0 and yet there is nothing added. If I export immediately after importing I get ‘finished, exported 0 article’.

was this before or after the plugin got reworked to PDO by a recent pull request? i wonder if that broke it

It’s git head is all I know. I can send you the xml.gz if you want.

sure why not, also try temporarily reverting to the revision before the plugin got updated

naboo:tt-rss:$ git log plugins/import_export/init.php
commit 785ffca622b2fa706812e7897225a79994e1034e
Author: Luc Didry <[email protected]>
Date:   Wed May 16 16:45:25 2018 +0200

    plugins/import_export: use PDO

commit 2c51facf61536c07a5ba7845393488c3ba997d80 <-- this one
Author: Andrew Dolgov <[email protected]>
Date:   Tue Jan 30 14:41:27 2018 +0300

    Revert "import_export: do not use DOMDocument->loadXML in static context"

    This reverts commit 1ddf3a28e56d64fa8e80868e731cdde8b2abefa8.


I reverted both installations to 68ef458 and it seems to work.

thanks, i’ll take a look tomorrow i guess.

why test shit before submitting pull requests
too much effort

oh jesus fucking christ

i’m reverting this entire PR for reasons specified here:

https://git.tt-rss.org/fox/tt-rss/pulls/60#issuecomment-198

i’ve updated import_export to use PDO, would appreciate some testing

preferably also with pre-PDO plugin export -> new plugin import

I terminated the old instance aleady so I tested on the same server:

exported 76 articles on 68ef458
unstarred and deleted from archive
updated to 63616430
imported 76 articles

I got this in the tt-rss log:
E_WARNING (2) plugins/import_export/init.php:219 gzuncompress(): data error
but everything seems to work fine