Problem with unread posts and wrong last post in boards showing on board index

[HaloPolicja]

Hi! I have a problem with unread posts (unread posts are set to be stored on the server in database, not in user sessions cookie). It was working fine until a few days ago, since then multiple users have reported that clicking on "Unread posts" in a topic, instead of redirecting them to the first unread post in a topic, they are redirected to the last page of this topic, even when there were multiple pages before which they didn't read. It doesn't appear constantly, sometimes it works as should, sometimes it doesn't in the same thread.

Another problem I have which happened in the same time is wrong post showing on the board index as last post in a board. For example board index show last post was written 2 hours ago, when there were posts written 5 minute ago.

It was working fine before, I didn't change anything on my end. Table phpbb_topics_track in database currently has 1,291,909 records (are there any limits how many records in this table can be?). My forum has >1M posts, my "stack" is - hosted on a dedicated VPS - Cloudflare (it's not CF problem, I've tried to disable it - same issue), phpBB 3.3.9, PHP8.1, Percona MySQL8, memcached for cache and Sphinx as a search engine. I don't see any errors in any of these services. Thank you very much for help.

[thecoalman]

For the unread posts turn off Speed brain in Cloudflare, it's new feature they added on Sept. 25 and deployed on as default. There is topic I started about it here:

viewtopic.php?t=2657146

Another problem I have which happened in the same time is wrong post showing on the board index as last post in a board. For example board index show last post was written 2 hours ago, when there were posts written 5 minute ago.

The Speed brain isue should not create this issue, make sure you don't have any caching of content activated on CF other than default. Same thing server side.

You can reset the topic tracking to one year with this SQL. Any topic with last post older than one year will be marked as read whether they read it or not:

Code: Select all

DELETE FROM phpbb_topics_track WHERE mark_time< UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 YEAR));
DELETE FROM phpbb_forums_track WHERE mark_time< UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 YEAR));
UPDATE phpbb_users SET user_lastmark=UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 YEAR)) WHERE user_lastmark<UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 YEAR)) AND user_id != 1;