I have ''Field 'id'doesn't have a default value.'' problem. Please Help.

Bloosy's profile image Bloosy posted 4 years ago in General Permalink

Hello HeidiSQL developers. I have this problem. I have a FiveM Server. Please help. There is a images;

1 attachment(s):
  • problem1
ansgar's profile image ansgar posted 4 years ago Permalink

This is an issue with your table definition, not with HeidiSQL itself. The addon_inventory has an "id" column, and your INSERT query did not provide a value for that id.

Bloosy's profile image Bloosy posted 4 years ago Permalink

So, What can i do ?

ansgar's profile image ansgar posted 4 years ago Permalink

You have to either provide a value for "id" in your INSERT query. Or you add a default value for "id" in the table definition:

Description

Bloosy's profile image Bloosy posted 4 years ago Permalink

THANK YOU VERY MUCH! YOU ARE THE BEST!

BubikolRamios's profile image BubikolRamios posted 4 years ago Permalink

To borrow upper image... id is type of int, if you select custom text(not logical) and enter something like 0 it shows '0'

Should be custom value right ? And in this case 0 not '0'

Please login to leave a reply, or register at first.