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

This article mainly introduces the common problems of Imperial CMS6.6 upgrade to 7.0. it has a certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

This article summarizes the common problems of upgrading Imperial CMS6.6 to 7. 0 in detail. Share it with you for your reference. The specific analysis is as follows:

1. Upgrade considerations:

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

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

Second, frequently asked questions about upgrading:

1. Prompt when upgrading:

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

Reason: 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 information records that do not exist, delete them, and then follow the "re-upgrade instructions" steps in the upgrade instructions.

Recommended to learn the Imperial cms course

When you prompt for the above error during the upgrade process, you can look for SQL statements that do not have information in the upgraded table:

The code is as follows:

Select * from phome_enewsinfovote where pubid=0

Record information that does not exist so that redundant records can be deleted after the database is restored.

2. Prompt when upgrading:

Table 'phome_ecms_news_index' already exists

Reason: 7.0 table already exists, because the original installation of 7.0 beta version did not delete 7.0 table directly installed Imperial 6.6 resulting in table legacy.

Solution: after restoring the database, compare the 6.6 data tables, delete the redundant 7.0 tables, and then re-upgrade according to the "re-upgrade instructions" steps in the upgrade instructions.

3. Prompt "Cann't connect to DB!" in the process of transforming data when upgrading.

Reason: the spatial database is unstable, so that the database cannot be linked from time to time during the upgrade process.

Solution: if the space is relatively general, you can change the number of conversions per set 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"

Reason: run the upgrade program repeatedly or upgrade all the way from multiple versions.

Solution: close the current window and open a new window to run.

5. Why didn't you see the menu of new features after the upgrade?

Reason: your user group permissions are not enabled, so the menu is not displayed.

Solution: modify the user group to open the appropriate permissions.

6. Refresh the page prompt after upgrade:

Unknown column 'checked' in' where clause'

Reason: prompt that the checked field does not exist, because the checked field is no longer required for the SQL call information in version 7.0.

Solution: modify the called SQL statement and delete the checked=1 condition.

7. Post-upgrade comments, members, and mall form submission prompt "the link you came from does not exist"

Reason: the submission address of comment, member and mall form has been changed from "/ e/enews/index.php" 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 member always prompts "Please fill in the information completely".

Reason: some field 7.0 has been renamed.

Solution: backstage > user > member Management > manage member form > modify member form, nothing needs to be set, just click on the submission below.

Thank you for reading this article carefully. I hope the editor will share the contents of the frequently asked questions of Imperial CMS6.6 upgrade to 7.0. at the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.