How to solve the error table ‘empirecms.phome_ecms_’ doesn’t exist in Empire CMS

How to solve the error table ‘empirecms.phome_ecms_’ doesn’t exist in Empire CMS?

When I was doing "data update" today, after clicking "Refresh all information content pages", the prompt "Table 'empirecms.phome_ecms_' doesn't appears in the "Refresh data table: article" item exist

When I was doing "data update" today, after clicking "Refresh all information content pages", a prompt appeared in the "Refresh data table: article" item:

The code is as follows:

Table ‘empirecms.phome_ecms_’ doesn’t exist 
update ***_ecms_ set havehtml=1 where id=” limit 1

After searching on the Internet, it was explained like this:

The code is as follows:

Cause: You modified the system model to which the column belongs, because the column It turns out that the system model to which it belongs has information itself, but you have changed the system model to which it belongs, so that the column to which the information belongs cannot be found, causing an error.

Solution: Modify the column and change it back to the original system model, then go to the management information to delete all the information in the column, and finally modify the column and change it back to the new system model it belongs to. This will solve the problem.

However, this explanation makes it difficult to solve the problem, because a website has many columns. How can you judge which column caused it to modify the system model? Besides, I really can’t remember that I have modified the system model!

So here is a relatively simple and direct solution, which is to execute the following SQL statements in sequence:

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)

The above is the detailed content of How to solve the error table ‘empirecms.phome_ecms_’ doesn’t exist in Empire CMS. For more information, please follow other related articles on the PHP Chinese website!