Web Wiz Support and Community Forums : Timeout Problem when posting, please help https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 22:36:58 +0000 Wed, 12 Jan 2005 10:53:37 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=13317 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Timeout Problem when posting, please help : &#039;************************...]]> https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73720.html#73720 Author: chornee
Subject: 13317
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.
]]> Wed, 12 Jan 2005 10:53:37 +0000 https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73720.html#73720 <![CDATA[Timeout Problem when posting, please help : I have now tried setting up the...]]> https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73710.html#73710 Author: chornee
Subject: 13317
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
 
user test pass test
 
it times out whenever trying to post, but the messages stiol get posted, jsut like my other forum.
]]> Wed, 12 Jan 2005 08:53:48 +0000 https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73710.html#73710 <![CDATA[Timeout Problem when posting, please help : I tried completely disabling the...]]> https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73709.html#73709 Author: chornee
Subject: 13317
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 ?
]]> Wed, 12 Jan 2005 08:35:37 +0000 https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73709.html#73709 <![CDATA[Timeout Problem when posting, please help : Often problems with errors when...]]> https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73706.html#73706 Author: WebWiz-Bruce
Subject: 13317
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, ifit does you then know that it's the email settings in the admin areathat need looking at.

Maybe a localhost SMTP server would help.
]]> Wed, 12 Jan 2005 08:25:00 +0000 https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73706.html#73706 <![CDATA[Timeout Problem when posting, please help : I have had previous versions of...]]> https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73705.html#73705 Author: chornee
Subject: 13317
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 ?
]]> Wed, 12 Jan 2005 08:17:45 +0000 https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73705.html#73705 <![CDATA[Timeout Problem when posting, please help : The error is cursed by the line...]]> https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73697.html#73697 Author: WebWiz-Bruce
Subject: 13317
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 asthe forum I would check the timeout property in MS SQL Server is notset to low.

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

Connection Timeout=90;
]]> Wed, 12 Jan 2005 06:11:09 +0000 https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73697.html#73697 <![CDATA[Timeout Problem when posting, please help : I ma installing a fresh instance...]]> https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73678.html#73678 Author: chornee
Subject: 13317
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.
]]> Tue, 11 Jan 2005 20:02:48 +0000 https://forums.webwiz.net/timeout-problem-when-posting-please-help_topic13317_post73678.html#73678