Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
RSS creates long and slow query errors
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 9, 2014 - 10:41 am

agreed it's not a error, it's just a pain in the butt when looking for real errors sifting through the huge wall of text, I thought they were suppose to disable it from showing but it hasn't happened yet

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 9, 2014 - 1:07 pm

I got it to work, but it kills the group feeds as well, any way to kill the main while keeping the groups?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 9, 2014 - 10:23 pm

try this:

add_filter('sph_rss_where', 'my_rss_feeds', 10, 2);
function my_rss_feeds($where, $feed) {
    if ($feed == 'all') $where = '0=1';
    return $wwere;
}
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 9, 2014 - 10:30 pm

both still blank

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 9, 2014 - 11:51 pm

slight typo in the default return value...

add_filter('sph_rss_where', 'my_rss_feeds', 10, 2);
function my_rss_feeds($where, $feed) {
    if ($feed == 'all') $where = '0=1';
    return $where;
}
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 10, 2014 - 12:04 am

thank you, thank you, thank you

 

 

thank you!

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 10, 2014 - 1:10 am

glad to help...

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 10, 2014 - 9:39 am

just a update, seems a lot of the issues are coming from feedly, and some how they are bypassing that function I added as seen here

https://feedly.com/i/subscript.....forums/rss

but if I just use the all link, it shows nothing

http://thehomesteadingboards.c.....forums/rss

how is that even possible?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 10, 2014 - 8:43 pm

are you sure the feedly one is up to date?  they are certainly caching the feeds.. perhaps it just needs to expire out?

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 10, 2014 - 8:49 pm

it was updating every half or so until I totally disabled the feed again this afternoon, then it stopped updating and the long queries stopped propagating in the error log, I disabled it around 5:00 pm est, last error in the log was at 4:26 pm est and the last forum post feedly is showing is from 5 hours ago, so all three fit the same time frame

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626