Last post problem on main page

Hello.

Hello,

I'm having the same problem here. The Last Post information always shows Today, the current time, and the Administrator Account ID.

added: Not sure if it matters, but I'm using MySQL.

Which files should be reuploaded to check for corruption?

Thanks!


Edited by Jer26 - 19 May 2006 at 8:04pm

A completely new upload (no customization) of v8.01 did the same thing.

After digging in further, I discovered that the issue happened when the logic hit an empty sub forum. This also explains why the issue only cropped up periodically because it would only affect a small percentage of WWF users (those with an empty sub forum).

Anyway, here's the fix:

At the end of line 545, change Now() to CDate("2001-01-01 00:00:00") so the line reads:

If isDate(sarryForums(10,intCurrentRecord)) Then dtmLastSubEntryDate = CDate(sarryForums(10,intCurrentRecord)) Else dtmLastSubEntryDate = CDate("2001-01-01 00:00:00")

This matches the logic used by the Forum comparison and makes everything work great.

Whoops not quite there yet. The above fix will take care of the issue that arises from having empty sub forums, but the date is still wrong if the most recent post is in a sub forum. The sub forum logic also needs to be updated to use intTempRecord or else it just uses the values from the main forum.

Here's the complete fix:

Lines 543, 544 and 545: Change "intCurrentRecord" to "intTempRecord"

strLastSubEntryUser = sarryForums(8,intTempRecord)

If isNumeric(sarryForums(9,intTempRecord)) Then lngLastSubEntryUserID = CLng(sarryForums(9,intTempRecord)) Else lngLastEntryUserID = 0

If isDate(sarryForums(10,intTempRecord)) Then dtmLastSubEntryDate = CDate(sarryForums(10,intTempRecord)) Else dtmLastSubEntryDate = CDate("2001-01-01 00:00:00")


Edited by Jer26 - 22 May 2006 at 10:39pm