Web Wiz Support and Community Forums : SQL Search Error ’80040e31’ https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 04 Apr 2026 23:07:46 +0000 Tue, 20 Sep 2005 21:42:55 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10211 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Search Error ’80040e31’ : I forgot to mention in my last...]]> https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post90872.html#90872 Author: Mojo_Risin
Subject: 10211
Posted: 20 September 2005 at 9:42pm

I forgot to mention in my last post that I in fact added the index to my SQL server database, but still no go.]]> Tue, 20 Sep 2005 21:42:55 +0000 https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post90872.html#90872 <![CDATA[SQL Search Error ’80040e31’ : bullish1 wrote:You need to...]]> https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post90871.html#90871 Author: Mojo_Risin
Subject: 10211
Posted: 20 September 2005 at 9:41pm

Originally posted by bullish1 bullish1 wrote:

You need to add a Index to the tblTopic using Last_entry_date.
 
I was quite hopeful that this was the solution. I've had this problem for some time. The database has over 100,000 messages and growing rapidly.  It's been quite some time since members have been able to do a search without timing out.
]]> Tue, 20 Sep 2005 21:41:57 +0000 https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post90871.html#90871 <![CDATA[SQL Search Error ’80040e31’ : Actually the solution is pretty...]]> https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post90775.html#90775 Author: bullish1
Subject: 10211
Posted: 19 September 2005 at 2:19pm

Actually the solution is pretty simple.
 
You need to add a Index to the tblTopic using Last_entry_date.
 
Since the query is ORDER BY Last_entry_date and the table is not indexed by this field, the sort is being done at the time of the query.
 
Jeffrey Hines
HairBoutique.com
]]> Mon, 19 Sep 2005 14:19:48 +0000 https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post90775.html#90775 <![CDATA[SQL Search Error ’80040e31’ : Hosts usually do deny there is...]]> https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post74782.html#74782 Author: WebWiz-Bruce
Subject: 10211
Posted: 26 January 2005 at 5:40am

Hosts usually do deny there is something wrong, get back to your host and hassel them till they sort it out or move host.]]> Wed, 26 Jan 2005 05:40:16 +0000 https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post74782.html#74782 <![CDATA[SQL Search Error ’80040e31’ : I have just got the same...]]> https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post74776.html#74776 Author: bjobra
Subject: 10211
Posted: 26 January 2005 at 4:15am

I have just got the same problem after 1 year without. THe database is no more than 60 MB.  I did lenghten the timeout settings to 180. My server host deny any wrongs. ]]> Wed, 26 Jan 2005 04:15:21 +0000 https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post74776.html#74776 <![CDATA[SQL Search Error ’80040e31’ : Hi, FWIW, I found the following...]]> https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post69100.html#69100 Author: Shatz
Subject: 10211
Posted: 07 November 2004 at 3:17am

Hi,

FWIW, I found the following MSDN article which describes a scenario in which the "autogrow" feature of SQL databases can yield timeout errors.  Hopefully this helps in some way. :)

Take Care,
Shatz

]]> Sun, 07 Nov 2004 03:17:36 +0000 https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post69100.html#69100 <![CDATA[SQL Search Error ’80040e31’ : -boRg- wrote:There shouldn&#039;t...]]> https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post69045.html#69045 Author: klr3
Subject: 10211
Posted: 05 November 2004 at 4:33pm

Originally posted by -boRg- -boRg- wrote:

There shouldn't be anything on line 356 which is throwing up the error.

Either the file is modified or corrupted, try reuploading the original file again and see if that improves the search.


Have allready tryed that, and:

Creating a new fresh database - result= NONE
Overwritten all files with untouche ones - result= NONE

Absolutly nothing words! :O(

The database size is around 226 MB, could it be the the size, which is messing it up?

If so, are there any ways to limit the search in the fiels message???

PLZ help me!

Everything else works 100% perfect!!!

I really do NOT want to give this forum up!!!

Thanks in advance! :O)

]]> Fri, 05 Nov 2004 16:33:04 +0000 https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post69045.html#69045 <![CDATA[SQL Search Error ’80040e31’ : There shouldn&#039;t be anything...]]> https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post57951.html#57951 Author: WebWiz-Bruce
Subject: 10211
Posted: 24 May 2004 at 1:11pm

There shouldn't be anything on line 356 which is throwing up the error.

Either the file is modified or corrupted, try reuploading the original file again and see if that improves the search.
]]> Mon, 24 May 2004 13:11:42 +0000 https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post57951.html#57951 <![CDATA[SQL Search Error ’80040e31’ : Still no answers???Please help...]]> https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post57920.html#57920 Author: klr3
Subject: 10211
Posted: 24 May 2004 at 9:09am

Still no answers???

Please help - I donīt know what to do???

I tried to copy the data from the SQL to Access, and guess what...

Now itīs possible to search in the body field (in Access), but still this search returns the mentioned error code...

Please note, that the database is NOT an option!

What am I, and my web host, doing wrong???

To Borg:
If you in any way can give some exclusive support, Iīm accepting you invioce!]]> Mon, 24 May 2004 09:09:52 +0000 https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post57920.html#57920 <![CDATA[SQL Search Error ’80040e31’ : klr3 wrote: Very time some...]]> https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post56744.html#56744 Author: klr3
Subject: 10211
Posted: 11 May 2004 at 3:33pm

Originally posted by klr3 klr3 wrote:

Very time some one try to search in message body on the serach pages, I always get following error:

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

Timeout expired

/forum/search.asp, line 356 ....

Now I have opgraded the forum to 7.8, got our own expensive server with SQL along, on the same machine...

Anyway, I still get the error, when trying to search in the body field.

Total posts right now is about 95.000...

Does anyone have any solution to this problem?

regards,
Kenneth

]]> Tue, 11 May 2004 15:33:17 +0000 https://forums.webwiz.net/sql-search-error-80040e31_topic10211_post56744.html#56744