Codezwiz >> Forums >> General PHP Nuke Help >> can't repair a crashed table

hi guys,
i got a tiny problem regarding phpnuke v.8 and the process of posting a message in its forum:

Could not insert new word matches

DEBUG MODE

SQL Error : 1194 Table 'nuke_bbsearch_wordmatch' is marked as crashed and should be repaired

INSERT INTO nuke_bbsearch_wordmatch (post_id, word_id, title_match) SELECT 580, word_id, 0 FROM nuke_bbsearch_wordlist WHERE word_text IN ('ztüaiktikü')

Line : 252
File : functions_search.php

after a bit of research i found this code snippet:

<?php
require("config.php");
$host = $dbhost;
$database = $dbname;
$username = $dbuname;
$password = $dbpass;
mysql_connect($host, $username, $password);
@mysql_select_db($database);
$res = mysql_query("repair table ".$prefix."_nuke_bbsearch_wordmatch");
if ($res) {
echo $res;
} else {
print (mysql_error());
}
?>

Did you try repairing it through phpmyadmin?

You may have to drop the table and rebuild it. Make sure if you do it that way you make a backup of the original structure and data.