Filter settings inconsistency in prefs page [Solved]

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

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

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

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

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

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

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.

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

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