[MYSQL] An critical error happens on MYSQL for query "UPDATE" users

FiveM Resource Development & Modding Discussion
1

Hello guys!

I have a problem in my server, some times that give me a error about my MYSQL, maybe can be because i don’t have my script in the last version “mysql-sync”, or maybe is something wrong in my DB.

Someone know how to fix that?, here i let my screenshot in console:
https://prnt.sc/myjewu

My DB table “users”
http://prntscr.com/myjh5r

And some times, my server give me a error about fivem key, i need change the key to my server, is random this error about fivem key.

If someone know how to fix this, is very nice to me
Thank you guys =)

2

I do not know what it can be but try to check the following things:

  • update your sql scripts (mainly mysql-async)
  • go to server.cfg and check if is written “server=localhost…”
example:

set mysql_connection_string "server=localhost;database=essentialmode;userid=username;password=pass"
  • go deactivating script by script until you find what is giving problem to facilitate the solution
1 Like