BBSxp5.16转D4的时候发现如下错误
插入会员 uid = 2 , username = 冰冰甜甜 会员基本数据出错!
数据表: cdb_members
语句: 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` ) VALUES ('2','冰冰甜甜','87037da7ba3ca1ac6d0f3044fad3346d','','2','0','10','0','','bbsxp','1121385600','bbsxp','1163094720','1163094720','1163094720','331','0','0','0','1150','1150','0','0','0','0','0','0','0','0','piao79418@yahoo.com.cn','','1','0','0','0','0','0','0','0','1','0','9999','0','0');
错误: Incorrect date value: '' for column 'bday' at row 1
[ 本帖最后由 level20000 于 2007-2-13 10:17 编辑 ] |