First post of older threads missing
First post of older threads missing
Author
Discussion

Don

Original Poster:

28,378 posts

308 months

Thursday 20th September 2007
quotequote all
Just been enjoying a few classic threads. On many of them it seems like the original post is missing. Just the first one...

..now IIRC Ted based Gassing Station on a freeware ASP based "forum" and in its relational model the first post was stored in the "thread" table and subsequent ones were stored in a "posts" table that had "thread" as part of the primary key.

During the great rejigging could it be that the first post of a thread now resides in the "posts" table (where it ought to) - but that during the "munge" when the structure of the database was altered and the new code deployed that old threads weren't updated and with the new code the first post is forever lost?

Some of the old classics just aren't the same without the first post...

Any chance one of the PH techies could take a look?

Many thanks and keep up the good work!

Famous Graham

26,553 posts

249 months

Thursday 20th September 2007
quotequote all
Someone mentioned this a couple of weeks ago - based on Pete's response, I'd say you were right on the money.

RacingPete

9,156 posts

228 months

Thursday 20th September 2007
quotequote all
Nearly correct, apart from the forums are all homemade... The original posts are still in the database but will take a little time to re-align. It is on the bug list for fixing smile

Trooper2

6,676 posts

255 months

Thursday 20th September 2007
quotequote all
PH really needs to have a Rip Van Winkle award.

Don

Original Poster:

28,378 posts

308 months

Thursday 27th September 2007
quotequote all
I now seem to be finding the first posts of NEW threads missing too!

Occasionally!

If I identify a good test case I'll post a link to it.

Edited by Don on Thursday 27th September 11:58