Web Wiz Forums - Timeout Problem when posting, please help

Print Page | Close Window

Timeout Problem when posting, please help

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

Topic: Timeout Problem when posting, please help

Posted By: chornee
Subject: Timeout Problem when posting, please help
Date Posted: 11 January 2005 at 8:02pm

I ma installing a fresh instance of Web Wiz Forum 7.9 using sql. The site and the Sql Server are located on the same box. Its is not a slow box, it should definately be able to handle the forum .

When I get it setup, I am doing some test posts and I get this error

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

/forum/post_message.asp, line 837

Only when i am making a post, it still puts the post in the Database but it doesnt return the user back to the Site and instead gives that error. I can go back to the forum and read the posts, but if I reply I get the same thing ...

I have used this forum alot and actually have purchased it for customers before.. Can anyone help me resolve this problem please

Web Wiz forum 7.9 ... sql server 2000

I have tried reinstalling it a couple times from scratch .. same results.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 12 January 2005 at 6:11am

The error is cursed by the line inserting the number of posts the user has made into the database.

As this is a timeout error and the SQL Server is on the same server as the forum I would check the timeout property in MS SQL Server is not set to low.

You can also set a connection timeout from the ASP connection by editing the file 'admin/SQL_server_connection.asp' and add the following to the end of the connection string:-

Connection Timeout=90;

-------------
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: chornee
Date Posted: 12 January 2005 at 8:17am

I have had previous versions of Web Wiz Forums running on tit perfectly. Its a high end server and shouldnt have any problems at all running it. I have already tried adjusting the timeouts, that didnt help. also, the posts are making it, it something that happens after the insert... i think , because if i refresh the forum I can go back and see the posts I have entered.

I have tried reinstalling it from scratch a couple times even.. The only reason I even went up to 7.9 is because Somehow i lost all the stored procedurers from my previous install of 7.6 when moving my DB around, Once I get the forum working properly I am going to import my users and such .. But I cant even get the base install to work properly right now.

any other suggestions on thigs to try ?

Posted By: WebWiz-Bruce
Date Posted: 12 January 2005 at 8:25am

Often problems with errors when posting are to do with email settings.

Try disabling the email features and see if that solves the problem, if it does you then know that it's the email settings in the admin area that need looking at.

Maybe a localhost SMTP server would help.

-------------
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: chornee
Date Posted: 12 January 2005 at 8:35am

I tried completely disabling the mail .. and I changed all the email settings around, No luch either way. I cant beleive I am the only person having this problem.. Im sure its something simple, I jsut cant figure it out.

Any other suggestions on things to turn off/on or anything else I can try ?

Posted By: chornee
Date Posted: 12 January 2005 at 8:53am

I have now tried setting up the forum on a different server with the same results .. Am I jsut overlooking somethign simple ?

Here is the address to the "test" forum I setup,

http://24.24.41.129/forum - http://24.24.41.129/forum

user test pass test

it times out whenever trying to post, but the messages stiol get posted, jsut like my other forum.

Posted By: chornee
Date Posted: 12 January 2005 at 10:53am

'******************************************
'*** Update Author Number of Posts ***
'******************************************

'Initalise the strSQL variable with an SQL statement to query the database to get the number of posts the user has made
strSQL = "SELECT " & strDbTable & "Author.No_of_posts, " & strDbTable & "Group.Special_rank "
strSQL = strSQL & "FROM " & strDbTable & "Author, " & strDbTable & "Group "
strSQL = strSQL & "WHERE " & strDbTable & "Author.Group_ID = " & strDbTable & "Group.Group_ID AND " & strDbTable & "Author.Author_ID= " & lngLoggedInUserID & ";"

'Query the database
rsCommon.Open strSQL, adoCon

'If there is a record returned by the database then read in the no of posts and increment it by 1
If NOT rsCommon.EOF Then

'Read in the no of posts the user has made and username
lngNumOfPosts = CLng(rsCommon("No_of_posts"))

'Inrement the number of posts by 1
lngNumOfPosts = lngNumOfPosts + 1

  'Initalise the SQL string with an SQL update command to update the number of posts the user has made
  strSQL = "UPDATE " & strDbTable & "Author SET "
  strSQL = strSQL & "" & strDbTable & "Author.No_of_posts = " & lngNumOfPosts
  strSQL = strSQL & " WHERE " & strDbTable & "Author.Author_ID= " & lngLoggedInUserID & ";"

'Write the updated number of posts to the database
adoCon.Execute(strSQL)
End If

This is what is making it time out.. the author number of posts. If I comment out the execute the posts work jsut fine, but the count is not incramented for the author. so everyone always says 0 posts ... For now i guess it atleast allows me to get my Forum up and running, but Some help to fix this would be greatly appreciated.