Why does it give such an error when adding to the database after submitting the form?

Question

MySQL

Database Exception - yii\db\Exception
SQLSTATE[HY000]: General error: 1364 Field 'auth_key' doesn't have a default value
The SQL being executed was: INSERT INTO `user` (`email`, `password`, `code `) VALUES ('[email protected]', '$2y$13$1ljpJOqVd.w69P.M/R1tK.PsbyAP3lYL2bSHa05yOxDnxFFGmu9wa', '3PteL1biWt')
Error Info: Array
(
[0] => HY000
[1] => 1364
[ 2] => Field 'auth_key' doesn't have a default value
)

Answer 1

the issue is resolved: in the database it was necessary to set the default value NULL in the auth_key cell

Answer 2

The user table has an auth_key field. This field is not set to a value in your INSERT INTO code and is not set to a default value when the table is created. Hence the error.