Tiny Tiny RSS

I discovered another differen GoComics RSS feed URL: http://www.gocomics.com/foxtrotclassics/rss.pxml
Converting it to feedburner worked.

I guess the problem only exists, if SMTP_SERVER is empty (so that mail is sent via system MTA).

Update the ssl library. I had same problem in Debian. It was caused by site having multiple certificates and SHA1 signed one not being trusted anymore. Las ssl update fixed the issue (Debian 8.5 stable upgrade) - "use alternate trust chains" fix.

etu wrote:Dude, you... really used btrfs raid5/6 and not like mdadm-raid or LVM or something in the bottom? I wouldn't do that... just yet... if ever...

Just in case original poster is confused - even then btrfs would not kill actual hard drive. It was going to fail anyway.

Well, good thing about using git is, that you can have your installed version in separate branch, where that commit is reverted. That's what I did. Although there is a danger of merge conflict in future.

It depends of type of unsupported system. In many cases it is much harder to get diagnostics information, because you have much less control over the system. And that's the reason they are unsupported.

It seems, that mysql does not support table aliases in DELETE. DELETE FROM ttrss_entries WHERE NOT EXISTS (SELECT ref_id FROM ttrss_user_entries WHERE ref_id = id) seems to work. But I have no idea, why rows would be different. Because COUNT() = 0 should be when there is no record. I'm probably miss...

I don't know much of PostgreSQL, but in Firebird NOT IN query is one of the worst things to do (because IN is run for every record in main table). But looking at the original query, you probably could get rid of COUNT by making it NOT EXISTS query instead of NOT IN. So original: DELETE FROM ttrss_en...

I suggest this rewrite, but only for performance and clarity. The original query is already giving correct results here, I don't know why the OP is not getting the list of more feeds. SELECT feed_url, site_url, title, COUNT(id) AS subscribers FROM ttrss_feeds WHERE feed_url NOT IN ( SELECT distinct...

I tried that query just right now and causes 2 issues one it returns nothing however if you replace the '' with NULL the query works. This is apparently due to a difference between postgress, oracle and mysql. No, it is not. Those fields are auth_login and auth_pass are varchar fields with NOT NULL...

Is either auth_login or auth_pass NULL? Because that would expain the problem (field being empty, not having value of empty string). But that cannot be true, because those fields are NOT NULL. So only way that query can give any results is, if you are not telling truth about values of those 4 field...

hi, I just ran SELECT * FROM ttrss_feeds WHERE (private IS TRUE OR auth_login != '' OR auth_pass != '' OR feed_url LIKE '%:%@%/%') the result is 28 feeds (non unique). (i know because i crefully entered all feeds and carefgully verified that none are private, auith or pwd (also dumped the database)...

And that "private" is "Hide from popular feeds" checkbox.

Just run following query on yout database and check the values of private, auth_login, auth_pass and feed_url fields in result. SELECT * FROM ttrss_feeds WHERE (private IS TRUE OR auth_login != '' OR auth_pass != '' OR feed_url LIKE '%:%@%/%') Second question why do you want to list 2 the same feeds...

#SELECT DISTINCT title, feed_url, site_url, COUNT(id) AS subscribers FROM ttrss_feeds #WHERE (private IS TRUE OR auth_login != '' OR auth_pass != '' OR feed_url LIKE '%:%@%/%') #GROUP BY title, feed_url, site_url #ORDER BY subscribers DESC LIMIT 1000; It is opposite of original. Even my version wou...