Hongmu Notes
Home Program Notes Imperial CMS prompts Table ‘XX.***_enewspubtemp_2’ doesn’t exist error solution
Program Notes Empire cms

Imperial CMS prompts Table ‘XX.***_enewspubtemp_2’ doesn’t exist error solution

Imperial CMS prompts Table ‘XX.***_enewspubtemp_2’ doesn’t exist error solution

During the test installation of EmpireCMS, after the database restoration is completed, the system may occasionally display the following error message.

Table 'sjjdkn.***_enewspubtemp_2' doesn't exist
select indextemp from ***_enewspubtemp_2 limit 1

Let's first check the database.phome_enewspubtempWhat kind of table is this?enewspubtempPublic template form,indextempThe field corresponds to the homepage template; therefore, the error indicates that the query could not be found.enewspubtemp_2data sheet.

Then, when attempting to install a default template, you discovered that no default templates were available for EmpireCMS.enewspubtemp_2The table confirms this.enewspubtemp_2Added later.

Can be considered almost certainTable ‘sjjdkn.***_enewspubtemp_2’ doesn’t existThis error occurs only during database migration or restoration.

The configuration files for the backed-up databases are all located within the `config.php` file. This issue typically arises when there is a mismatch between the database and the configuration files; for example, if the database contains one template group but the `config.php` file contains two template groups, the two sets will not match, leading to the aforementioned error. This was the root cause I identified during my troubleshooting; the issue was resolved after replacing the `config.php` file. I haven't delved deeper into the specifics, but I hope this information will be helpful to anyone encountering this problem.

resolvent

This error can actually be ignored – simply enter your backend URL to log in; it will not affect your actual usage.

If you find this distracting, delete the backup template for the Management Homepage solution before performing a backup.

Alternatively, replace config.php with the default file.

微信赞赏

WeChat

支付宝赞赏

Alipay

✍️ Author: Hong Mu

webmaster · Thanks for reading, stay tuned for more exciting content

Author homepage View home page →

Related articles

Empire CMS database statement & SQL statement format

Empire CMS database statement & SQL statement format Program Notes Empire cms

Introduction to Imperial CMS extended SQL program writing, basic examples of Imperial CMS database statements & SQL statement formats: Note: The following examples are based on placing PHP files in the system root directory. Example 1: Connect to MYSQL program. (a.php)<?php require('e/class/connect.php'); //Introduce database configuration files and public function files requ…
👁 351
Empire CMS obtains the system COOKIE variable function getcvar()

Empire CMS obtains the system COOKIE variable function getcvar() Program Notes Empire cms

Get the system COOKIE variable function syntax: getcvar($var,$ecms) Description: $var: is the variable name $ecms: 0 is to set the foreground COOKIE variable, 1 is to set the background COOKIE variable. This parameter can be omitted and defaults to 0. Usage example: getcvar('mlusername'), get the user name of the front-end login member getcvar('loginu...
👁 295
Empire CMS smart label call field collection

Empire CMS smart label call field collection Program Notes Empire cms

Collect and classify all fields that support smart tag calls into Empire CMS smart tags: [e:loop={column ID/topic ID, number of items displayed, operation type, only display pictures with titles, additional SQL conditions, display sorting}] Template code content [/e:loop] Calling time: <?=date('m-d',$bqr[newstime])?> <?=dat…
👁 3749

Recommended reading

PHP: Check whether a directory with a specified characteristic exists; if not, create it.

PHP: Check whether a directory with a specified characteristic exists; if not, create it. Language Notes PHP

Write a PHP function that checks whether a specified directory contains a subdirectory with the prefix "admin-"; if such a directory exists, return its name; otherwise, create a new directory. The first parameter should be "admin-", and the second parameter should be the name of the new directory to be created. Here is a PHP function that implements this functionality: The function first checks whether the specified directory contains any subdirectory that starts with ""admin-""; if...
👁 170
(Adaptive Mobile Version) Webmaster Website Directory PBootCMS Template – Website Directory Source Code Download – 0376

(Adaptive Mobile Version) Webmaster Website Directory PBootCMS Template – Website Directory Source Code Download – 0376 Practical Collection pbootcms Template

An adaptive mobile-friendly webmaster URL navigation and website directory PbootCMS template. Its clear, categorized design makes it ideal for website directory indexing and URL navigation services. It helps website operators organize online resources, attract visitors, and encourage them to submit their sites for indexing. Template Preview | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin | Extraction Password: www.4s5.cn | Related Articles: Pb...
👁 35
Firefighting and Security Equipment Website Template 0299

Firefighting and Security Equipment Website Template 0299 Practical Collection Yiyou template

This EyouCMS template is ideal for the fire safety, firefighting, and security products industry. Its eye-catching and professional design effectively showcases fire safety products, security equipment, security solutions, and corporate strength. It enables security and fire safety companies to showcase their products online, attracting both corporate and government procurement opportunities. Template Display | Installation Instructions | Website Backend: /login.php | Username: admin | Password: admin | Related Articles: Summary of Common Installation Issues for EyouCMS...
👁 54
(Adaptive mobile version) Simplified/Traditional Chinese bilingual responsive HTML5 universal financial capital consulting website single-page PBootCMS template – 0377

(Adaptive mobile version) Simplified/Traditional Chinese bilingual responsive HTML5 universal financial capital consulting website single-page PBootCMS template – 0377 Practical Collection pbootcms Template

This is an adaptive, bilingual (Simplified and Traditional Chinese) responsive universal financial capital consulting brochure template built with PbootCMS, designed for mobile devices. Its professional marketing-oriented design is ideal for financial consulting and capital services companies seeking to enhance their online presence and acquire new customers. The bilingual support facilitates market expansion across both sides of the Taiwan Strait. Template Preview | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin | Extraction Password: www.4s5.cn | Related Articles...
👁 42
Kitchen & Bathroom Faucet Website Template 0300

Kitchen & Bathroom Faucet Website Template 0300 Practical Collection Yiyou template

An eYouCMS website template designed for the kitchen, bathroom, and faucet industries. Featuring a modern and practical design style, it is ideal for showcasing bathroom products, faucet collections, kitchen and bathroom space designs, and brand identity. This template helps kitchen and bathroom brands effectively present their products online and attract customers in the home decoration and construction sectors. Template Display | Installation Instructions | Website Backend: /login.php | Username: admin | Password: admin | Related Articles: Summary of Common Installation Issues for eYouCMS...
👁 44