Web Wiz Forums - Corrupted database after high post count

Print Page | Close Window

Corrupted database after high post count

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=1304
Printed Date: 30 March 2026 at 4:29am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Corrupted database after high post count

Posted By: vdub
Subject: Corrupted database after high post count
Date Posted: 24 March 2003 at 6:43pm

I set the admin post count to 330,000 and it corrupted the database. After I did that I could no longer use the administrator account.

-------------
http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!!

Replies:

Posted By: vdub
Date Posted: 24 March 2003 at 6:55pm

I fixed it but this is a problem that should get looked at

For some reason it took away the Group_ID from the admin. I just had to enter it again manually.

-------------
http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!!

Posted By: Nigelo
Date Posted: 24 March 2003 at 7:00pm

Interesting. The No_Of_Posts is a Long Int (in tblAuthors) so should work to > 2 billion. Did you try setting to 32,000 and then 33,000 which would test the boundary for an Integer rather than a Long?

Out of interest what Access version / SP are you using?

-------------
Hope this helps
Nigel

Posted By: vdub
Date Posted: 24 March 2003 at 7:09pm

I am using access 2002 no SP.

I know this isnt a bug that would come up often but I have known people in the past with over 500,000 posts in a forum. So I am just trying to test every aspect to help borg get a more solid forum.

-------------
http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!!

Posted By: vdub
Date Posted: 24 March 2003 at 7:12pm

I just set my post count to 45,331,039 manuly with no errors.

I think the error might be in the register.asp.

I will test more

-------------
http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!!

Posted By: vdub
Date Posted: 24 March 2003 at 7:17pm

Yes the error is in the register.asp. I tried changing my post count thru the admin section on the admin account and it wiped out the Group_ID field

I tested with a non admin account and it works correctly. I believe this bug only affects the admin account

-------------
http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!!

Posted By: eaglesexec
Date Posted: 24 March 2003 at 8:40pm

2 billion. lol. that would take someone to post 1 post per second non stop for 68 or so years... nuts!

-------------
A good plan, violently executed now, is better than a perfect plan next week. -General George S. Patton.

Posted By: vdub
Date Posted: 24 March 2003 at 10:09pm

lol

yeah

That�s a little unrealistic.

Go to http://www.forumoc.com/ - www.ForumOC.com and look for the user F1.

Now that�s a high post count 37749.

Dose anyone have any ideas on how to fix the Register.asp

-------------
http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!!