Web Wiz Forums - Forum times out when make long posts

Print Page | Close Window

Forum times out when make long posts

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=20282
Printed Date: 11 April 2026 at 1:20pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Forum times out when make long posts

Posted By: bruce
Subject: Forum times out when make long posts
Date Posted: 12 June 2006 at 6:01am

WWF v8.2

I'm getting a lot of complaints from my members that if they take more than just a few minutes to write their posts the forum times out.

It has happened to me a couple times also. It's very frustrating to spend a lot of time composing a post and then lose it because the forum timed out.

After timing out and then making several edits to get pictures uploaded one edit at a time, you eventually start getting the following error and then have to close your browser reopen and edit your post.

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=318436;

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.

/gfboard/edit_post.asp, line 557

Replies:

Posted By: WebWiz-Bruce
Date Posted: 12 June 2006 at 8:39am

You have not mentioned how your forum times out, so I can not answer that question without more details from you to workout what the problem is?

As to your second question, because the names of the uploaded files are stored in the database you can only upload 5 or 6 times within a post, depending on how long the names of your uploaded files are.

-------------
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: bruce
Date Posted: 12 June 2006 at 1:25pm

Sorry for the lack of description. The time out thing has only happened to me a couple times on long posts and I did not get the exact behaviour. If I remember right the users are being logged out when they hit the post reply button after taking a long time to compose their post.

As for the uploaded file issue, that makes sense but I run a fishing forum and my users like to post a lot of fishing pictures in their posts. Is there any way to increase the number of pictures that can be posted in a single post?

Here's a thread where the problem occured.

http://www.gamefishin.com/gfboard/forum_posts.asp?TID=19847 - http://www.gamefishin.com/gfboard/forum_posts.asp?TID=19847

Posted By: WebWiz-Bruce
Date Posted: 12 June 2006 at 2:43pm

The timeout issue sounds like the application pool on your site is recycling and thus dropping the session and tracking data stored in the web servers memory.

Version 8.02 should prevent this if users use the auto-login feature so that cookies are used to help track the user. You could also edit the 'functions/functions_session_data.asp' file and change it so the forum uses the database to track sessions instead of the web servers memory, but this will course more database reads and writes and lower performance of large sites.

As to your second question, you could change the 'File_uploads' field in tblThread in your database to a 'memo' or 'text' datatype to store more data, but this will again course a performance loss and larger database sizes.

-------------
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