Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-15232

Last Post is calculated by post_id instead of post_time

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.2.0
    • Fix Version/s: None
    • Component/s: Viewing forums
    • Labels:
      None
    • Environment:
      phpMyAdmin 4.7.0, MySQL 5.6.35, Ubuntu 14.04.5 LTS, IE 11.0.9600.18537 and Firefox 52.1.1 (32bit) ESR

      Description

      The forum sync function (determine last post) is using the post_id to determine the "last post" of the forum. This does not always generate the correct result, depending on the state of the database - specifically, when a bulletin board is imported from elsewhere into phpBB.

      Using the post_time would give the correct result, regardless of the post order in the database.

      In my situation, topic_id 25 (post_id 73) has a message time of 1460449200, but topic_id 4 (post_id 16) has the newest message time of 1485184800 (2 years newer). However, post_id 73 is always calculated as the last post (until a brand new post in the forum is made).

      As a test, I changed the post_id from 16 to 2000 and synchronized the forum. The last post then displayed correctly (post_id 2000).

      This bug does not create big issues - just cosmetic/annoyance type problems. This bug becomes invisible once a new post in the forum is made after a database import (largest post_id is the newest time).

      I am willing to test code, as my migration to phpBB is still in process (not live).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                user1492 user1492 [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: