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 30, 2014 - 11:03 am

so all this stuff in the box I need to delete?

meta.pngImage Enlarger

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Nov 30, 2014 - 11:07 am

I cleared them both and it worked

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 30, 2014 - 11:08 am

No two rows is not right and might be part of the problem. Remove one of the rows - doesn't matter which as long as for the one you leave the meta_type column is set to 'topic_cache' and the meta_key column is set to 'new'.

And on the second question then yes - that is the data needing removal.

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

I made a new post as admin on staging and it updated the widget

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 30, 2014 - 11:12 am

Yes - as soon as you said two then it all fell into place.

You should still remove the redundant one. This will now be the one where the data you removed has stayed removed. The other will have repopulated.

So at some point a second cache record was created but, because we only expect one, the old one that was no longer being updated was being queried but oddly I bet the newer one was the one being updated.

The important question, of course, is why there were two. That is something I will have to look into to see if I can fathom a way that might come about.

andy-signature.png
YELLOW
SWORDFISH
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Nov 30, 2014 - 11:14 am

they both have the same settings

meta4.jpgImage Enlarger

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 30, 2014 - 11:16 am

I would remove one - doesn't matter which. And then also make sure the other has that empty column again. Let it start clean.

andy-signature.png
YELLOW
SWORDFISH
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Nov 30, 2014 - 11:19 am

Yellow Swordfish said

The important question, of course, is why there were two. That is something I will have to look into to see if I can fathom a way that might come about.

would the innodb conversion that I ran have any impact on that? Also I deleted 31, should I change the meta id of watches to 31 or just leave it 32?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 30, 2014 - 11:24 am

no to both...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 30, 2014 - 11:32 am

you guys have been busy this morning!

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: 17348
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10118
Posts: 79603