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

  New Posts New Posts RSS Feed - Timeout Problem when posting, please help
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Timeout Problem when posting, please help

 Post Reply Post Reply
Author
chornee View Drop Down
Newbie
Newbie


Joined: 06 November 2003
Location: United States
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote chornee Quote  Post ReplyReply Direct Link To This Post Topic: Timeout Problem when posting, please help
    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.
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 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;
Back to Top
chornee View Drop Down
Newbie
Newbie


Joined: 06 November 2003
Location: United States
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote chornee Quote  Post ReplyReply Direct Link To This Post 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 ?
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 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.
Back to Top
chornee View Drop Down
Newbie
Newbie


Joined: 06 November 2003
Location: United States
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote chornee Quote  Post ReplyReply Direct Link To This Post 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 ?
Back to Top
chornee View Drop Down
Newbie
Newbie


Joined: 06 November 2003
Location: United States
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote chornee Quote  Post ReplyReply Direct Link To This Post 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,
 
 
user test pass test
 
it times out whenever trying to post, but the messages stiol get posted, jsut like my other forum.
Back to Top
chornee View Drop Down
Newbie
Newbie


Joined: 06 November 2003
Location: United States
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote chornee Quote  Post ReplyReply Direct Link To This Post 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.
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.