Shulou(Shulou.com)06/02 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.