Looks like there are problem with fields marked
and published
. I have pgsql installation and trying to import my starred/archived entities, so I got error that postgres can’t convert 1/0 to boolean.
Query INSERT INTO ttrss_user_entries (ref_id, owner_uid, feed_id, unread, last_read, marked, published, score, tag_cache, label_cache, uuid, note) VALUES (5568, 1, 116, false, NULL, 1, 0, 0, 'kotlin', '', '', '') failed: ERROR: column "marked" is of type boolean but expression is of type integer LINE 5: NULL, 1, 0, 0, 'kotlin', ^ HINT: You will need to rewrite or cast the expression.1. classes/db/pgsql.php(48): user_error(Query INSERT INTO ttrss_user_entries
(ref_id, owner_uid, feed_id, unread, last_read, marked,
published, score, tag_cache, label_cache, uuid, note)
VALUES (5568, 1, 116, false,
NULL, 1, 0, 0, 'kotlin',
'', '', '') failed: ERROR: column "marked" is of type boolean but expression is of type integer
LINE 5: NULL, 1, 0, 0, 'kotlin',
^
HINT: You will need to rewrite or cast the expression., 256)
2. include/db.php(8): query(INSERT INTO ttrss_user_entries
(ref_id, owner_uid, feed_id, unread, last_read, marked,
published, score, tag_cache, label_cache, uuid, note)
VALUES (5568, 1, 116, false,
NULL, 1, 0, 0, 'kotlin',
'', '', ''), 1)
3. plugins/import_export/init.php(374): db_query(INSERT INTO ttrss_user_entries
(ref_id, owner_uid, feed_id, unread, last_read, marked,
published, score, tag_cache, label_cache, uuid, note)
VALUES (5568, 1, 116, false,
NULL, 1, 0, 0, 'kotlin',
'', '', ''))
4. plugins/import_export/init.php(457): perform_data_import(/home/rick/nginx/files/ibragimov.by/root/tsreader/cache/upload/export6rAO8r, 1)
5. classes/pluginhandler.php(12): dataImport()
6. backend.php(126): catchall(dataimport)
I quick fixed plugins/import_export/init.php:357
1/0 → true/false, and this error disappears. But I doesn’t see any starred/archive articles either. Also looks like all imported articles purged after update.
[06:15:18/17988] All done.
[06:15:18/17988] cache/simplepie: removed 0 files.
[06:15:18/17988] cache/feeds: removed 0 files.
[06:15:18/17988] cache/images: removed 0 files.
[06:15:18/17988] cache/export: removed 0 files.
[06:15:18/17988] cache/upload: removed 0 files.
[06:15:18/17988] Removed 0 old lock files.
[06:15:18/17988] Removing old error log entries...
[06:15:18/17988] Feedbrowser updated, 155 feeds processed.
[06:15:19/17988] Purged 5568 orphaned posts. <-- number of imported articles
[06:15:19/17988] Removed 0 (feeds) 0 (cats) orphaned counter cache entries.
My steps:
- export data
- export opml
- import opml
- import data
You can use https://ibragimov.by/tsreader/ with default admin password.