SQL Server error ’80040e21’
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=6112
Printed Date: 03 April 2026 at 10:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Server error ’80040e21’
Posted By: whittibo
Subject: SQL Server error ’80040e21’
Date Posted: 02 October 2003 at 9:22am
|
Hello! Everything on my forum is running PERFECTLY .. until "Admin" trys to post..
Nobody else seems to be having this problem.. just the admin.. can anyone help me fix it?! ------------- Live and learn through trial and error ~ when all else fails, ASK! |
here is the error I get.. 
Replies:
Posted By: WebWiz-Bruce
Date Posted: 02 October 2003 at 9:27am
|
What version are you running? What does line 604 say? Does it happen when replying to posts or new posts or both? ------------- 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: whittibo
Date Posted: 02 October 2003 at 9:34am
|
THANK YOU BORG!!! ok.. lets see.. version 7.01 SQL forum/post_message.asp says .Fields("Subject") = strSubject I have only tried a new message.. let me go try a reply! I'll be back! ------------- Live and learn through trial and error ~ when all else fails, ASK! |
Posted By: whittibo
Date Posted: 02 October 2003 at 9:35am
|
OK.. just posted a reply.. went perfectly! is that good or bad? ------------- Live and learn through trial and error ~ when all else fails, ASK! |
Posted By: whittibo
Date Posted: 02 October 2003 at 9:40am
|
OK.. very odd.. I just changed the topic title.. and now it works. could my title have been too long?? would that have caused it? ------------- Live and learn through trial and error ~ when all else fails, ASK! |
Posted By: WebWiz-Bruce
Date Posted: 02 October 2003 at 9:56am
|
This error sometimes does occur if the data input is two long. The subject title field in the database is much larger than that allowed to be input to try and prevent this, but the security filters do sometimes encode characters thus increasing the number of characters, in normal cercumstances this should be fine but sometimes as in this case many more characters must have been encoded than the database field size could cope with. The max characters allowed in the text box is 41 and the database feild size is 70 so this should be almost impossible. Have you increased the amount of characters allowed for the subject of a post? ------------- 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: whittibo
Date Posted: 02 October 2003 at 10:04am
|
WEELLL.. now that you mention it.. I think I did change the field size for when a Poll is posted. is that the same field? I followed instructions found here. and that was before I switched to SQL so that could very well be causing the problem then.. ------------- Live and learn through trial and error ~ when all else fails, ASK! |
Posted By: WebWiz-Bruce
Date Posted: 02 October 2003 at 11:09am
|
You may need to increase some of the field sizes in the database relating to those input boxes you increased the size on.
------------- 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 |