Strange Results using New Posts Search Function in v3.3.12 <solved>

[rockedge]

After updating our board from 3.3.11 -> 3.3.12 we have been noticing a change in the New Posts mechanism that has not been received well amongst our users.

The board is medium sized with 10305 topics and 116122 posts currently. Users usual report :
Noticing one thing.

When I log into the forum and click on Quick links -> New Posts
A list of posts show, that have been made, since the last time I logged in.
If I re-click on new Posts.
It seems to only show posts I have not read.
In the past it would give me the same list again and maybe some new posts made during my log in time.
Very useful if checking to see if anyone added to a post I posted in.

There still seems to be a problem with the list of newest posts.
I had a list of at least 15 newest posts.
I had read two of them and replied to both of the two.
Returned to the list of unread posts gave me only three.

It seems the problem is connected to the reply made.
I had 5 entries of new posts. Just made one reply in DE forum and returning to the list of newest posts returned just one new post. It was the post of the topic wherein in replied.

The behavior of the New Posts function has significantly changed from the way it behaved up to v3.3.11.

Is there way to return the New Post search to the way it worked before v3.3.12

[rxu]

For the info, previous discussion viewtopic.php?t=2654323

[rockedge]

Thanks for the link!

[P_I]

Updated information available in viewtopic.php?p=16024567#p16024567

I think we were finally able to track down this issue which caused the aforementioned issues with the new posts page:
https://tracker.phpbb.com/browse/PHPBB-17375

The linked pull request contains the currently proposed fix for this.

[rockedge]

Excellent!

I did try using :

Code: Select all

/*
		[Fix] queued replies missing from "view new posts" (Bug #42705 - Patch by Paul)
		- Creates temporary table, query is far from optimized

					$sql = 'SELECT t.topic_id
						FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . ' p
						WHERE p.post_time > ' . $user->data['user_lastvisit'] . '
							AND t.topic_id = p.topic_id
							AND t.topic_moved_id = 0
							AND ' . $m_approve_topics_fid_sql . "
						GROUP BY t.topic_id
						$sql_sort";
*/

Which does seem to change the behavior. I will immediately check out this new information! Thanks for the head's up!

[rockedge]

I have applied the patch [ticket/17375] and the Puppy Linux forum is now performing the New Posts function using the patched phpbb/session.php and so far we are seeing an improvement in performance.

Thanks to all the Dev's who've made the effort to find a solution.

Returned /search.php to the shipped 3.3.12 version.