Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL Search Error ’80040e31’
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Search Error ’80040e31’
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
klr3 View Drop Down
Groupie
Groupie
Avatar

Joined: 20 February 2003
Status: Offline
Points: 103 		Post Options Post Options   Thanks (0) Thanks(0)   Quote klr3 Quote  Post ReplyReply Direct Link To This Post 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)
Back to Top
Shatz View Drop Down
Newbie
Newbie


Joined: 30 October 2004
Location: United States
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Shatz Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
bjobra View Drop Down
Newbie
Newbie


Joined: 07 June 2004
Status: Offline
Points: 12 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bjobra Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
bullish1 View Drop Down
Newbie
Newbie


Joined: 06 March 2005
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bullish1 Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Mojo_Risin View Drop Down
Groupie
Groupie


Joined: 23 June 2002
Location: Canada
Status: Offline
Points: 57 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mojo_Risin Quote  Post ReplyReply Direct Link To This Post 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.
Dave
Back to Top
Mojo_Risin View Drop Down
Groupie
Groupie


Joined: 23 June 2002
Location: Canada
Status: Offline
Points: 57 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mojo_Risin Quote  Post ReplyReply Direct Link To This Post 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.
Dave
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.