1

Hello, I just noticed that filter informations are different of “filter page” and of “Edit Filter”

Please look at screenshot:
https://pasteboard.co/GFa6saA.png OR https://ctrlv.cz/Eqyc
Information on the left (filter page) is correct, and working. But information on the right are invalid.

Problem is that filter is now working fine, but if I want to edit filter, I need to completely re-done it.
I found a few more filters with the same error, but I have not found any connection.

Anything I can do to debug it? Thank you.

tt-rss version :
Tiny Tiny RSS v17.4 (22adcd7) (14 days old)
Ubuntu 16.04 PHP 7,PostgreSQL
Browser: Google Chrome 59 Windows

2

it is possible that your filter got corrupted when the transition to filters supporting multiple feeds took place or for some reason legacy format is not detected by tt-rss

if you want you can email me your database dump (don’t exclude any tables so i could see the whole picture) so i could take a look

e: most likely it’s some edge case i missed because it shows normally in filter list so the database structure is supposedly intact

3

Hello Fox, thanks for fast reply.

I will try sit down and rework filters (and when I’m doing it, do a summer cleanup :slight_smile: )

My DB is pretty big (couple GB - I have purge set to 9999), so I would prefer not to send - but in the evening I try to see if I find anything interesting in it.

EDIT: I will wait with reworking until I find out more.
EDIT2: Maybe problem was caused by czech characters is filter name? (čřžýá…)

Thanks

4

you can try dumping filter-related tables only although i’m not promising anything in that case

5

Hi Fox,

I tried find something interesting in related related tables, and this is it… I think :slight_smile:

In table public.ttrss_filters2_rules all filters with error on web interface have null in match_on column
https://pasteboard.co/GFb5ZO6.png

I sent table dump to your gmail. Thanks for looking at it

6

this is probably related to the bug, thanks, i’ll take a look a bit later (sunday most likely)

7

Thanks, take your time :slight_smile:

In fact, all my filters are wrong, except for a few, so the manual repair would take a huge amount of time.
I have a month old export of virtual machine, so in emergency I maybe can dig out some previous versions of this table.

8

match_on being null actually only means this is a legacy format filter rule. i think i managed to replicate the issue though.

e: and it’s a bug https://git.tt-rss.org/git/tt-rss/commit/edefcec19d43c261c5bd5ee7382149581757058e

9

Thank you Fox, you’re best :slight_smile:

I just did update and it looks fixed. I and afters now can be edited. Thanks!

Before fix:
https://pasteboard.co/GFa6saA.png
After fix:
https://pasteboard.co/GFEMBr1.png