dv8.2sql转换user表时出现 Unknown column 'maxpmnum' in 'field list'

DvBBS 8.x SQL => Discuz! 6.0 转换程序

--------------------------------------------------------------------------------

欢 迎 使 用 本 程 序  

--------------------------------------------------------------------------------


XConvert info: MySQL Query Error

Time: 2008-7-17 3:18am
SQL: REPLACE INTO discuz.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 ('23', 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.: 字段不存在

使用的是XConvert1.3,谁能帮我看看这是什么原因啊

[ 本帖最后由 han20001234 于 2008-7-17 11:56 编辑 ]

转换主题与投票时出错

SQL: SELECT userid FROM cw1c063.dv_voteuser WHERE voteid=1 AND (voteoption='0' OR LEFT(voteoption, 2)='0,' OR LEFT(voteoption, 3)='0,' OR CHARINDEX(',0,', voteoption)>0 OR RIGHT(voteoption, 2)=',0' OR RIGHT(voteoption, 3)=',0')
Errormsg: MSSQL ERROR

[ 本帖最后由 han20001234 于 2008-7-17 11:48 编辑 ]

请使用最新转换程序：
https://discuz.dismall.com/thread-941638-1-1.html

我用了,新的程式也一样

贴下具体错误提示

XConvert info: MySQL Query Error

Time: 2008-8-13 7:02am
SQL: REPLACE INTO hechuan.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 ('23', 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.: 字段不存在
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖


我也遇到这个问题

在“dz程序发布区”----“xconvert程序发布”里边有最新的转换程序

SQL: SELECT userid FROM Dv_voteuser WHERE voteid=1 AND (voteoption='0' OR LEFT(voteoption, 2)='0,' OR LEFT(voteoption, 3)='0,' OR CHARINDEX(',0,', voteoption)>0 OR RIGHT(voteoption, 2)=',0' OR RIGHT(voteoption, 3)=',0')
Errormsg: MSSQL ERROR

出现以上错误!

你能不能把你原来数据库中voteuser数据表的结构贴出来看看，最好附带一两条数据。

dv8.2转DZ总是提示
XConvert info: MySQL Query Error

Time: 2008-8-15 4:03pm
SQL: REPLACE INTO discuz.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 ('23', 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.: 字段不存在
Errno.: 1054

我是用XConvert1.3.0转的呀！

我是DV8.2ACCESS数据库的，就是用户名转不了，其他都能转，谁能帮帮我啊

[ 本帖最后由 szswq 于 2008-8-16 00:07 编辑 ]