Sql Error Help Pleeeease
 

[sql]Error

SQL-query :

SHOW KEYS FROM `user`

MySQL said:


Can't open file: 'user.MYI'. (errno: 145)
[/sql]

i was trying to run the query used in the MODERATOR ACTIVITY LOGGING hack and then...this happened to my user table.... i ran this query...


[sql]CREATE TABLE modlog (
modlogid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
userid int(10) unsigned DEFAULT '0' NOT NULL,
dateline int(10) unsigned DEFAULT '0' NOT NULL,
type tinyint(1) DEFAULT '0' NOT NULL,
threadid int(10) DEFAULT '0' NOT NULL,
threadtitle varchar(100) NOT NULL,
fromforumid smallint(5),
toforumid smallint(5),
timestamp int(11) DEFAULT '0' NOT NULL,
script char(20) NOT NULL,
action char(20) NOT NULL,
extrainfo char(200) NOT NULL,
ipaddress VARCHAR(15) NOT NULL,
PRIMARY KEY (modlogid)
);[/sql]

anyhelp PLEEEASE would be appreciated...



FIXED AND I DONT EVEN KNOW HOW :o:o:o:o:o:o

Well that was lucky :)

Always backup though, just in case.

Good to hear you saved yourself. :)

...yeah....lol....

FOR THE RECORD------THE MODERATOR ACTIVITY HACK IS SO VERY POORLY MADE ARG IT DIDNT EVEN WORK!!!!! THATS WHY I HAD TO USE A CUSTOM QUERY!!!!! ARG!!

but yeah....the other admin....well...fixed it....i dont know how....becuz he doesn't tell me these things....all he says is (lol)

(1) gots to be a tru thug

or

(2) tis gangsta

(3) you not gangsta enough for this...

lol...yeah....but for the record, anyone have anyidea what that error means? and how to fix it? lol since i obviously dont know *see reasons above* -_-!:p!:D!

search through the board here, this error can be found a hundret times even within the last days...

there is even a sticky thread about such errors

just gotta be thuggin angus! One of these day's u'll konw the ways but until then . . . just do your thang and i'll do mine.