MySQL database problem

[solonline]

Damnation a BB we run is throwing up a shit load of errors - seems only to have started the past hour or so. I know zero about this kind of thing, so am kinda stuck, when trying to post
im pulling this error :

Invalid SQL: INSERT INTO userfield (userid,field5,field1,field2,field3,field4) VALUES (10710,'text,'','','','') mysql error: Got error 28 from table handler
mysql error number: 1030


and when trying to run standard admin commands such as mass prune I get this :

Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0,155,16063,29715,42358) AND postid=857986
mysql error: Can't find file: 'searchindex.MYD' (errno: 2)

mysql error number: 1017

Date: Saturday 16th of October 2004 11:41:50 AM
Script: http// url
Referer: http://url

If anybody has any ideas on what could be the problem please let me know.

thanks

[SMG]

sounds like your database crashed ... for starters:
REPAIR TABLE userfield;
MAYBE REPAIR TABLE searchindex;
as long as theyre INNODB tables.
otherwise you gotta go in shell and use isamchk

[Scherfi]

Originally posted by solonline
VALUES (10710,'text,'','','','')

text is missing this: '

hth. good luck.

[Serge Litehead]

Originally posted by Scherfi
text is missing this: '

hth. good luck.

nice catch

[JSA Matt]

Looks like your tables are corrupt, try running the REPAIR command on them or if you have root do this:

Kill the mysql process and make sure it is not running (mysqld)... you can either use the mysql.sh stop command or kill PID

cd into the directory where your database files are located and run

myisamchk -r */*.MYI

this should repair all your indexes

[Scherfi]

isn't "error 28" out of memory or something like that?

http://forums.devshed.com/archive/t-124674

[solonline]

ok thanks looking into all these now - help mucho appreciated

Damn im crap at such things as this but learn as go along cheers

[solonline]

Originally posted by Scherfi
isn't "error 28" out of memory or something like that?

http://forums.devshed.com/archive/t-124674

Ah now that rings a bell when I had a similar meltdown last year -
checking this now cheers

[JSA Matt]

Originally posted by Scherfi
isn't "error 28" out of memory or something like that?

http://forums.devshed.com/archive/t-124674

Yes, which is why the tables are now corrupted... first fix the memory leak then rebuild the tables

[Scherfi]

see, i love gfy for that
hope you get your problem solved.
good luck!