SQL 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=20722
Printed Date: 11 April 2026 at 10:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Error '80040e21'
Posted By: lodogg
Subject: SQL Error '80040e21'
Date Posted: 17 July 2006 at 3:59pm
|
I went to modify one of my posts to upload more pictures, this is something I do alot and I got the following error? SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message, tblThread.Show_signature, tblThread.IP_addr, tblThread.Hide, tblThread.File_uploads FROM tblThread WITH (ROWLOCK) WHERE tblThread.Thread_ID=3575; Microsoft OLE DB Provider for SQL Server error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /forum/edit_post.asp, line 557 Thanks, -lo ------------- Just trying to have some fun and learn in the process. http://www.lodogg.com - Come have Some Fun |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 18 July 2006 at 10:29am
|
Does this happen all the time? Or just when you try to add more than 5 images to 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: lodogg
Date Posted: 18 July 2006 at 9:27pm
|
This happens when I go back to a post and choose Edit and then upload several pictures at one time I get the error posted above:\ My work around was to just make another post below it to append to the thread. ------------- Just trying to have some fun and learn in the process. http://www.lodogg.com - Come have Some Fun |
Posted By: WebWiz-Bruce
Date Posted: 19 July 2006 at 9:16am
|
Because of the way database work, for performance reasons you can only have upto 5 or 6 image/file uploads per post, depending on the length of the file name. The next version has been adapted so you wouldn't get the error message, but the limitation is still there. If you want to have lots of image/file uploads then you would need to spread them across multiple posts. ------------- 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: lodogg
Date Posted: 24 July 2006 at 7:30pm
|
I take that was a code change since 7.97? I was able to upload tons of images per
post If I shorten the file name down to 1.jpg, 2.jpg etc will I be able to post more than 5
or 6 at a time? Thanks for the feedback.. -lodogg ------------- Just trying to have some fun and learn in the process. http://www.lodogg.com - Come have Some Fun |
.Posted By: WebWiz-Bruce
Date Posted: 25 July 2006 at 8:44am
|
Version 7 never associated posts and uploads which allot of people didn't like as uploads had to be manually removed. Version 8 associates uploads with posts so that when the post is removed so is the uploaded file. By shortening the name of the uploaded file you will be able to upload more files. ------------- 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 |