ES extended fails to save player position into db

FiveM Server Development Resource Support
1

Hi guys im recently developing a server on dedicated server linux platform and im having this issue mainly when players go Alf+F4 or exiting game without use disconect first.

[ERROR] [MySQL] [es_extended] An error happens on MySQL for query “UPDATE users SET job = ‘unemployed’, job_grade = 0, loadout = ‘’, position = ‘{"z":174.59999999998,"y":527.0,"x":1.1999999999998}’ WHERE identifier = ‘steam:11000010c45a13e’”: ER_DATA_TOO_LONG: Data too long for column ‘position’ at row 1

console%20error
console%20error1920×1080 90.6 KB

i’ve only got few resources and they seem all to load fine

I think its a question of changing mysql table value type from varchar to Longtext but im not sure if i should do that.

Hope some iluminated mind can help me :smiley: Thanks

2

That would fix the problem, or change it to JSON

1 Like