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: General / Classic ASP versions(v3.4.XX)
 Problems while searching in a category
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

evaldescuriel
Starting Member

6 Posts

Posted - 05 April 2009 :  21:14:10  Show Profile
Hi,

I recently moved my forum to a new server; the issue is that when I try to search in a category that has about 8000 topics or replies I receive a 500 error, the issue is that the error only presents when I do a complex search (more than two letters) so I am wondering if this problem is something related to a server configuration or the misconfiguration of the forum.

Thanks in advice

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 05 April 2009 :  21:42:21  Show Profile  Send ruirib a Yahoo! Message
Probably just a database server unable to handle the search...


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

sikandar
Junior Member

Pakistan
135 Posts

Posted - 05 April 2009 :  23:04:54  Show Profile
So what do you suggest I should ask the hosting company? They need to repair any table/index or anything else. thanks
Go to Top of Page

evaldescuriel
Starting Member

6 Posts

Posted - 06 April 2009 :  01:23:31  Show Profile
Ok, reading the log file of my service, I find out that the search script is timing out, I gues that the issue is more releated with the server than with the forum aplication. Anyways I copy the log file so you can se exactly what is happening:

2009-04-06 01:13:07 W3SVC1024 NS26 65.182.189.112 POST /forum/search.asp mode=DoIt|-|ASP_0113|Script_timed_out 80 - 189.216.93.114 HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+SLCC1;+.NET+CLR+2.0.50727;+Media+Center+PC+5.0;+MDDC;+InfoPath.2;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30618;+OfficeLiveConnector.1.3;+OfficeLivePatch.0.0) Snitz00Lang=1034;+Snitz00strSelectSize=2;+Snitz00Lang=1033;+Snitz00strSelectSize=2;+Snitz00User=Pword=4b64cfa42def61b017d8fb037051646477feaec931c78f8962f33b66f51f6c8d&Name=admin;+ASPSESSIONIDCABTACQB=NCNLLMCAPOAPGLADNGIHCCPK http://www.foroparrilladas.com/forum/search.asp www.foroparrilladas.com 500 0 0 1614 1121 256093

thanks in advice
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 06 April 2009 :  05:58:02  Show Profile  Send ruirib a Yahoo! Message
There are a few mods to improve search on SQL Server and MySQL. They will only work up to a point, in improving performance, though.


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

bud_dadude
Starting Member

Australia
21 Posts

Posted - 12 April 2009 :  22:07:27  Show Profile  Visit bud_dadude's Homepage
Hey guys,
I have modded a modded search page that someone else did to fix the timeout issue. You can grab a copy from here -

http://mrtwo.mine.nu/search.txt

I just added a connection timeout value for the connection to the database
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 April 2009 :  02:32:18  Show Profile  Visit HuwR's Homepage
don't post the same reply in multiple topics
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.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07