Forum thread link for the New Game Page Requests in both Forum Activity and Recent Posts brings up a blank page

[Soulsderfuchs]

Describe the bug Clicking the the forum link for New Game Page Requests in particular brings you to an empty page instead of the forum itself. perhaps this has to be with the high number of pages the thread has but this is speculation.

To Reproduce Steps to reproduce the behavior:

1. Go to Recent Posts
2. Click on New Game Page Requests forum link
3. See error

Expected behavior Bring up the correct forum page

Screenshots

[wescopeland]

I can't seem to reproduce this issue: https://retroachievements.org/viewtopic.php?t=13871&o=3285

Do you have an exact URL you can share that surfaces the issue?

[Soulsderfuchs]

https://retroachievements.org/viewtopic.php?t=13871&c=231498#231498 seems it loads now since it has two new posts but it isnt redirecting to the actual comment which is Gravuano post in the previos page, if those two new posts werent there it would be empty like in the screenshot. This is not the first time I have caught this but it is very inconsistent.

[wescopeland]

Confirmed:

SELECT 
    u.ID AS user_id,
    u.User AS username,
    u.Permissions,
    u.banned_at
FROM 
    ForumTopicComment ftc
JOIN 
    UserAccounts u ON ftc.author_id = u.ID
WHERE 
    ftc.ForumTopicID = 13871
    AND (u.Permissions < 0 OR u.banned_at IS NOT NULL)
GROUP BY 
    u.ID;

This returns 2 results - the shift is from two banned user posts which are invisible to most users. The back-end should be ignoring these for non-mods though.

[wescopeland]

Will be resolved by https://github.com/RetroAchievements/RAWeb/pull/3205.