在执行
#2) 把曼波用户表 mos_users 记录插入到 Discuz 用户表 cdb_members
SELECT @groupid := groupid FROM cdb_usergroups WHERE creditshigher<=0 AND 0<creditslower ORDER BY groupid ASC LIMIT 1;
INSERT INTO cdb_members (uid, username, password, secques, groupid, extgroupids, regip, regdate, lastvisit, lastactivity, email, dateformat, showemail, newsletter, timeoffset )
SELECT id, username, password, '', CASE `block` when 0 then @groupid ELSE 8 END, '', '', UNIX_TIMESTAMP(registerDate), UNIX_TIMESTAMP(lastvisitDate), UNIX_TIMESTAMP(lastvisitDate), email, '', '1', '1', '9999' FROM mos_users;
INSERT INTO cdb_memberfields (uid) SELECT id FROM mos_users;
时出现：
SQL 查询: 
INSERT INTO cdb_members( uid, username,
PASSWORD , secques, groupid, extgroupids, regip, regdate, lastvisit, lastactivity, email, dateformat, showemail, newsletter, timeoffset )
SELECT id, username,
PASSWORD , '',
CASE `block`
WHEN 0
THEN @groupid
ELSE 8
END , '', '', UNIX_TIMESTAMP( registerDate ) , UNIX_TIMESTAMP( lastvisitDate ) , UNIX_TIMESTAMP( lastvisitDate ) , email, '', '1', '1', '9999'
FROM mos_users
MySQL 返回：
#1366 - Incorrect integer value: '' for column 'dateformat' at row 1
麻烦大虾看看
