dane08 Posted December 6, 2005 Share Posted December 6, 2005 Hi! My problem is about a table that keeps on giving me an error 145 even if i drop it and remake it again and again. The actual error that is receive is: "Can't open file: 'searchindex.MYD'. (errno: 145)". What i mean by again and again is i after I remade the table and them make some inserts into it, then after several days i *again* get the same error. I have encountered this so many times and only in this particular table. i even rebuild the whole database before but untill now i get that error. What should i do? Link to comment https://forums.phpfreaks.com/topic/2992-cant-open-a-table/ Share on other sites More sharing options...
ryanlwh Posted December 6, 2005 Share Posted December 6, 2005 the table is currupted. try [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]REPAIR TABLE searchindex [!--sql2--][/div][!--sql3--] Link to comment https://forums.phpfreaks.com/topic/2992-cant-open-a-table/#findComment-10042 Share on other sites More sharing options...
dane08 Posted December 7, 2005 Author Share Posted December 7, 2005 [!--quoteo(post=325086:date=Dec 6 2005, 11:24 AM:name=ryanlwh)--][div class=\'quotetop\']QUOTE(ryanlwh @ Dec 6 2005, 11:24 AM) 325086[/snapback][/div][div class=\'quotemain\'][!--quotec--] the table is currupted. try [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]REPAIR TABLE searchindex [!--sql2--][/div][!--sql3--] i just did that and it worked. I hope it wont get corrupted again. tnx Link to comment https://forums.phpfreaks.com/topic/2992-cant-open-a-table/#findComment-10052 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.