Export / import not working?


#1

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


#2

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?


#3

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’.


#4

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


#5

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


#6

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 <luc@framasoft.org>
Date:   Wed May 16 16:45:25 2018 +0200

    plugins/import_export: use PDO

commit 2c51facf61536c07a5ba7845393488c3ba997d80 <-- this one
Author: Andrew Dolgov <noreply@fakecake.org>
Date:   Tue Jan 30 14:41:27 2018 +0300

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

    This reverts commit 1ddf3a28e56d64fa8e80868e731cdde8b2abefa8.



#7

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


#8

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


#9

why test shit before submitting pull requests
too much effort

oh jesus fucking christ

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


#10

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

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


#11

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