View previous topic :: View next topic |
Author |
Message |
fturco Veteran
Joined: 08 Dec 2010 Posts: 1181
|
Posted: Wed May 20, 2020 11:32 am Post subject: Wrong last post timestamp for the Risorse italiane subforum |
|
|
According to the initial index page of the Gentoo forums, the last post for the "Risorse italiane (documentazione e tools)" subforum had been sent in 1970-01-01@02:00 (which is obviously impossible). Instead, the last post had been sent in 2018-10-08@21:08 (by xdarma). Can anyone confirm this problem? |
|
Back to top |
|
|
eccerr0r Watchman
Joined: 01 Jul 2004 Posts: 9826 Location: almost Mile High in the USA
|
Posted: Wed May 20, 2020 1:51 pm Post subject: |
|
|
Yeah it's showing up as 1969 for me, which probably means the epoch date is 0 or something.
I'd guess this probably will go away with the phpbb3 update and this all gets thrown away... _________________ Intel Core i7 2700K/Radeon R7 250/24GB DDR3/256GB SSD
What am I supposed watching? |
|
Back to top |
|
|
desultory Bodhisattva
Joined: 04 Nov 2005 Posts: 9410
|
Posted: Sat May 23, 2020 3:35 am Post subject: |
|
|
fturco wrote: | Can anyone confirm this problem? | Yes, confirm and fix.
The latest post in a section is tracked in the database, instead of being found by query each time it would need to be found. In this case that post had been removed, quite probably during cleanup of malformed posts, thus a placeholder value, the start of the standard unix epoch, was shown. Setting the stored value to the value that the otherwise avoided query found corrected the problem.
eccerr0r wrote: | I'd guess this probably will go away with the phpbb3 update and this all gets thrown away... | Aside from malformed ones, some of which are surprisingly old, posts are not being disposed of for the upgrade. |
|
Back to top |
|
|
|