Get the App
SLTechnology News&Howtos  ›  Servers  › 

How to solve the problem of Unknown error in Imperial cms upgrade to 7.0

Shulou Source: shulou.com Published: 2022-06-02 02:42:11 11月16日 Update

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!

Tags: Empire problems upgrades errors information content fields articles not much methods reasons background most what to do documents more templates knowledge industry information Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Apple Redmi Shulou Technology Docker