Solution to Unknown error when upgrading Empire CMS to 7.0

What should I do if the Unknown column 'checked' in 'field list' error occurs when the empire cms is upgraded to 7.0?

Recommended to study "Empire cms tutorial"

Problem description:

Upgrade empire cms from 6.6 to empire cms7.0, everything is normal, but when I enter the background and click on the management information,

Unknown column 'checked' in 'field list'
select id,classid,titleurl,groupid,newspath,filename,checked,isqf,havehtml,istop,isgood,firsttitle,ismember,userid,username,plnum,totaldown,onclick,newstime,truetime,lastdotime,titlepic,title from ***_ecms_movie order by id desc limit 0,100

Cause of the problem:

The prompt should say that the checked field does not exist.

This happened because I wrote an information list template myself

This file cannot be upgraded to Empire cms, so the previous checked field exists in it Not removed

Solution to the problem:

Open /e/data/html/list/alllistinfo_movie.php

Find the following sql, probably In line 9

$query="select id,classid,titleurl,groupid,newspath,filename,checked,isqf,havehtml,istop,isgood,firsttitle,ismember,userid,username,plnum,totaldown,onclick,newstime,truetime,lastdotime,titlepic,title from {$dbtbpre}ecms_".$tbname.$where." order by ".$doorder." limit $offset,$line";

is changed to

$query="select id,classid,titleurl,groupid,newspath,filename,isqf,havehtml,istop,isgood,firsttitle,ismember,userid,username,plnum,totaldown,onclick,newstime,truetime,lastdotime,titlepic,title from {$dbtbpre}ecms_".$tbname.$where." order by ".$doorder." limit $offset,$line";

overwrite and upload

The above is the detailed content of Solution to Unknown error when upgrading Empire CMS to 7.0. For more information, please follow other related articles on the PHP Chinese website!