首页 > 文章资讯 > 技术教程 > 帝国cms教程 > zblog网站内容导入帝国cms需要用到的sql语句

zblog网站内容导入帝国cms需要用到的sql语句

时间：2023年11月27日

来源：网络

编辑：佚名

update phome_ecms_article set titleurl=REPLACE(titleurl,'post/','');
SELECT * from phome_ecms_news where classid=1;
update phome_ecms_news set titleurl=REPLACE(titleurl,'//','/post/');
update phome_ecms_article set titleurl=REPLACE(titleurl,'xiaoshuo/','');
UPDATE phome_ecms_news set titleurl=CONCAT('/post/',id,'.html');
zblog数据导入帝国cms后更新文章出现错误提示
Table 'moban_aiyiliu_com.***_ecms_info_data_' doesn't exist
select keyid,dokey,newstempid,closepl,infotags,email,mycontact,address from ***_ecms_info_data_ where id='7' limit 1
Table 'moban_aiyiliu_com.***_ecms_' doesn't exist
select * from ***_ecms_ where id='2' limit 1
Table 'moban_aiyiliu_com.***_ecms_' doesn't exist
select * from ***_ecms_ where id='2' limit 1
Table 'moban_aiyiliu_com.***_ecms_download_data_' doesn't exist
select keyid,dokey,newstempid,closepl,infotags,softwriter,homepage,demo,downpath from ***_ecms_download_data_ where id='771' limit 1
其中zblog中的分类id 1-8都是有内容的，帝国cms中的classid都是非终极栏目，不能添加内容，需要修改成其他的终极栏目
sql命令如下
UPDATE phome_ecms_article set classid=26 where classid=1;

新闻资讯更多

猜你需要