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,'and checked=1',''),listsql=replace(listsql,'
and checked=1','')

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!