Can't open file: 'dede_archives.MYI' (errno: 145)
Can't open file: 'dede_archives.MYI' (errno: 145) - Execute Query False! Select arc.ID,arc.title,arc.iscommend,arc.color,arc.typeid, arc.ismake,arc.description,arc.pubdate,arc.senddate,arc.arcrank,arc.click, arc.money,arc.litpic,arc.writer,arc.shorttitle,arc.memberid,arc.postnum,arc.lastpost, tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule, tp.namerule2,tp.ispart,tp.moresite,tp.siteurl from dede_archives arc left join dede_arctype tp on arc.typeid=tp.ID where arc.arcrank > -1 And ( ( arc.typeid='3' ) Or arc.typeid2='3' ) order by arc.ID desc limit 0,5
Can't open file: 'dede_archives.MYI' (errno: 145) - Execute Query False! Select arc.ID,arc.title,arc.iscommend,arc.color,arc.typeid, arc.ismake,arc.description,arc.pubdate,arc.senddate,arc.arcrank,arc.click, arc.money,arc.litpic,arc.writer,arc.shorttitle,arc.memberid,arc.postnum,arc.lastpost, tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule, tp.namerule2,tp.ispart,tp.moresite,tp.siteurl from dede_archives arc left join dede_arctype tp on arc.typeid=tp.ID where arc.arcrank > -1 And ( ( arc.typeid='1' ) Or arc.typeid2='1' ) order by arc.ID desc limit 0,5
或者是首页出现DedeCms Error Track
解决方法如下:
(修复Can't open file: 'tablename.MYI' (errno: 145)错误:)
使用用户的账号登陆phpmyadmin,选择那个数据库
并选择执行sql语句,输入如下语句执行就可以了
登陆后用输入SQL语句: repair table dede_archives