论坛转换网's Archiver

白乐天 发表于 2008-6-25 23:35

dz6.1忘记备份uc数据的补救方法

登入phpmyadmin,依次执行以下4句话。作之前要备份好uc数据。
[quote]truncate table uc_members[/quote]
[quote]truncate table uc_memberfields[/quote]
[quote]insert into uc_members
(uid,username,password,email,myid,myidkey,regip,regdate,lastloginip,lastlogintime,salt)
select uid,username,md5(concat(PASSWORD,'123456')),email,'','',regip,regdate,lastip,lastvisit,'123456'
from cdb_members[/quote]
[quote]insert into uc_memberfields (uid,blacklist)
select uid,'' from cdb_members[/quote]
[color=Red][b]这个方法可以补回所有会员,使登陆无碍,但dz6.1后注册的新用户会密码失效。
所谓具体问题具体分析,这里只写了UC只有一个论坛,而且UC与论坛放在同一数据库的情况,更复杂的也可以同理补充。
[/b][/color]

xingyi333 发表于 2008-8-12 13:19

[quote]insert into uc_members
(uid,username,password,email,myid,myidkey,regip,regdate,lastloginip,lastlogintime,salt)
select uid,username,md5(concat(PASSWORD,'123456')),email,'','',regip,regdate,lastip,lastvisit,'123456'
from cdb_members[/quote]这句话,根本无法执行啊!提示错误!

xingyi333 发表于 2008-8-12 13:30

这句话,根本无法执行啊!提示错误! [/quote]
错误
SQL 查询:  
INSERT INTO uc_members(
uid,
username,
PASSWORD ,
email,
myid,
myidkey,
regip,
regdate,
lastloginip,
lastlogintime,
salt
)
SELECT uid, username, md5( concat(
PASSWORD , '123456' ) ) , email, '', '', regip, regdate, lastip, lastvisit, '123456'
FROM cdb_members
MySQL 返回:
#1265 - Data truncated for column 'lastloginip' at row 1

白乐天 发表于 2008-8-12 18:56

mysql版本是多少

xingyi333 发表于 2008-8-12 21:06

版本是:MySQL 5.0.45

白乐天 发表于 2008-8-12 21:40

改为执行这句试试

INSERT INTO uc_members(
uid,
username,
PASSWORD ,
email,
myid,
myidkey,
regip,
regdate,
lastloginip,
lastlogintime,
salt
)
SELECT uid, username, md5( concat(
PASSWORD , '123456' ) ) , email, '', '', regip, regdate, '0', lastvisit, '123456'
FROM cdb_members



页: [1]

Powered by Discuz! Archiver 7.0.0  © 2001-2009 Comsenz Inc.