修改密码一致报sql的错

来源:6-7 编辑和添加

qq_且行且珍惜_32

2020-11-02

修改密码一致报sql的错

Exception (Database Exception) ‘yii\db\Exception’ with message ‘SQLSTATE[HY000]: General error: 1364 Field ‘login_pwd’ doesn’t have a default value
The SQL being executed was: INSERT INTO user (nickname, mobile, email, avatar, login_name, updated_time) VALUES (‘郭威11122’, ‘11012345678’, ‘apanly@163.com’, ‘default_avatar’, ‘test42’, ‘2020-11-02 23:39:05’)’ 图片描述

in E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\db\Schema.php:677

Stack trace:
#0 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\db\Command.php(1298): yii\db\Schema->convertException(Object(PDOException), ‘INSERT INTO us...') #1 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\db\Command.php(1093): yii\db\Command->internalExecute('INSERT INTOus…’)
#2 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\db\Schema.php(432): yii\db\Command->execute()
#3 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\db\ActiveRecord.php(600): yii\db\Schema->insert(‘user’, Array)
#4 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\db\ActiveRecord.php(566): yii\db\ActiveRecord->insertInternal(NULL)
#5 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\db\BaseActiveRecord.php(678): yii\db\ActiveRecord->insert(0, NULL)
#6 E:\phpstudy_pro\WWW\book.mooc.test\basic\modules\web\controllers\AccountController.php(131): yii\db\BaseActiveRecord->save(0)
#7 [internal function]: app\modules\web\controllers\AccountController->actionSet()
#8 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array)
#9 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\base\Controller.php(180): yii\base\InlineAction->runWithParams(Array)
#10 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\base\Module.php(528): yii\base\Controller->runAction(‘set’, Array)
#11 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction(‘web/account/set’, Array)
#12 E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\base\Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request))
#13 E:\phpstudy_pro\WWW\book.mooc.test\basic\web\index.php(19): yii\base\Application->run()
#14 {main}
图片描述

写回答

2回答

编程浪子

2020-11-20

你好

根据你目前的报错,我大概了解到你可能对数据库不太了解。

1062 Duplicate entry 'test42' for key 'login_name'  ,说明 login_name 重复了,登录用户名不能一样的

你可以test43 

0
0

编程浪子

2020-11-05

你好

Exception (Database Exception) ‘yii\db\Exception’ with message ‘SQLSTATE[HY000]: General error: 1364 Field ‘login_pwd’ doesn’t have a default value

根据报错,login_pwd 没有给默认值,然后有要求必须填写。

0
2
qq_且行且珍惜_32
Exception (Integrity constraint violation) 'yii\db\IntegrityException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'test42' for key 'login_name' The SQL being executed was: INSERT INTO `user` (`uid`, `nickname`, `mobile`, `email`, `avatar`, `login_name`, `login_pwd`, `updated_time`) VALUES ('6', '郭威11122阿打算', '11012345678', 'apanly@163.com', 'default_avatar', 'test42', '******', '2020-11-20 01:07:18')' in E:\phpstudy_pro\WWW\book.mooc.test\basic\vendor\yiisoft\yii2\db\Schema.php:677
2020-11-20
共2条回复

微信服务号+Yii2.0构建商城系统全栈应用

传统PC后端与火热微信结合,打造一个摩登的商业电商系统

757 学习 · 744 问题

查看课程