Log in

View Full Version : database crash..help


geevest.com
06-08-2006, 03:54 AM
im post in my forum...and database crahs...this message
Invalid SQL:

REPLACE INTO postindex
(wordid, postid, score, intitle)
VALUES
(1545, 39294, 1, 1), (1746, 39294, 1, 0), (7131, 39294, 1, 0), (27537, 39294, 1, 0), (5980, 39294, 1, 0), (58, 39294, 2, 0), (10631, 39294, 1, 0), (1008, 39294, 1, 0), (10875, 39294, 1, 0), (10784, 39294, 1, 0), (17088, 39294, 1, 0), (21394, 39294, 3, 0), (5924, 39294, 1, 0), (1595, 39294, 1, 0), (89, 39294, 1, 0), (1371, 39294, 1, 0), (1641, 39294, 1, 0), (3331, 39294, 1, 0), (48746, 39294, 1, 0), (156, 39294, 1, 0), (42, 39294, 1, 0), (1242, 39294, 1, 0), (7887, 39294, 1, 0), (2112, 39294, 1, 0), (151, 39294, 1, 0);

MySQL Error : Can't open file: 'postindex.MYI'. (errno: 145)
Error Number : 1016

anyone can help me?

Zachery
06-08-2006, 05:22 AM
The table has just gone bad, run a repair on the postindex table.

REPAIR TABLE postindex; in phpmyadmin or though ssh.,

You can also do this via the admincp under maintanece > Repair / Optimizie.

geevest.com
06-08-2006, 06:42 AM
hum...its finished...
just go to mysql in cpanel and repair database