Solution to the error in refreshing the custom list when upgrading Imperial CMS to 7.0-Empire CMS-php.cn

Home

CMS Tutorial

Empire CMS

Solution to the error in refreshing the custom list when upgrading Imperial CMS to 7.0

王林

Nov 06, 2019 pm 05:19 PM

ErrorupgradeEmpire cms

Solution to the error in refreshing the custom list when upgrading Imperial CMS to 7.0

Problem description:

Empire cms6.6 will use the checked=1 condition when creating a custom list. After the upgrade, refresh the custom list An error will occur, indicating that the checked field does not exist.

Cause of the problem:

Empire cms7.0 no longer sets the checked field in the main table, and the audited and unaudited information is stored in separate tables.

Solution:

Modify the custom list and remove the checked=1 condition. If you set up a lot of custom lists, you can consider using SQL statements to replace them in batches, such as:

update `zhuxianfeicom_enewsuserlist` set totalsql=replace(totalsql,&#39;and checked=1&#39;,&#39;&#39;),listsql=replace(listsql,&#39;
and checked=1&#39;,&#39;&#39;)

Recommended tutorial: Empire CMS Tutorial

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

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn