SQLSTATE[HY000]: General error: 1364 Field ‘phone’ doesn’t have a default value (SQL: insert into `products` (`name`, `email`, `address`, `image`, `updated_at`, `created_at`) values (amti, kuam@gmail.com, sdafasdf, 642917381.jpg, 2021–05–11 10:58:35, 2021–05–11 10:58:35))
When I’m submit form then got General error field doesn’t have default value. let’s go to solve this.
👉 1 step go to your database and put change none>to Null and save.
Lets go to phpmyadmin
👉 Click on Structure
Click on change and change all field to None to Null and save
Set Null and click on save button
👁👁 Now its error has been solved and your data has been stored successfully.
Thanks
Latest posts by rajeshkumar (see all)
- Terraform Error with Azure - October 9, 2023
- Kubernetes EKS Error: ConfigurationConflict Conflicts found when trying to applyKubernetes EKS Error: - October 5, 2023
- Kubernetes: How to change pvc storage class from one to another? - October 5, 2023