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

Editor to share with you the Imperial cms upgrade to 7. 0 refresh custom list error how to solve, I hope you read this article after a great harvest, let's discuss it!

Problem description:

Checked=1 is used in all custom lists built by Imperial cms6.6. After the upgrade, there will be an error in refreshing the custom list, indicating that the checked field does not exist.

The cause of the problem:

Imperial cms7.0 no longer sets the checked field in the main table, and audited and unaudited information is stored separately from the table.

Solution:

Modify the custom list to remove the checked=1 condition. If you set a large number of custom lists, you can consider replacing them in batches with SQL statements, such as:

Update `zhuxianfeicom_ enewsuserlist` set totalsql=replace (totalsql,'and checked=1',''), listsql=replace (listsql,'and checked=1','') have finished reading this article. I believe you have some understanding of how to solve the problems in upgrading Imperial cms to 7.0refresh custom list. Would like to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

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.