迅睿CMS框架是一款PHP8高性能·簡(jiǎn)單易用的CMS開(kāi)源開(kāi)發(fā)框架,基于MIT開(kāi)源許可協(xié)議發(fā)布,免費(fèi)且不限制商業(yè)使用,是免費(fèi)開(kāi)源的產(chǎn)品,以萬(wàn)端互聯(lián)為設(shè)計(jì)理念,支持的微信公眾號(hào)、小程序、APP客戶(hù)端、移動(dòng)端網(wǎng)站、PC網(wǎng)站等多終端式管理系統(tǒng)。
聯(lián)系官方銷(xiāo)售客服
1835022288
028-61286886
您好,我從織夢(mèng)搬遷過(guò)來(lái)后,數(shù)據(jù)也按照流程去導(dǎo)入了,但是發(fā)現(xiàn)導(dǎo)入的文章會(huì)出現(xiàn)在普通文章下面,目錄是article,我怎么能把這個(gè)article改為news呢?如下圖
也就是說(shuō)我想把現(xiàn)在的模塊改為news
@回復(fù)@迅??蚣芗夹g(shù)-景攸
卸載后我怎么把現(xiàn)在的普通文章的 article改為news 呢?
因?yàn)槲矣泻推渌ぞ咦鰧?duì)接,不是news就調(diào)用不出來(lái),就是現(xiàn)在欄目和模塊要是news
回復(fù)@鋤禾日當(dāng)午 我這邊移動(dòng)要用那個(gè)表名為news的,就是現(xiàn)在的article怎么改為news呢?
操作版本:xunruicms 4.5.2 數(shù)據(jù)庫(kù)名:alang
記得先備份數(shù)據(jù)庫(kù),并確保cms沒(méi)有安裝news模塊,數(shù)據(jù)庫(kù)中也沒(méi)有對(duì)應(yīng)的news表,sql語(yǔ)句如下:
UPDATE `dr_1_share_category` SET `mid` = replace (`mid`,'article','news');
UPDATE `dr_1_share_index` SET `mid` = replace (`mid`,'article','news');
UPDATE `dr_admin_menu` SET `uri` = replace (`url`,'article','news');
UPDATE `dr_admin_menu` SET `mark` = replace (`mark`,'article','news');
UPDATE `dr_admin_min_menu` SET `uri` = replace (`url`,'article','news');
UPDATE `dr_admin_min_menu` SET `mark` = replace (`mark`,'article','news');
UPDATE `dr_module` SET `dirname` = replace (`dirname`,'article','news');
RENAME TABLE `alang`.`dr_1_article` TO `alang`.`dr_1_news`;
RENAME TABLE `alang`.`dr_1_article_category` TO `alang`.`dr_1_news_category`;
RENAME TABLE `alang`.`dr_1_article_category_data` TO `alang`.`dr_1_news_category_data`;
RENAME TABLE `alang`.`dr_1_article_data_0` TO `alang`.`dr_1_news_data_0`;
RENAME TABLE `alang`.`dr_1_article_draft` TO `alang`.`dr_1_news_draft`;
RENAME TABLE `alang`.`dr_1_article_flag` TO `alang`.`dr_1_news_flag`;
RENAME TABLE `alang`.`dr_1_article_hits` TO `alang`.`dr_1_news_hits`;
RENAME TABLE `alang`.`dr_1_article_index` TO `alang`.`dr_1_news_index`;
RENAME TABLE `alang`.`dr_1_article_recycle` TO `alang`.`dr_1_news_recycle`;
RENAME TABLE `alang`.`dr_1_article_search` TO `alang`.`dr_1_news_search`;
RENAME TABLE `alang`.`dr_1_article_time` TO `alang`.`dr_1_news_time`;
RENAME TABLE `alang`.`dr_1_article_verify` TO `alang`.`dr_1_news_verify`;
完事,記得在cms后臺(tái):更新緩存和更新數(shù)據(jù)。
@回復(fù)@迅??蚣芗夹g(shù)-景攸
卸載后我怎么把現(xiàn)在的普通文章的 article改為news 呢?
因?yàn)槲矣泻推渌ぞ咦鰧?duì)接,不是news就調(diào)用不出來(lái),就是現(xiàn)在欄目和模塊要是news
回復(fù)@鋤禾日當(dāng)午 我這邊移動(dòng)要用那個(gè)表名為news的,就是現(xiàn)在的article怎么改為news呢?
操作版本:xunruicms 4.5.2 數(shù)據(jù)庫(kù)名:alang
記得先備份數(shù)據(jù)庫(kù),并確保cms沒(méi)有安裝news模塊,數(shù)據(jù)庫(kù)中也沒(méi)有對(duì)應(yīng)的news表,sql語(yǔ)句如下:
UPDATE `dr_1_share_category` SET `mid` = replace (`mid`,'article','news');
UPDATE `dr_1_share_index` SET `mid` = replace (`mid`,'article','news');
UPDATE `dr_admin_menu` SET `uri` = replace (`url`,'article','news');
UPDATE `dr_admin_menu` SET `mark` = replace (`mark`,'article','news');
UPDATE `dr_admin_min_menu` SET `uri` = replace (`url`,'article','news');
UPDATE `dr_admin_min_menu` SET `mark` = replace (`mark`,'article','news');
UPDATE `dr_module` SET `dirname` = replace (`dirname`,'article','news');
RENAME TABLE `alang`.`dr_1_article` TO `alang`.`dr_1_news`;
RENAME TABLE `alang`.`dr_1_article_category` TO `alang`.`dr_1_news_category`;
RENAME TABLE `alang`.`dr_1_article_category_data` TO `alang`.`dr_1_news_category_data`;
RENAME TABLE `alang`.`dr_1_article_data_0` TO `alang`.`dr_1_news_data_0`;
RENAME TABLE `alang`.`dr_1_article_draft` TO `alang`.`dr_1_news_draft`;
RENAME TABLE `alang`.`dr_1_article_flag` TO `alang`.`dr_1_news_flag`;
RENAME TABLE `alang`.`dr_1_article_hits` TO `alang`.`dr_1_news_hits`;
RENAME TABLE `alang`.`dr_1_article_index` TO `alang`.`dr_1_news_index`;
RENAME TABLE `alang`.`dr_1_article_recycle` TO `alang`.`dr_1_news_recycle`;
RENAME TABLE `alang`.`dr_1_article_search` TO `alang`.`dr_1_news_search`;
RENAME TABLE `alang`.`dr_1_article_time` TO `alang`.`dr_1_news_time`;
RENAME TABLE `alang`.`dr_1_article_verify` TO `alang`.`dr_1_news_verify`;
完事,記得在cms后臺(tái):更新緩存和更新數(shù)據(jù)。