Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
Can't open file: 'w3t_SearchResults.MYD'
#44480 03/09/2005 3:21 AM
Joined: Feb 2004
Posts: 22
Milan (Italy)
R
Rutto
Offline
stranger
Rutto
stranger
R Offline
Joined: Feb 2004
Posts: 22
Milan (Italy)
Hi, I'm getting this error when performing any kind of search, what can be the cause and what can be done to fix it ?

Code
Script: /home/virtual/site217/fst/var/www/html/Forum/dosearch.php
Line#: 263
SQL Error: Can't open file: 'w3t_SearchResults.MYD'. (errno: 145)
SQL Error #: 1016
Query: DELETE FROM w3t_SearchResults WHERE S_Session='b2f88ff997e7930a89c5c07466a04d34' OR S_SearchTime < 1110266445


Thank you ! <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />
Re: Can't open file: 'w3t_SearchResults.MYD'
#44481 03/09/2005 4:06 AM
Joined: Jun 2006
Posts: 742
Charlotte, NC
JoshPet Offline
enthusiast
JoshPet
enthusiast
Offline
Joined: Jun 2006
Posts: 742
Charlotte, NC
This thread is a good one to bookmark for whenever you have MySQL errors, it has all the error cords and solutions.

Basically 145 means the table is corrupt.

Try this SQL QUERY:

REPAIR TABLE w3t_SearchResults

That should fix it. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
Who's Online Now
0 members (), 1,144 guests, and 193 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)