MySQL database problem
 

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 :helpme

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

text is missing this: '

hth. good luck. :)

nice catch

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

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

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

ok thanks looking into all these now - help mucho appreciated :thumbsup

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

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

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

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