Tags diseappear

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
jlebloch
Bear Rating Trainee
Bear Rating Trainee
Posts: 1
Joined: 07 Dec 2015, 11:19

Tags diseappear

Postby jlebloch » 07 Dec 2015, 11:24

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

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Tags diseappear

Postby fox » 07 Dec 2015, 11:31

looks like a bug, when article is updated from source it resets previously manually assigned tags

e: should be fixed by a8ac766.

xtaz
Bear Rating Master
Bear Rating Master
Posts: 174
Joined: 24 Dec 2009, 16:48

Re: Tags diseappear

Postby xtaz » 07 Dec 2015, 13:53

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]

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Tags diseappear

Postby fox » 07 Dec 2015, 15:07

you're right, this should be fixed by 040aa54. sorry about that, i guess.

xtaz
Bear Rating Master
Bear Rating Master
Posts: 174
Joined: 24 Dec 2009, 16:48

Re: Tags diseappear

Postby xtaz » 07 Dec 2015, 15:50

That works. Thanks!


Return to “Support”

Who is online

Users browsing this forum: No registered users and 13 guests