Search found 12 matches

by rainclouds
18 May 2015, 23:46
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

Re: feedbrowser (popularfeeds etc..) issue - resolved

Hi, Sorry fox wasn't meant like that. am building a clean machine with wiki specs. Virgo's suggestion was only to have a better query for everyone. But if you think this one is good enough fine to, you after all suggested cleaning the query up in this thread. Making a new build (and a debian postgre...
by rainclouds
18 May 2015, 22:34
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

Re: feedbrowser (popularfeeds etc..) issue - resolved

my opinion would be that it would be the best way (no subselect). And we want them to appear if someone has that feed but without private/no password protected. (As right now i have 1 user with one of those feeds set private but 2 users not and the feed doesn't appear but if you would kill the subse...
by rainclouds
18 May 2015, 21:29
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

Re: feedbrowser (popularfeeds etc..) issue

Hi, BY the way the fact you mentioned postgres was extremely important i did some research and : 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 ...
by rainclouds
18 May 2015, 19:59
Forum: Support
Topic: Adding new users to existing feeds
Replies: 7
Views: 6922

Re: Adding new users to existing feeds

hi, As far i know : you just add more users on the admin page, they will not see by default the feeds you subscribed as admin to. You can then or export an opml file and reimport it for each user (login as each user) or let the users use the popular feeds popup and they can then themselves subscribe...
by rainclouds
18 May 2015, 19:33
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

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 rainclouds
18 May 2015, 17:58
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

Re: feedbrowser (popularfeeds etc..) issue

@fox : sorry about the # using code quotes now i forgot.. (used to post in a forum that believe it or not is antique and does not have that ) Virgo i dont know what you are talking about. It returns the correct feeds. What SQL server are you using ? the query i used returns 11 unique feeds from the ...
by rainclouds
18 May 2015, 16:40
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

Re: feedbrowser (popularfeeds etc..) issue

Hi, The following does work and does not have the nested where's and returns exactly the desired results. #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, ...
by rainclouds
18 May 2015, 14:03
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

Re: feedbrowser (popularfeeds etc..) issue

Hi again, @ Heiko : Funny thing i ran that query it returns : 0 rows. Seems the only way i get the correct response is my current version of the query : # WHERE tf.feed_url = ttrss_feeds.feed_url replaced by # WHERE ttrss_feeds.feed_url which i know isn't the right way. Anyone around with superSQL s...
by rainclouds
18 May 2015, 05:22
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

Re: feedbrowser (popularfeeds etc..) issue

hi,

sorry forgot to quote that one but like heiko mentioned it already.

ill try heiko's suggestion for now then.

I will go catch up on my SQL and see what i can do, meanwhile thank you all for looking at it.


Regards,
by rainclouds
17 May 2015, 22:57
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

Re: feedbrowser (popularfeeds etc..) issue

Hi all, Been doing a little testing debugging on a duplicate system. This is what i found : The issue (i think of course, as i don't know that well the code and am just new and not good in SQL) is it seems to in the SQL statement in rssfuncs.php. i have 28 feeds on 3 people 11 feeds are unique. i ma...
by rainclouds
16 May 2015, 20:11
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

Re: feedbrowser (popularfeeds etc..) issue

hi, According to the wiki either use update.php to manually update or the update_daemon which takes care of everything automatically. Just to be sure i already tried the manual way also. Still no popular feeds. (anything else to try or settings to change ?) I double-checked all logs no errors mentio...
by rainclouds
16 May 2015, 18:17
Forum: Support
Topic: feedbrowser (popularfeeds etc..) issue - resolved
Replies: 32
Views: 17733

feedbrowser (popularfeeds etc..) issue - resolved

Hi, First of all thank you to the developers for a great system, it installed perfect, runs perfect and i just really like it. So everything runs perfect (except one thing) , i added a few users, added for each some feeds (so they have a set of feeds), everything updates also perfectly with update-d...

Go to advanced search