How to solve the problem of Unknown error in Imperial cms upgrade to 7.0
Editor to share with you how to solve the Imperial cms upgrade to 7.0 Unknown error problem, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!
What if there is a Unknown column 'checked' in' field list' error when Imperial cms upgrades to 7. 0?
Problem description:
Imperial cms upgraded from 6.6 to Imperial cms7.0, it was normal all the way, but it appeared when I entered the backstage 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 0100
The cause of the problem:
The hint should say that the checked field no longer exists.
This appears because I wrote a message list template myself.
The file empire cms cannot be upgraded, so the previous checked field has not been removed.
Solution to the problem:
Open / e/data/html/list/alllistinfo_movie.php
Find the following sql, probably on 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"
Change 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"
Just overwrite and upload.
The above is all about how to solve the problem of Unknown error in Imperial cms upgrade to 7.0. thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!