last post information not updated

[plongeur.com]

Hi, i have an issue with the last post information displayed for a topic on several pages :

On the main page (/forum here) i have the following info, which are accurate :


Now on the channel view of "forum principal" i have this, the avatar is the one of the last user who posted, but the login and the date & time are from another post, also, the "go to las post" button leads to this earlier post instead of the last one :


Finally, in a search results "today topics", i have the same wrong info (but the date use to sort by last post date is the right one...) :


It goes away on its own without me knowing why, so i believe there might be some routine task to update it.
Is there any way i could fix this, or at least make the routine task more frequent so it wouldn't last almost 24 hours.

Best regards,
Matthieu.

[saiff]

[plongeur.com]

i am on linux and apache so i did not turn on this option.
But i will try it

Edit : Well it is the same with this option turned on.

[Wayne Luke]

That option shouldn't affect the data and will increase your bandwidth with little benefit. It is a hold over from old servers.

Can you clear your cache, cacheevent, and searchlog tables?

[plongeur.com]

Do i just truncate the tables ?

I emptied the cache form the admincp, it seems to solve the problem temporarily but it comes back after a while, on random topics and it goes on its own at least once a day.

[Mark.B]

Yes truncate those three tables. (No other tables obviously!)

[plongeur.com]

OK i did truncate the 3 tables.
I'll keep you posted if the issue comes up again.

[saiff]

That option shouldn't affect the data and will increase your bandwidth with little benefit. It is a hold over from old servers.

Can you clear your cache, cacheevent, and searchlog tables?

it's not obligatory to enable it?
It's true that it causes a high load on the server
When I turn it off I do not see the newest in the forum without using F5 on the browser

[Wayne Luke]

it's not obligatory to enable it?
It's true that it causes a high load on the server
When I turn it off I do not see the newest in the forum without using F5 on the browser

It is not necessary on 99% of all servers. It increases the load of the server because browser-side caching is turned off.

With a properly configured server and the latest versions of modern browsers it isn't necessary. If you're using an out of date browser like IE8-10, then you could have problems.

[saiff]

thanks for your availability and clarification.

[plongeur.com]

well, as i feared, it came back.



Would scheduling a daily truncate of said table be a viable option ? or would it have a bad impact on site perf ?

[Wayne Luke]

What OPCode cache are you using? Are you using an external system like Cloudflare or Varnish? How long does it take to update the last post information?

Deleting the cache tables will impact performance as they are rebuilt from page views. Depending on the traffic of your site, this may not be noticeable.

[plongeur.com]

I am not using any external caching system or OPcache (as far as i know).
Well i would say it take 2 or 3 days to go wrong again and it usually goes back to normal in less than 24hours, but goes wrong again on random topics.

I have around 9000 page views per day, and the server seems pretty idle so i don't think the load would be an issue, i saw big and got a 12CPU / 24 Go RAM VPS .