Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
What would cause the recent forum posts widget to not update?
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Nov 27, 2014 - 12:24 pm

thanks Yellow, I will try playing with that. 

thanks MP, that's what I figured

How does time zone work into this? When Ike asked about the time settings, I logged in with my test account, marked all posts as read and then changed my time zone from New York to dublin, reloaded the forum and had like 30 unread posts show up

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 27, 2014 - 12:32 pm

Every time you load a page a check is made against a stored timestamp which is of the last page load you made. Any posts that have been made by anyone other than you between that check timestanp and now are added to the front of your personal new posts list.

If your timezone changes then the amount of time between now and that last timestamo will increase/decrease accordingly which could then add posts that it believes you have not read even though you may have done so.

Don't forget that all of these lists are, first and foremost, to do with new and unread posts. This list is NOT going to include any posts that you made. It is only when the number of new and unread posts is not enough to fill the allocation that it then will start to include new posts you MAY have read which may then incude your own.

andy-signature.png
YELLOW
SWORDFISH
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Nov 27, 2014 - 12:32 pm

I did just check my forum error log after the import from staging and saw these, but I'm looking at my database and I see the tables, would this have anything to do with it?

file: /nas/wp/www/cluster-2294/kvr28/wp-content/plugins/simple-press/forum/content/classes/sp-topic-view-class.php
line: 238
function: select
error: Table 'wp_kvr28.rufus_sftopics' doesn't exist

SELECT group_id, rufus_sftopics.topic_id, rufus_sftopics.forum_id, topic_name, topic_slug, topic_status, topic_pinned, topic_icon, topic_opened, rufus_sftopics.post_count, forum_slug, forum_status, forum_disabled, forum_rss_private, rufus_sfposts.post_id, post_date, rufus_sfposts.user_id, rufus_sftopics.user_id AS topic_starter, guest_name, guest_email, post_status, post_pinned, post_index, post_edit, poster_ip, source, post_content, NULL AS new_post, topic_subs FROM rufus_sftopics JOIN rufus_sfposts ON rufus_sftopics.topic_id=rufus_sfposts.topic_id JOIN rufus_sfforums ON rufus_sftopics.forum_id=rufus_sfforums.forum_id WHERE rufus_sftopics.topic_id=31465 ORDER BY post_pinned DESC, rufus_sfposts.post_id ASC LIMIT 0, 10

27 Nov ’14 11:40 am | spaErrError | 1 | database

file: /nas/wp/www/cluster-2294/kvr28/wp-content/plugins/simple-press/forum/content/classes/sp-topic-view-class.php
line: 238
function: select
error: Table 'wp_kvr28.rufus_sftopics' doesn't exist

SELECT group_id, rufus_sftopics.topic_id, rufus_sftopics.forum_id, topic_name, topic_slug, topic_status, topic_pinned, topic_icon, topic_opened, rufus_sftopics.post_count, forum_slug, forum_status, forum_disabled, forum_rss_private, rufus_sfposts.post_id, post_date, rufus_sfposts.user_id, rufus_sftopics.user_id AS topic_starter, guest_name, guest_email, post_status, post_pinned, post_index, post_edit, poster_ip, source, post_content, NULL AS new_post, topic_subs FROM rufus_sftopics JOIN rufus_sfposts ON rufus_sftopics.topic_id=rufus_sfposts.topic_id JOIN rufus_sfforums ON rufus_sftopics.forum_id=rufus_sfforums.forum_id WHERE rufus_sftopics.topic_id=31465 ORDER BY post_pinned DESC, rufus_sfposts.post_id ASC LIMIT 0, 10

27 Nov ’14 11:40 am | spaErrError | 1 | database

file: /nas/wp/www/cluster-2294/kvr28/wp-content/plugins/simple-press/forum/content/classes/sp-list-topic-class.php
line: 174
function: select
error: Table 'wp_kvr28.rufus_sfforums' doesn't exist

