Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Some forums timeout in .04		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

dbullock
Starting Member

USA
7 Posts
Posted - 22 August 2004 :  21:12:21  Show Profile

So assuming the upgrade from .03 to .04 was successful, I have 2 of 3 forums which timeout when trying to display the initial topic list.

Any suggestions?

Thanks!
Dan

dbullock
Starting Member

USA
7 Posts
Posted - 22 August 2004 :  21:29:03  Show Profile
I just tried to archive some posts and it looks to me like the database has some quote issues. Previous versions of Snitz must not have handled the quotes correctly and it is causing some problems.

Microsoft OLE DB Provider for SQL Server error '80040e14'
Unclosed quotation mark before the character string

I guess there is not process in the upgrade which checks and corrects quoting issues?

Dan
Edited by - dbullock on 22 August 2004 21:29:30
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts
Posted - 22 August 2004 :  21:52:53  Show Profile
there shouldn't have been an issue with .03 to .04 ... what page and line number are you getting that error on? do you have any mods?
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

dbullock
Starting Member

USA
7 Posts
Posted - 22 August 2004 :  22:19:28  Show Profile
No mods. I do have it narrowed down though. In forum.asp, starting at line 328, the .recordcount and .pagecount each cause the page to timeout.

I test this by commenting those lines out alternatively and setting each variable to an integer.

The very strange thing is that this code does not hang on my 3rd forum, but it does hang on the 1st and 2nd forums.

1st forum has 203 topics and 1229 posts
2nd forum has 112 topics and 573 posts
3rd forum has 15 topics and 34 posts

Could the tables be corrupted somehow? This problem just seems very strange.

Thanks,
Dan
Edited by - dbullock on 22 August 2004 22:26:27
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 23 August 2004 :  06:17:30  Show Profile  Send ruirib a Yahoo! Message
What connection string are you using?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

dbullock
Starting Member

USA
7 Posts
Posted - 23 August 2004 :  07:17:45  Show Profile
I tried both OLEDB and ODBC. I did find the problem. The issue was the Realtek gigabit LAN driver, dated 2003. I installed the latest driver and the problems went away.

The reason I even discovered the driver problem was that I was downloading the SQL2K AnalysisSP3 update and it would timeout after a minute.

This may point something out about Snitz though. I have much-much larger DB's on the same machine and they did not encounter a timeout since I think they are always returning small recordsets. Might Snitz be returning large recordsets in the forum thread list? I did se in the code that it is using paging.

Thanks for your help!
Dan
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 23 August 2004 :  17:51:05  Show Profile  Send ruirib a Yahoo! Message
Yeah, Snitz returns whole recordsets, though a minute is a whole lot more time than what is usual even for a big forum.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07