error message when posting on forum sql error 1016 ???

Hangin' Around Joined: Mar 08, 2005 Posts: 48

When some1 tries to post on my forum [ Only registered users can see links on this board! Get registered or login! ] a error messages comes up:- (

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 99, word_id, 0 FROM nuke_bbsearch_wordlist WHERE word_text IN ('test', 'post')

Line : 252
File : functions_search.php

Was fine about 1hr ago, could this be a hosting problem ?

Posted: Sun Aug 13, 2006 12:14 pm

i see alot of other posts regarding this, to use the repair in phpmyadmin but i dont have a repair option as when it loads the tables up on the right side u can't view the bottom of that page.

Posted: Sun Aug 13, 2006 12:38 pm

when i login into phpmyadmin i get

Error
SQL query:

SELECT COUNT( * ) AS num
FROM `staukcla_stasite`.`nuke_bbsearch_wordmatch`

MySQL said:

#1016 - Can't open file: 'nuke_bbsearch_wordmatch.MYI'. (errno: 145)

Posted: Sun Aug 13, 2006 12:56 pm

I tried repairing the tables via vdeck (control panel) it told me that some of the tables have crashed.

is there any way to get this working again ??

now my forums wont work at all

Error creating new session

DEBUG MODE

SQL Error : 1062 Duplicate entry '1' for key 2

INSERT INTO nuke_bbsessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('452550ace824df219204f3afdd4171c4', 1, 1155463810, 1155463810, 'acd8abb9', 0, 0, 0)

Line : 187
File : sessions.php

Posted: Sun Aug 13, 2006 1:39 pm

Id sudjest you drop the tabe and upload a backup asap.

Posted: Sun Aug 13, 2006 1:42 pm

back up lol, the site is only up a few days, havent even done a backup yet.

what causes this problem ?

if i were to run the sql installation folder again over the current online version of ravennuke wot would happen ?

Posted: Sun Aug 13, 2006 1:49 pm

it would drop all the tables and remake them and you would have to start from scratch.

I believe this is a server issue.