SELECT rufus_sftopics.forum_id, forum_name, forum_slug, forum_disabled, rufus_sftopics.topic_id, topic_name, topic_slug, topic_icon, topic_icon_new, rufus_sftopics.post_count, rufus_sftopics.post_id, post_status, post_index, post_date, guest_name, rufus_sfposts.user_id, post_content, display_name FROM rufus_sftopics JOIN rufus_sfforums ON rufus_sfforums.forum_id = rufus_sftopics.forum_id JOIN rufus_sfgroups ON rufus_sfgroups.group_id = rufus_sfforums.group_id JOIN rufus_sfposts ON rufus_sfposts.post_id = rufus_sftopics.post_id LEFT JOIN rufus_sfmembers ON rufus_sfmembers.user_id = rufus_sfposts.user_id WHERE rufus_sftopics.topic_id IN (33279,33267,33278,33275,33161,33271,33254,33273,33269,33280,32646) ORDER BY rufus_sftopics.post_id DESC

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Nov 27, 2014 - 12:33 pm

Yellow Swordfish said
Every time you load a page a check is made against a stored timestamp which is of the last page load you made. Any posts that have been made by anyone other than you between that check timestanp and now are added to the front of your personal new posts list.

If your timezone changes then the amount of time between now and that last timestamo will increase/decrease accordingly which could then add posts that it believes you have not read even though you may have done so.

Don't forget that all of these lists are, first and foremost, to do with new and unread posts. This list is NOT going to include any posts that you made. It is only when the number of new and unread posts is not enough to fill the allocation that it then will start to include new posts you MAY have read which may then incude your own.

understood

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 27, 2014 - 1:23 pm

so have you tried as test user and see if they appear?  or try a post a test user and see if you see them...

though not sure I agree with Andy about the recent posts widget not showing your own posts.. need to check that...

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Nov 27, 2014 - 9:52 pm

yes, when I post as admin it shows up as updated on the new posts next to breadcrumbs and on the drop down in the header and on the main page under group view for the test account, when I post as test it's updated on the admin account next to breadcrumbs and the drop down in the header and on the main page under group view for test account, it just doesn't change anything if logged out or on the post widget,

I think I found out why, but not sure what is causing it, I set a sidebar on the forum page on the staging server and kept increasing the amount of topics displayed until no more showed, that number is 55,

now, if I make a post on one those 55 topics it immediately goes to the top of the widget as the recent post and it changes on the front page list under group view for the test account and for logged out

If I make a new topic or a post on any other topic besides those 55 that show, it doesn't change for logged out users under group view or the widget

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 28, 2014 - 3:21 am

So let me see if I can recap and just condense this down to what the issue actually appears to be...

I think, after all this, you are basically saying that the issue shows up for guest/not logged in users who do not see new posts or topics in the listings. Is that more or less correct?

So - first thing we need to check is permissions for guest users. Do they have consistent access permission to all forums and if so what is it?

andy-signature.png
YELLOW
SWORDFISH
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Nov 28, 2014 - 10:07 am

yes, plus the recent posts widget isn't updating except for those 55 topics, even for logged in users

guests can view forums, view posts by admin and view links

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 28, 2014 - 10:31 am

Mmm. Definitely can not replicate with those permissions. I am also troubled by where this 55 entries limit is coming from. Will keep looking ad talking about it here but at the moment somewhat stumped. No other similar reports either which is curious.

I will see if I can work out why the 55 limit. Unless that is simply the number that fill;s the requirements which is a possibility I suppose. except for guests there is no concept of when they last visited of course as we can keep no data on them....

andy-signature.png
YELLOW
SWORDFISH
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Nov 28, 2014 - 10:42 am

Would this have anything to do with it? 

I was testing user settings when I first installed simple press, I had changed the default number of unread posts to 200 and allowed the members to set their max number of unread posts.

I did not mention anything to the members, but adjusted it on my test account, I wanted to see if it would slow down the queries, how quickly 200 posts would take to propagate, etc. I decided to change it back to 50 and allow them to set their max , but my test account kept filling to 200 posts, I didn't think anything of it, I just cleared the posts and cleared the cache, 

I logged into that account and saw that it was still showing 200 unread posts, so I looked around the settings more and saw the new posts topic cache was set to 200 under global settings, so I changed that to 100 and cleared all the caches, then changed it back to 200. 

Is it basically waiting to build the cache back to 200 before the new topics kick in and start propagating those areas?

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: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17345
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10117
Posts: 79600