MySQL Database Error

FiveM Server Development Server Discussion
, ,
1

Hello,

I am developing a fivem server which is being hosted off of a VPS. When starting the server the command prompt will show up and run through all resources showing the server online and when I leave the server it comes up with this error

1115×619
Also, when someone else join the server is comes up with this error.
1598×622

2

Looks like your position column is too short for the locations it’s trying to save, try making the column length longer

1 Like
3

Mhm ok, how would I go about doing that, I have tried doing that before but had no luck.

4

Change it to LONGTEXT or JSON

https://www.google.com/search?q=how+to+change+mysql+column+data+type

1 Like
5

Thanks the help guys, that fixed it :slight_smile:

6

Could you tell me on how to fix the second screenshot about the duplicate entry?

7

That’s scripting related. Impossible to fix without seeing the code.

8

What would you need exactly?

9

Yea don’t know but if anyone after me joins the server they don’t get saved to the database really don’t get why. I have changed the users with this ALTER TABLE users AUTO_INCREMENT = 1; still did not do nothing.