MySQL Help - Indexing nil value and query errors

FiveM Resource Development & Modding Discussion
1

image
image768×77 3.78 KB

image
image1184×111 8.06 KB

(Line 72 in here)

image
image807×664 38.8 KB

(user_information table creation)
image

user_identifiers datatable works perfectly find just the user_information wont store anything.
Not sure why its chucking these errors at me does anyone know why? (Im very unfamiliar with SQL)

2

first of all I think you don’t need ON UPDATE CASCADE and ON DELETE CASCADE in your framework.sql file

and for error in line 72, resource can’t get that data from user_information cause I think you have to do it like this :

local SpawnPos = json.decode(result[0].position)