修改密码一致报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
00 -
编程浪子
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 没有给默认值,然后有要求必须填写。
022020-11-20
相似问题