| Author |
 Topic Search  Topic Options
|
lodogg 
Groupie
Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: SQL Error '80040e21'
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
|
|
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
lodogg
Groupie
Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
lodogg
Groupie
Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
|
Post Options
Thanks(0)
Quote Reply
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 . I actually like to post a bunch of
images under one post but that’s me.
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
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
