[SOLVED] Laravel General error: 1364 Field 'id' doesn't have a default value
This is my solution on how I was able to fix this error in my Laravel application for MySQL maria database [5189], Last Updated: Tue Aug 22, 2023
cathy
Tue Aug 22, 2023
0 Comments
3408 Visits
You need to set AUTO_INCREMENT for primary key column to avoid error in laravel api call.
There I was developing my Laravel API for my react application when I see the following 500 error in my console:
Server Error
OK now what. I looked my Laravel Error Logs at: storage/logs and this is what shows up:
[2023-08-22 19:09:59] production.ERROR: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value (SQL: insert into `user_tasks` (`user_id`....) values (32...) [stacktrace]
Solution:
Looking my my user_tasks table, everything looked fine. Field id was primary with key, not null as default. BUT i i did not see the AUTO_INCREMENT, so I added with this simple command in phpMyAdmin
ALTER TABLE `user_tasks` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT;
Done, it worked. Not getting this error anymore.