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.
Prev | Home | Next |
RSS block Error: There is a current problem with the headlines from this site | Up | Modules do not show up and/or disappear |
Help us make a better PHP-Nuke HOWTO!Want to contribute to this HOWTO? Have a suggestion or a solution to a problem that was not treated here? Post your comments on my PHP-Nuke Forum! Chris Karakas, Maintainer PHP-Nuke HOWTO |