Threads appearing twice on opening screen.

Thanx 4 The Fish · 04-03-2003 3:15pm #1

Problem ??

regi · 04-03-2003 3:48pm

The list on the front page shows the last 20 posts, not threads.

Thanx 4 The Fish · 04-03-2003 3:52pm

Righto Reg, just though that the Smallville news one appearing twice there as a new was a bit odd...

Latest 20 Threads from All Forums

Threw me off a bit

ecksor · 04-03-2003 4:08pm

Something like this happened before due to an inconsistency in the database, but that isn't happening here (unless someone fixed it since you posted). I can't reproduce the problem either by hand querying the database or subscribing to the forum and checking the subbed forum page. Since there's only one thread repeated there, I'm calling it a freak until someone can give me more evidence to go on ...

ecksor · 04-03-2003 4:15pm

If it was last 20 posts (which it isn't, I'm looking at the code in front of me) then showing the same post twice would still be a bug ...

The query grabs the last 20 threads in order of the date of the last post on each thread and matches the last poster and matches it with the same username in the user table (slightly ambiguous maybe, but you get the idea).

Cloud · 04-03-2003 5:04pm

Simple answer, there were two threads - I deleted one

ecksor · 04-03-2003 5:07pm

Actually, that would explain why the threads didn't appear consecutively in the list as they're ordered on the date which wouldn't have changed if we were actually seeing the same thread twice (which struck me as odd but I obviously didn't think about it properly).

I'm never getting those 10 minutes back

Thanx 4 The Fish · 04-03-2003 5:41pm

easy answers are the best, sorry bout the ten minutes Ecksor.

Would the same answers apply to the Carlow It one then ??

Threads appearing twice on opening screen.

Comments