帝国7.0升级常见问题解答

Can't DROP 'checked'; check that column/key exists
alter table ***_ecms_news change id id int(10) unsigned NOT NULL auto_increment, DROP INDEX checked, 
drop COLUMN keyid, drop COLUMN ztid, drop COLUMN checked, drop COLUMN dokey, drop COLUMN newstempid, 
drop COLUMN closepl, drop COLUMN haveaddfen, drop COLUMN votenum, drop COLUMN copyids, drop COLUMN infotags;
解决办法：进入数据库找到***_ecms_news checked添加索引即可解决

http://domain.com/e/public/report?classid=152&id=213471
错误报告 /e/DownSys/替换为/e/public/ 批量删除：可以进数据库清空 phome_enewsdownerror表的记录

Table 'dongfang8.phome_ecms_edu_data_' doesn't exist
select keyid,dokey,newstempid,closepl,infotags from ***_ecms_edu_data_ where id='29' limit 1

十六、刷新所有信息内容页面时提示“Table '*.phome_ecms_news_data_' doesn't exist”

答：原因是数据本身有问题，信息索引表phome_ecms_表名_index有不存在ID的记录。解决办法：进数据库删除索引表中不存在的ID记录即可解决。

 

Unknown column 'checked' in 'where clause'
select * from ***_ecms_news where checked=1 order by id limit 10
解决办法：感谢楼上两位  我删除整个 自定义列表和自定义JS列表就解决了