| Author |
 Topic  |
|
|
ondie
Starting Member
3 Posts |
 Posted - 29 May 2001 : 13:10:01
|
Hello,
I've installed this great forum on MS SQL2000
It works great, but I've got problem with "Update Forum Counts " in Admin section.
When I use it, it after about 2 minutes writes me this:
Topics: ...........................
Topic Replies: ..............................................................................
Forum Replies: Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/admin_count.asp, line 269
Can anyone help me? I would really appreciate that!
Thanks a lot
Andrew Sider
|
|
|
hostivity
Starting Member
USA
1 Posts |
Posted - 06 June 2001 : 10:31:30
|
I too am having the same problem... however I am using MS Access 2000. My error statement is a little different though.... ANybody please help.... the error is as follows:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/forum/admin_count.asp, line 252
if strLast_Post <> "" then strSql = strSql & ", F_LAST_POST = '" & strLast_Post & "' " if strLast_Post_Author <> "" then
------------------------------------------------------------------------------------------^
The Webolution Will Be Computerized... Will You Be Ready? |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 06 June 2001 : 14:51:20
|
quote:
Hello,
I've installed this great forum on MS SQL2000
It works great, but I've got problem with "Update Forum Counts " in Admin section.
When I use it, it after about 2 minutes writes me this:
Topics: ...........................
Topic Replies: ..............................................................................
Forum Replies: Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/admin_count.asp, line 269
Can anyone help me? I would really appreciate that!
Thanks a lot
Andrew Sider
If you have the Active Uers MOD installed, this can cause timeouts when doing an update count (try using a standard inc_top.asp). You could try setting a larger server.scriptTimeout value in admin_count.asp
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 06 June 2001 : 14:54:18
|
quote:
I too am having the same problem... however I am using MS Access 2000. My error statement is a little different though.... ANybody please help.... the error is as follows:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/forum/admin_count.asp, line 252
if strLast_Post <> "" then strSql = strSql & ", F_LAST_POST = '" & strLast_Post & "' " if strLast_Post_Author <> "" then
------------------------------------------------------------------------------------------^
The Webolution Will Be Computerized... Will You Be Ready?
Doesn't look like the same prob to me, your error does not mention a script Timeout, but rather it suggests you have a corrupt file, the error is telling you that the code should be on more than one line like this
if strLast_Post <> "" then strSql = strSql & ", F_LAST_POST = '" & strLast_Post & "' "
if strLast_Post_Author <> "" then
|
|
|
| |
Topic |
|
Topic Locked
