旧数据库升级的话,先将ks_article表的数据移到ks_iteminfo,再加入专题操作就行了

sql版进企业管理器执行以下语句

Insert Into [KS_ItemInfo](ChannelID,InfoID,Title,Tid,Intro,KeyWords,PhotoUrl,AddDate,Inputer,Hits,HitsByDay,HitsByWeek,HitsByMonth,LastHitsTime,Fname,verific) select 1,id,title,tid,intro,keywords,photourl,adddate,inputer,hits,hitsbyday,hitsbyweek,hitsbymonth,LastHitsTime,fname ,verific

from KS_Article where id not in(select infoid from ks_iteminfo where channelid=1)