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)
- The Three Pillars of Digital Resilience in 2025: Database Administration, Cybersecurity, and Vulnerability Assessment - September 24, 2025
- Avionics Technician: The Backbone of Modern Aviation - September 12, 2025
- Top 20 Computer Vision Libraries - August 26, 2025