Search found 37 matches

by virgo
24 Jan 2017, 21:57
Forum: Themes and plugins
Topic: Make GoComics work again plugin
Replies: 33
Views: 12707

Re: Make GoComics work again plugin

I discovered another differen GoComics RSS feed URL: http://www.gocomics.com/foxtrotclassics/rss.pxml
Converting it to feedburner worked.
by virgo
28 Dec 2016, 13:09
Forum: Development
Topic: PHPMailer Vulnerability CVE-2016-10033
Replies: 13
Views: 4703

Re: PHPMailer Vulnerability CVE-2016-10033

I guess the problem only exists, if SMTP_SERVER is empty (so that mail is sent via system MTA).
by virgo
03 Aug 2016, 07:50
Forum: Support
Topic: SSL Issue: 60 SSL certificate problem: unable to get local issuer certificate
Replies: 3
Views: 3312

Re: SSL Issue: 60 SSL certificate problem: unable to get local issuer certificate

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.
by virgo
10 Nov 2015, 11:01
Forum: Support
Topic: feedtree: don't hide feeds with errors
Replies: 3
Views: 6164

Re: feedtree: don't hide feeds with errors

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.
by virgo
23 Sep 2015, 12:25
Forum: Unsupported platforms
Topic: Unsupported Platforms: what are the disadvantages?
Replies: 7
Views: 8562

Re: Unsupported Platforms: what are the disadvantages?

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.
by virgo
15 Jul 2015, 13:09
Forum: Support
Topic: Performance Regression (article purge)
Replies: 8
Views: 4321

Re: Performance Regression (article purge)

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...
by virgo
15 Jul 2015, 12:33
Forum: Support
Topic: Performance Regression (article purge)
Replies: 8
Views: 4321

Re: Performance Regression (article purge)

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...
by virgo
18 May 2015, 21:57
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 16842

Re: feedbrowser (popularfeeds etc..) issue

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...
by virgo
18 May 2015, 21:50
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 16842

Re: feedbrowser (popularfeeds etc..) issue

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...
by virgo
18 May 2015, 20:18
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 16842

Re: feedbrowser (popularfeeds etc..) issue

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...
by virgo
18 May 2015, 20:04
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 16842

Re: feedbrowser (popularfeeds etc..) issue

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)...
by virgo
18 May 2015, 18:28
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 16842

Re: feedbrowser (popularfeeds etc..) issue

And that "private" is "Hide from popular feeds" checkbox.
by virgo
18 May 2015, 18:18
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 16842

Re: feedbrowser (popularfeeds etc..) issue

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...
by virgo
18 May 2015, 16:54
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 16842

Re: feedbrowser (popularfeeds etc..) issue

#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...

Go to advanced search