Page 1 of 1

Tags diseappear

Posted: 07 Dec 2015, 11:24
by jlebloch
Dear all,

I use TT-RSS for my job, and I need to use tags to identify some RSS articles. However, these tags frequently diseappear, and I don't know why. My colleagues have the same problem. For instance, last week, on 20 articles i tagged, only 2 have memorized the new tag, an so I have to check again for the 18 missing article. I use coma to separate tags : tag1, tag2, etc...

We use chrome as browser. Do anyone has an idea to solve this problem?
Thanks
Jérôme

Re: Tags diseappear

Posted: 07 Dec 2015, 11:31
by fox
looks like a bug, when article is updated from source it resets previously manually assigned tags

e: should be fixed by a8ac766.

Re: Tags diseappear

Posted: 07 Dec 2015, 13:53
by xtaz
Sorry to hijack the thread a little but it appears that this commit has stopped any of my feeds from updating. Postgresql is logging the error below. Reverting this commit fixes the problem and feeds start updating again without any errors logged.

Code: Select all

Dec  7 10:37:28 tao postgres[57507]: [894-1] WARNING:  there is no transaction in progress
Dec  7 10:37:28 tao postgres[57507]: [895-1] ERROR:  syntax error at end of input at character 93
Dec  7 10:37:28 tao postgres[57507]: [895-2] STATEMENT:  UPDATE ttrss_user_entries
Dec  7 10:37:28 tao postgres[57507]: [895-3]                                    SET tag_cache = '' WHERE ref_id
= '41496'
Dec  7 10:37:28 tao postgres[57507]: [895-4]                                    AND owner_uid =
Dec  7 10:37:28 tao postgres[57507]: [896-1] WARNING:  there is no transaction in progress
Dec  7 10:37:28 tao postgres[57507]: [897-1] ERROR:  syntax error at end of input at character 85
Dec  7 10:37:28 tao postgres[57507]: [897-2] STATEMENT:  SELECT tag_cache FROM ttrss_user_entries
Dec  7 10:37:28 tao postgres[57507]: [897-3]                                    WHERE ref_id = '40931' AND owner
_uid =
Dec  7 10:37:28 tao postgres[57507]: [898-1] WARNING:  there is no transaction in progress
Dec  7 10:37:28 tao postgres[57507]: [899-1] ERROR:  invalid input syntax for integer: "" at character 169
Dec  7 10:37:28 tao postgres[57507]: [899-2] STATEMENT:  SELECT DISTINCT tag_name,
Dec  7 10:37:28 tao postgres[57507]: [899-3]                            owner_uid as owner FROM
Dec  7 10:37:28 tao postgres[57507]: [899-4]                            ttrss_tags WHERE post_int_id = (SELECT i
nt_id FROM ttrss_user_entries WHERE
Dec  7 10:37:28 tao postgres[57507]: [899-5]                            ref_id = '40931' AND owner_uid = '' LIMI
T 1) ORDER BY tag_name


In the ttrss error log I am seeing this:

Code: Select all

Query UPDATE ttrss_user_entries SET tag_cache = '' WHERE ref_id = '744' AND owner_uid = failed: ERROR: syntax error at end of input LINE 3: AND owner_uid = ^ [Last query: UPDATE ttrss_user_entries SET tag_cache = '' WHERE ref_id = '744' AND owner_uid = ]1. classes/db/pgsql.php(50): user_error(Query UPDATE ttrss_user_entries
SET tag_cache = '' WHERE ref_id = '744'
AND owner_uid = failed: ERROR: syntax error at end of input
LINE 3: AND owner_uid =
^, 256)
2. classes/db.php(70): query(UPDATE ttrss_user_entries
SET tag_cache = '' WHERE ref_id = '744'
AND owner_uid = , 1)
3. include/db.php(8): query(UPDATE ttrss_user_entries
SET tag_cache = '' WHERE ref_id = '744'
AND owner_uid = , 1)
4. include/functions2.php(1128): db_query(UPDATE ttrss_user_entries
SET tag_cache = '' WHERE ref_id = '744'
AND owner_uid = )
5. include/rssfuncs.php(704): get_article_tags(744)
6. include/rssfuncs.php(205): update_rss_feed(14, 1, )
7. update.php(187): update_daemon_common(50)
      10:37
E_WARNING (2)   classes/db/pgsql.php:56   pg_fetch_assoc() expects parameter 1 to be resource, boolean given [Last query: SELECT DISTINCT tag_name, owner_uid as owner FROM ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE ref_id = '744' AND owner_uid = '' LIMIT 1) ORDER BY tag_name]

Re: Tags diseappear

Posted: 07 Dec 2015, 15:07
by fox
you're right, this should be fixed by 040aa54. sorry about that, i guess.

Re: Tags diseappear

Posted: 07 Dec 2015, 15:50
by xtaz
That works. Thanks!