Table 'news.phome_ecms_news_data_' doesn't exist
select keyid,dokey,newstempid,closepl,infotags,newstext from ***_ecms_news_data_ where id='8888' limit 1
答：原因是数据本身有问题，信息索引表phome_ecms_表名_index有不存在ID的记录。
解决办法：phpmyadmin进数据库找到phome_ecms_表名_index 点击右侧的搜索按钮，输入对应的ID字段值=8888，然后删除索引表中不存在的ID记录即可解决。
SQL解决方法如下：
查看是哪个有问题：select id from phome_ecms_news where id not in (select id from phome_ecms_news_data_1)
删去有问题id：delete from phome_ecms_news where id not in (select id from phome_ecms_news_data_1)
评论