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

This article is about the solution to Imperial CMS's error Table 'empirecms.phome_ecms_' doesn't exist. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

How to solve the problem of Imperial CMS reporting error Table 'empirecms.phome_ecms_' doesn't exist?

Today, when I was doing "data update", after clicking "refresh all information content pages", there was a prompt Table 'empirecms.phome_ecms_' doesn't exist in the item "Refresh data Table: article".

Today, when I was doing "data update", after clicking "Refresh all Information content pages", there was a prompt in "Refresh data Table: article":

The code is as follows:

Table 'empirecms.phome_ecms_' doesn't exist update * * _ ecms_ set havehtml=1 where id= "limit 1

Later, when I searched the Internet, it was explained as follows:

The code is as follows:

Reason: you have modified the system model to which the column belongs, because the original system model of the column has information, and you have changed the system model to make it impossible to find out the error caused by the column.

Solution: modify the column to change back to the original system model, then enter the management information to delete all the information in the column, and then change the column back to the new system model to solve the problem.

However, this explanation is difficult to solve the problem, because there are so many columns on a website, how can you tell which column modified the system model? And I really can't remember ever modifying the system model!

So a relatively simple and straightforward solution to share here is to execute the following SQL statement in turn:

The code is as follows:

Select id from phome_ecms_news where id not in (select id from phome_ecms_news_data_1) delete from phome_ecms_news where id not in (select id from phome_ecms_news_data_1)

Thank you for reading! So much for the solution of Imperial CMS Table 'empirecms.phome_ecms_' doesn't exist. I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.