As many you have noticed there have been a few changes to the forum since we updated to newest version 8.One of the main ones is how you upload pictures and can access pictures by member name. We are limited to some things we can change in regards to the way the forum works but some things such as this can not be modified.
An issue has been raised regarding posting multiple pictures to one post causing issues and error messages. The following info will explain why this happens and how to work around it.
If you try to upload more than 5 pictures to one post you could get this type of error message:
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
Because of the way database works, for performance reasons you can only have up to 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.
The older 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 (1.jpg, 2.jpg etc) you will be able to upload more files.
masta
An issue has been raised regarding posting multiple pictures to one post causing issues and error messages. The following info will explain why this happens and how to work around it.
If you try to upload more than 5 pictures to one post you could get this type of error message:
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
Because of the way database works, for performance reasons you can only have up to 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.
The older 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 (1.jpg, 2.jpg etc) you will be able to upload more files.
masta
