迅睿CMS框架是一款PHP8高性能·簡單易用的CMS開源開發框架,基于MIT開源許可協議發布,免費且不限制商業使用,是免費開源的產品,以萬端互聯為設計理念,支持的微信公眾號、小程序、APP客戶端、移動端網站、PC網站等多終端式管理系統。
聯系官方銷售客服
1835022288
028-61286886
您好,我從織夢搬遷過來后,數據也按照流程去導入了,但是發現導入的文章會出現在普通文章下面,目錄是article,我怎么能把這個article改為news呢?如下圖
也就是說我想把現在的模塊改為news
@回復@迅??蚣芗夹g-景攸
卸載后我怎么把現在的普通文章的 article改為news 呢?
因為我有和其他工具做對接,不是news就調用不出來,就是現在欄目和模塊要是news
回復@鋤禾日當午 我這邊移動要用那個表名為news的,就是現在的article怎么改為news呢?
操作版本:xunruicms 4.5.2 數據庫名:alang
記得先備份數據庫,并確保cms沒有安裝news模塊,數據庫中也沒有對應的news表,sql語句如下:
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后臺:更新緩存和更新數據。
@回復@迅??蚣芗夹g-景攸
卸載后我怎么把現在的普通文章的 article改為news 呢?
因為我有和其他工具做對接,不是news就調用不出來,就是現在欄目和模塊要是news
回復@鋤禾日當午 我這邊移動要用那個表名為news的,就是現在的article怎么改為news呢?
操作版本:xunruicms 4.5.2 數據庫名:alang
記得先備份數據庫,并確保cms沒有安裝news模塊,數據庫中也沒有對應的news表,sql語句如下:
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后臺:更新緩存和更新數據。