整合BBS后出现注册问题

2016-07-07 15:51 来源：www.chinab4c.com 作者：ecshop专家

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT SUM(user_money) FROM `surprise`.`ecs_account_log` WHERE user_id = '3' ) [2] => Array ( [error] => Table 'surprise.ecs_account_log' doesn't exist ) [3] => Array ( [errno] => 1146 ) )
不知道是什么。。。 看E文好像是建用户出现问题
可又能登录使用资金管理 那 一点就这样了

回答：
Discuz! info: MySQL Query Error

Time: 2009-1-3 12:35pm
Script: /bbs/bbs/register.php

SQL: INSERT INTO [Table]members (uid, username, password, secques, gender, adminid, groupid, regip, regdate, lastvisit, lastactivity, posts, credits, extcredits1, extcredits2, extcredits3, extcredits4, extcredits5, extcredits6, extcredits7, extcredits8, email, bday, sigstatus, tpp, ppp, styleid, dateformat, timeformat, pmsound, showemail, newsletter, invisible, timeoffset)
VALUES ('2', 'czevpp', '7381ddad3a8bb575d8b9d234b090a303', '', '0', '0', '10', '119.142.196.193', '1230957322', '1230957322', '1230957322', '0', 0,0,0,0,0,0,0,0,0, 'czevpp@163.com', '0000-00-00', '0', '0', '0', '', '0', '0', '1', '1', '1', '0', '9999')
Error: Duplicate entry '2' for key 1
Errno.: 1062

第一次的错误是表不存在　第二次是会员名重复冲突


QQ 4 1 7 3 3 1 5 1 8


1.table 'surprise.ecs_account_log' doesn't exist
surprise.ecs_account_log数据表不存在。找一下商城根目录下的install/data/structure.sql文件中对应的创建数据表语句，然后将语句在PHPMYADMIN下执行一下

2.Duplicate entry '2' for key 1
请参考此贴：
http://bbs.ecshop.com/viewthread ... t=Duplicate%2Bentry