Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Forum times out when make long posts
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum times out when make long posts

 Post Reply Post Reply
Author
bruce View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2003
Location: United States
Status: Offline
Points: 102
Post Options Post Options   Thanks (0) Thanks(0)   Quote bruce Quote  Post ReplyReply Direct Link To This Post Topic: Forum times out when make long posts
    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



Edited by bruce - 12 June 2006 at 6:47am
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
bruce View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2003
Location: United States
Status: Offline
Points: 102
Post Options Post Options   Thanks (0) Thanks(0)   Quote bruce Quote  Post ReplyReply Direct Link To This Post 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.
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.