Home > CMS Tutorial > Empire CMS > body text

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

藏色散人
Release: 2019-12-11 09:06:37
Original
3484 people have browsed it

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
Copy after login

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)
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!