[HELP] I get an error with sql

FiveM Server Development ES/ESX
,
1

Hello, I need help with sql this is the error

[ERROR] [es_extended] An error happens for query “INSERT INTO users SET accounts = ?, identifier = ?, group = ?, firstname = ?, lastname = ?, dateofbirth = ?, sex = ?, height = ? : [”{“bank”:5000}",“char2:fea566f2046bdeed6610440c4588b9322158a5bd”,“user”,“as”,“as”,“11/11/1999”,“f”,“67”]": ER_NO_DEFAULT_FOR_FIELD: Field ‘tasks’ doesn’t have a default value

Any solutions?

2

Hello, as said in the error, your column tasks doesn’t have a default value. You have two options, either you add a default value to your column tasks, either you specify a value for tasks in your INSERT.

I don’t know what your tasks column is for, but I would say that the best solution would be to add a default value, so that you won’t have to edit multiple sql queries.
Good luck :slight_smile:

3

thanks I just needed to get on the right track <3

4

You’re welcome :smiley: