Empire CMS refreshes the content page and reports an error (Table ‘xxxx.phome

The following error occurs when the Empire CMS refreshes the content page

Table '***.phome_ecms_news_data_' doesn't exist select keyid,dokey,newstempid,closepl,infotags,address from ***_ecms_news_data_ where id='1878' limit 1

This is mainly because the information in the information table has been deleted, but it still exists in the index table, so an error occurred.

Solution:

Execute the following SQL statement in the background of Imperial CMS to delete redundant information in the index table

delete from `phome_ecms_news_index` where id not in(select id from phome_ecms_news)

Recommended site search: apply for free space, domain name registration official website, domain name registrar, server rental, website registration time, domain name reverse check, website query domain name, US server URL, website registration process, registration-free jsp space,