discuz2.5直升discuz5.0的纯SQL方法

这两天看到几个求助discuz2.5升级的帖子，2.5的升级确实有点困难，中间步骤太多，而且升级程序有个bug，不是熟手很难操作。是熟手也会有点头疼吧。

这个方法是很久以前我自己论坛升级时写的，所以是5.0版，至于升5.5懒得再写了，5.0to5.5还是很简单的。包里的内容懂一点SQL的人应该一目了然。升级就是这么简单。按照我的说明执行SQL就是，用不了几分钟。

光支持啊，不给加钱

我就4块钱吖~

有沒有人嘗試過可升級到5.5？
繁體版本可以嗎？

错误
SQL 查询:  

INSERT INTO cdb_members(

uid,
username,

PASSWORD ,
secques,
gender,
adminid,
groupid,
groupexpiry,
extgroupids,
regip,
regdate,
lastip,
lastvisit,
lastactivity,
lastpost,
posts,
digestposts,
oltime,
pageviews,
credits,
extcredits1,
extcredits2,
extcredits3,
extcredits4,
extcredits5,
extcredits6,
extcredits7,
extcredits8,
avatarshowid,
email,
bday,
sigstatus,
tpp,
ppp,
styleid,
dateformat,
timeformat,
pmsound,
showemail,
newsletter,
invisible,
timeoffset,
newpm,
accessmasks,
editormode,
customshow,
xspacestatus
)
SELECT uid, username,
PASSWORD , secques, gender, adminid, groupid, 0, '', regip, regdate, lastip, lastvisit, lastactivity, lastpost, postnum, 0, 0, 0, credit, 0, 0, 0, 0, 0, 0, 0, 0, 0, email, bday, 1, tpp, ppp, styleid, dateformat, timeformat, 1, showemail, newsletter, invisible, timeoffset, newpm, accessmasks, 2, 26, 0
FROM i9527.cdb_members

MySQL 返回：

#1366 - Incorrect integer value: 'h:i A' for column 'timeformat' at row 1

到CDB_MEMBERS这步也走不下去了

你把下面的

tpp, ppp, styleid, dateformat, timeformat,

改成

tpp, ppp, styleid, dateformat, 0,

试试

这次报这个错

误
SQL 查询:  

INSERT INTO cdb_members(

uid,
username,

PASSWORD ,
secques,
gender,
adminid,
groupid,
groupexpiry,
extgroupids,
regip,
regdate,
lastip,
lastvisit,
lastactivity,
lastpost,
posts,
digestposts,
oltime,
pageviews,
credits,
extcredits1,
extcredits2,
extcredits3,
extcredits4,
extcredits5,
extcredits6,
extcredits7,
extcredits8,
avatarshowid,
email,
bday,
sigstatus,
tpp,
ppp,
styleid,
dateformat,
timeformat,
pmsound,
showemail,
newsletter,
invisible,
timeoffset,
newpm,
accessmasks,
editormode,
customshow,
xspacestatus
)
SELECT uid, username,
PASSWORD , secques, gender, adminid, groupid, 0, '', regip, regdate, lastip, lastvisit, lastactivity, lastpost, postnum, 0, 0, 0, credit, 0, 0, 0, 0, 0, 0, 0, 0, 0, email, bday, 1, tpp, ppp, styleid, dateformat, 0, 1, showemail, newsletter, invisible, timeoffset, newpm, accessmasks, 2, 26, 0
FROM i9527.cdb_members

MySQL 返回：

#1062 - Duplicate entry 'Admin' for key 'username'

是不是一个区分大小写的问题
我看了一下中断处的纪录
正好是一个重复的用户名 Admin
之前有一个小写的admin用户了

调试环境为XPiis5+php523+mysql52