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;