Web Wiz Support and Community Forums : On Reply I Get: Timeout expired https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 04 Apr 2026 00:41:10 +0000 Sat, 09 Feb 2008 12:26:27 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=25279 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[On Reply I Get: Timeout expired : The last topic ID is undated when...]]> https://forums.webwiz.net/on-reply-i-get-timeout-expired_topic25279_post131293.html#131293 Author: WebWiz-Bruce
Subject: 25279
Posted: 09 February 2008 at 12:26pm

The last topic ID is undated when users make a post in that forum, or you can use the resync tool within the admin area.]]> Sat, 09 Feb 2008 12:26:27 +0000 https://forums.webwiz.net/on-reply-i-get-timeout-expired_topic25279_post131293.html#131293 <![CDATA[On Reply I Get: Timeout expired : RE my post above, it appears that...]]> https://forums.webwiz.net/on-reply-i-get-timeout-expired_topic25279_post131291.html#131291 Author: sparkweb
Subject: 25279
Posted: 09 February 2008 at 7:08am

RE my post above, it appears that when I copied my test DB over I didn't enable the identity insert and indexes weren't moved, etc. Duh. So never mind...... Embarrassed
 
On the 7.x upgrade file, stage 6 doesn't update the main forum database with the last topic ID for display on the front page.
I have fixed this in this file: http://senduit.com/dc3de9 (file will be there till Feb 16)
 
Mods made on lines 1048, 1099, and 1138.
 
Cheers!
]]> Sat, 09 Feb 2008 07:08:18 +0000 https://forums.webwiz.net/on-reply-i-get-timeout-expired_topic25279_post131291.html#131291 <![CDATA[On Reply I Get: Timeout expired : I&#039;m upgrading from 7.x to...]]> https://forums.webwiz.net/on-reply-i-get-timeout-expired_topic25279_post131289.html#131289 Author: sparkweb
Subject: 25279
Posted: 09 February 2008 at 5:38am

I'm upgrading from 7.x to 9.08 and things are working well. I found a few issues with the upgrader and I will send along my fixes after finishing everything up.

The main problem I'm having is that when I try to reply to a post I get this error every time:

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

Timeout expired

/forum908/new_post.asp, line 787

That's where it opens this query.........

strSQL = "SELECT" & strDBTop1 & " " & strDbTable & "Thread.* " & _
"FROM " & strDbTable & "Thread" & strRowLock & " " & _
"ORDER BY " & strDbTable & "Thread.Thread_ID DESC" & strDBLimit1 & ";"

.....with......

'Open the threads table
.Open strSQL, adoCon     <----- Line 787

Everything else seems to run really well and it seems a lot faster than 7.x. I ran this query directly on the SQL server and didn't have any problem processing it directly. Does this ring any bells for anyone?

]]> Sat, 09 Feb 2008 05:38:41 +0000 https://forums.webwiz.net/on-reply-i-get-timeout-expired_topic25279_post131289.html#131289