delete from useraccounts where userid='pre-reg-1';
INSERT INTO useraccounts VALUES
(NULL,'pre-reg-1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'王英','100','2',NULL,1000,NULL,NULL,NULL,NULL,NULL,'中国银行','大客户经理',NULL,NULL,'13701272752','111111','13701272752',NULL,NULL,NULL,'100','100','100','100',NULL,NULL,NULL,NULL,NULL,'94','2014-11-13 16:08:31','2014-11-13 16:08:31','1');
检查是预注册用户的问题?还是usermacs/useractive表结构不一致造成的(检查数据库截图中的列)?
创建预注册用户的sql语句(用这个数据测试一下)
delete from useraccounts where userid='pre-reg-1'; INSERT INTO
useraccounts
VALUES (NULL,'pre-reg-1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'王英','100','2',NULL,1000,NULL,NULL,NULL,NULL,NULL,'中国银行','大客户经理',NULL,NULL,'13701272752','111111','13701272752',NULL,NULL,NULL,'100','100','100','100',NULL,NULL,NULL,NULL,NULL,'94','2014-11-13 16:08:31','2014-11-13 16:08:31','1');测试截屏:
数据库状态:usermacs / useractive中没有写进去