You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 331 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
MySQL errno: 145: Can't open file nuke_XXXX.MYI

3.10.2. MySQL errno: 145: Can't open file nuke_XXXX.MYI

If suddenly you get an error like:

Could not insert new word matches
DEBUG MODE
SQL Error : 1016 Can't open file: 'nuke_bbsearch_wordmatch.MYI'. (errno: 145)
INSERT INTO nuke_bbsearch_wordmatch (post_id, word_id, title_match) 
SELECT 4467, word_id, 0 FROM nuke_bbsearch_wordlist WHERE word_text IN ('testing')
Line : 282
File : /xxxx/xxxx/public_html/nuke/includes/functions_search.php

then you will know that your MySQL database has been corrupted. In the above example, the nuke_bbsearch_wordmatch table is damaged (see MySQL errno: 145 Can't open file nuke bbsearch wordmatch.MYI).

Solution: Enter the MySQL prompt from the shell:

mysql -u dbuname -h dbhost -p dbname;

where dbuname, dbhost and dbname are exactly the same as in your config.php (Section 3.7) - you will also be prompted for your password, which must also be the same as in config.php - and try the REPAIR TABLE command:

repair table nuke_bbsearch_wordmatch;

You can also try from the shell command-line the myisamchl utility:

myisamchk -r nuke_bbsearch_wordmatch

See Section 26.1 on how to repair corrupt tables.

Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.024 Seconds - 391 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::