ecms 帝国 刷新文章出现问题解决
Table 'empirecms.phome_ecms_' doesn't exist select titleurl,groupid,classid,newspath,filename,id,title from ***_ecms_ where id>225 and classid='104' and checked=1 order by id limit
解决方法如下:其实就是查找内容表和索引表不一样的地方,并且删除。
主要是因为索引表里面有记录而内容表没有
select id from phome_ecms_news where id not in (select id from phome_ecms_news_data_1) delete from phome_ecms_news where id not in (select id from phome_ecms_news_data_1)
或者如下也可以:
问:
Table 'news.phome_ecms_news_data_' doesn't exist
select keyid,dokey,newstempid,closepl,infotags,newstext from ***_ecms_news_data_ where id='888578' limit 1
答:原因是数据本身有问题,信息索引表phome_ecms_表名_index有不存在ID的记录。解决办法:phpmyadmin进数据库找到phome_ecms_表名_index 点击右侧的搜索按钮,输入对应的ID字段值=888578,然后删除索引表中不存在的ID记录即可解决。