Summary of frequently asked questions about upgrading Imperial CMS 6.6 to 7.0

This article summarizes the frequently asked questions about upgrading Imperial CMS 6.6 to 7.0 in more detail. Share it with everyone for your reference. The specific analysis is as follows:

1. Upgrade precautions:

1. If the background website security firewall is turned on, turn it off first, and then upgrade.

2. It is best to check whether the records in the phome_enewsinfovote table contain non-existent column ID (classid field) or information ID (id field) records. If so, please delete the records and then upgrade.

2. Upgrade FAQs:

1. Prompt when upgrading:

Duplicate entry '0' for key 1
alter table ***_enewsinfovote add PRIMARY KEY(pubid);

Cause: The phome_enewsinfovote table has a record of non-existent column ID or information ID.

Solution: Use phpmyadmin to check the records in the table, find out the non-existent information records, delete them, and then follow the "re-upgrade instructions" steps in the upgrade instructions to solve the problem.

Recommended to study "Empire cms tutorial"

When the above error is prompted during the upgrade process, you can find the SQL statement of the technique of finding non-existent information in the upgraded table:

The code is as follows:

select * from phome_enewsinfovote where pubid=0;

Record the non-existent information so that redundant records can be deleted after restoring the database.

2. Prompt when upgrading:

Table 'phome_ecms_news_index' already exists

Reason: 7.0 The table already exists because the original 7.0 beta version was installed without deleting the 7.0 table before directly installing Empire 6.6, resulting in the table being left behind.

Solution: After restoring the database, compare the 6.6 version data table and delete the redundant 7.0 table , and then follow the "Re-upgrade instructions" steps in the upgrade instructions to re-upgrade to solve the problem.

3. During the data conversion process during the upgrade, the prompt "Cann't connect to DB!"

Reason : The spatial database is unstable, causing the database to fail to connect from time to time during the upgrade process.

Solution: If the space is relatively average, you can change the number of conversions for each group and the conversion interval settings in the upgrade configuration file /e/update/upconfig.php, and then upgrade.

4. Upgrade prompt "The upgrade program cannot be run repeatedly"

Cause: Run the upgrade program repeatedly or upgrade from multiple versions all the way.

Solution: Close the current window , open a new window and run.

5. Why don’t you see the new function menu after upgrading?

Cause: Your user group permissions are not turned on, so the menu is not displayed.

Solution: Modify the user group to enable the corresponding permissions.

6. Refresh the page after the upgrade prompt:

Unknown column 'checked' in 'where clause'

Reason: The prompt that the checked field does not exist, because version 7.0 SQL mode calling information no longer requires the checked field.

Solution: Modify the calling SQL statement and delete the checked=1 condition to solve the problem.

7. After the upgrade, when submitting comments, members, and mall forms, it prompts "The link you came from does not exist."

Reason: The comment, member, and mall form submission address is changed from the original "/e/ enews/index.php" were changed to "/e/pl/doaction.php", "/e/member/doaction.php", and "/e/ShopSys/doaction.php" respectively.

Solution: Modify the form submission address in the template and change the submission address to the corresponding address above.

8. After upgrading, the modified member always prompts "Please fill in the information completely" .

Reason: Some fields were renamed in 7.0.

Solution: Backend>User>Member Management>Manage Member Form>Modify the member form, no need to set anything, just click submit below to solve the problem.

Hope this article The above will be helpful to everyone’s Imperial CMS website building.

The above is the detailed content of Summary of frequently asked questions about upgrading Imperial CMS 6.6 to 7.0. For more information, please follow other related articles on the PHP Chinese website!