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]
[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]
错误
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
mysql版本是多少
版本是:MySQL 5.0.45
改为执行这句试试
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]