在转换时发现第一个数据表(会员与在线时间)无法转换,但其他的都转换成功,这是错误代码:
XConvert info: MySQL Query Error
Time: 2008-5-17 7:54am
SQL: REPLACE INTO wagezx.cdb_usergroups (groupid, radminid, type, system, grouptitle, creditshigher, creditslower, stars, color, groupavatar, readaccess, allowvisit, allowpost, allowreply, allowpostpoll, allowpostreward, allowposttrade, allowpostactivity, allowdirectpost, allowgetattach, allowpostattach, allowvote, allowmultigroups, allowsearch, allowavatar, allowcstatus, allowuseblog, allowinvisible, allowtransfer, allowsetreadperm, allowsetattachperm, allowhidecode, allowhtml, allowcusbbcode, allowanonymous, allownickname, allowsigbbcode, allowsigimgcode, allowviewpro, allowviewstats, disableperiodctrl, reasonpm, maxprice, maxpmnum, maxsigsize, maxattachsize, maxsizeperday, maxpostsperhour, attachextensions, raterange, mintradeprice, maxtradeprice, minrewardprice, maxrewardprice, magicsdiscount, allowmagics, maxmagicsweight, allowbiobbcode, allowbioimgcode, maxbiosize) VALUES ('31', 0, 'special', 'private', '荣誉会员', 50, 200, 2, '', '', 20, 1, 1, 1, 1, 0, 1, 0, 0, 1, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 30, 100, 0, 0, 0, 'chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png', '', 1, 0, 1, 0, 0, 1, 60, 0, 0, 0)
Error: Unknown column 'maxpmnum' in 'field list'
Errormsg.: 字段不存在
程序文件跟数据库有冲突,请使用正确的程序文件上传上去覆盖
转换后的影响,主要就是附件的影响,PW的附件储存方式有好几种,我就是选择版板块储存的。等把附件复制过来时好药找到所有的附件文件一起放到DZ的attachments文件夹里。
还有就是表情图片无法显示。
还有一点就帖子的丢失问题,帖子会丢失以小部分!
这就是我本人转换后的问题!
以上还不知道如何解决!请大家参考下,给个解决办法!!! |