Print Page | Close Window

Last post problem on main page

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=19661
Printed Date: 11 April 2026 at 7:04pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Last post problem on main page
Posted By: fx5500
Subject: Last post problem on main page
Date Posted: 02 May 2006 at 1:34pm
Hello.
I am using MSSQL version.
There are always writing, the last post from administrator.There are a lot of members and they are writing a lot of posts but it isnt change. Alway "last post... administrator". What should I do?



Replies:
Posted By: WebWiz-Bruce
Date Posted: 02 May 2006 at 1:41pm
You may have a corrupted file, try reuploading the files again.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Jer26
Date Posted: 19 May 2006 at 7:59pm
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!


Posted By: WebWiz-Bruce
Date Posted: 20 May 2006 at 9:24am
Reupload all files again as it could be any of them that are coursing the problem.

Once you do this only new posts will update the data


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Jer26
Date Posted: 22 May 2006 at 4:22pm
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. Big smile


Posted By: WebWiz-Bruce
Date Posted: 22 May 2006 at 6:31pm
Thanks Jer26, that looks like it would have been a hard one to track down.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Jer26
Date Posted: 22 May 2006 at 9:44pm
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")


Posted By: WebWiz-Bruce
Date Posted: 23 May 2006 at 8:45am
Thanks Jer26, I found this problem a few weeks ago and have updated as well as adding a few new bits to the default.asp page.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net