Author name not displayed correctly
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=21109
Printed Date: 09 April 2026 at 5:04am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Author name not displayed correctly
Posted By: Imperator
Subject: Author name not displayed correctly
Date Posted: 22 August 2006 at 3:08pm
I have a peculiar bug on my forum that happens every once in a while:
On the forum section index display, the author name ("Topic Starter") is not displayed correctly. Instead of displaying the user who started the thread, it displays the username of another user who has posted somewhere in the thread. Deleting the post of the incorrectly displayed user fixes the problem.
I've only had 3 reported instances so far (although I suspect more unreported instances). But I wasn't sure what the problem was.
Using version 8.01, Access
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 22 August 2006 at 3:19pm
This maybe a case of Access not able to cope with the traffic your forum is getting as Access is a desktop flat file only capable of handling small forusm with a handful of users per day.
If you see this problem again, with 8.03, click the admin icon for that topic and hit the submit button it will reset the stats for that topic including post starter and last poster.
-------------
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: Imperator
Date Posted: 25 August 2006 at 4:40am
Thanks! That seems to have fixed it.
I've also had other strange things happen recently such as entire sections disappearing (but fixed when stats are rescynched). It'll be interesting to see how large the database can get (if it can reach the 2GB limit) before it totally dies out. (currently at 680 MB).
|
Posted By: WebWiz-Bruce
Date Posted: 25 August 2006 at 10:04am
WOW 680Mb, I wouldn't recommend using an an Access database above 10Mb for a forum due to the high number of users and high number of hits it gets.
Access is a flat office desktop file so it's like storing your data in a slightly complex text file which needs to be loaded into the web servers memory every time it is accessed. Add to that you only get 20 connections shared with all sites on that server to all the access databases, it's not really up to the job.
You should look at using a Database Management System like mySQL or SQL Server as both are servers rather than flat files so are able to handle many 1000's of users and millions of posts.
mySQL and SQL Server 2005 Express are both free and would work much better than Access.
If you want to stay using Access then you should backup the database everyday as it's easy for Access to become corrupted and you may not be able to recover it.
-------------
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
|
|