I am having the same problem. I have been trying to figure it out for over a day now (facepalm)
I spent 2 hours this morning before work tracking lua code where it calls userupdate and userretrieve functions and whatnot to see if I find some kind of hint of where I went wrong but found nothing.
I am ready to give up lol. I donât understand what is going on. I can start up and run the server with no errors. As soon as I load into the server my player model disappears and I get the same errors as you posted. Then when I check the mysql db It has added me into the users table.
Ok I wasnât sure what was causing it and I am very new to this so there is only so much trouble shooting I can do. Thank you for your time it is very much appriciated. I have reinstalled the whole server atleast 5 times and no luck. I have success setting it up with CouchDB but no luck with MySQL yet which is what all my resources require lol.
I tried reinstalling ES and esplugin_mysql, still no luck. Iâm back from work so in the meantime going to hunt some more inside the lua code and see if I can find anything that could hint to what could possibly be wrong.
Guys i need help I installed mysql-async, essentialmode, es_admin, esplugin_mysql and skin_customization I followed everything right When I start the server there is no error. The server starts normally. as when I try to press f2 to pop up the skin custumization menu these errors are generated in cmd. I think itâs something Iâm forgetting in the database, because apparently the script can not access the database, but I did everything right. I added server_script â@ mysql-async / lib / MySQL.luaâ in __resource in server.lua AddEventHandler (âonMySQLReadyâ, function ()
MReady = true
End) I also added set mysql_connection_string âserver = 127.0.0.01; database = gta5_gamemode_essential; userid = root; password =â on server.cfg Iâll leave the prints here also showing everything. Does anyone know what this error can be?
[ 0] Initializing Mono
[ 16] Initializing Mono completed
[ 16] Hello!
[ 125] Failed to get instance for guid a7242855-0350-4cb5-a0fe-61021e7eafaa and iid 567634c6-3bdd-4d0e-af39-7472aed479b7: System.InvalidOperationException: Sequence contains no matching element
[ 125] at System.Linq.Enumerable.First[TSource] (System.Collections.Generic.IEnumerable`1[T] source, System.Func`2[T,TResult] predicate) [0x00011] in <48501e5f32e8491e924f8b8beae3e4f6>:0
[ 125] at CitizenFX.Core.RuntimeManager.CreateObjectInstance (System.Guid guid, System.Guid iid) [0x00014] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\RuntimeManager.cs:39
[ 141] Found new resource esplugin_mysql in C:/server/resources//esplugin_mysql
[ 141] Found new resource fivem in C:/server/resources//fivem
[ 156] Found new resource fivem-awesome1501 in C:/server/resources//fivem-awesome1501
[ 172] Found new resource fivem-map-hipster in C:/server/resources//fivem-map-hipster
[ 172] Found new resource fivem-map-skater in C:/server/resources//fivem-map-skater
[ 188] Found new resource mysql-async in C:/server/resources//mysql-async
[ 188] Found new resource skin_customization in C:/server/resources//skin_customization
[ 203] Found new resource essentialmode in C:/server/resources//[essential]/essentialmode
[ 219] Found new resource es_admin in C:/server/resources//[essential]/es_admin
[ 219] Found new resource race in C:/server/resources//[gamemodes]/race
[ 235] Found new resource race-test in C:/server/resources//[gamemodes]/race-test
[ 235] Found new resource channelfeed in C:/server/resources//[gameplay]/channelfeed
[ 250] Found new resource irc in C:/server/resources//[gameplay]/irc
[ 250] Found new resource obituary in C:/server/resources//[gameplay]/obituary
[ 266] Found new resource obituary-deaths in C:/server/resources//[gameplay]/obituary-deaths
[ 281] Found new resource mapmanager in C:/server/resources//[managers]/mapmanager
[ 281] Found new resource baseevents in C:/server/resources//[system]/baseevents
[ 297] Found new resource chat in C:/server/resources//[system]/chat
[ 297] Found new resource hardcap in C:/server/resources//[system]/hardcap
[ 313] Found new resource â â â â â â â in C:/server/resources//[system]/â â â â â â â
[ 313] Found new resource scoreboard in C:/server/resources//[system]/scoreboard
[ 328] Found new resource sessionmanager in C:/server/resources//[system]/sessionmanager
[ 328] Found new resource spawnmanager in C:/server/resources//[system]/spawnmanager
[ 344] Found new resource betaguns in C:/server/resources//[test]/betaguns
[ 344] Found new resource gameInit in C:/server/resources//[test]/gameInit
[ 360] Found new resource keks in C:/server/resources//[test]/keks
[ 391] Started resource sessionmanager
[ 438] Started resource mapmanager
[ 453] Started resource chat
[ 469] Started resource spawnmanager
[ 485] Started resource fivem
[ 485] Started gametype KiKoZl RP Server
[ 500] Started resource hardcap
[ 516] Started resource â â â â â â â
[ 531] Started resource scoreboard
[ 1031] Loaded MySQLAsync.net, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null into ScriptDomain_11282888
[ 1063] Instantiated instance of script MySQLAsync.MySQLAsync.
[ 1063] Started resource mysql-async
[ 1110] false
[ 1125] Started resource essentialmode
[ 1156] Started resource es_admin
[ 1156] Started resource esplugin_mysql
[ 1188] Started resource skin_customization
[ 1266] Resolved live-internal.fivem.net:30110 to 151.80.44.223:30110
[ 1266] Sending heartbeat to live-internal.fivem.net:30110
[ 1297] Started resource fivem-map-skater
[ 1297] Started map fivem-map-skater
[ 1391] Loaded MySqlConnector, Version=0.24.0.0, Culture=neutral, PublicKeyToken=null into ScriptDomain_11282888
[ 1453] hitch warning: frame time of 220 milliseconds
[ 2235]
[ 2250] Current version: 4.4.2
[ 2250] Updater version: 4.4.2
[ 2250]
[ 2250] Everything is fine!
[ 2266]
[ 181313] Sending heartbeat to live-internal.fivem.net:30110
[ 313985] Connecting: âȘ[PM] Denny Novaes
[ 314969] Sending heartbeat to live-internal.fivem.net:30110
[ 355375] Triggering!
[ 355735] Loaded System.Threading.Tasks.Extensions, Version=4.1.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51 into ScriptDomain_11282888
[ 356344] hitch warning: frame time of 965 milliseconds
[ 356438] Error running call reference function for resource skin_customization: server.lua:39: attempt to index a nil value (local 'user')
[ 356453] stack traceback:
[ 356453] server.lua:39: in local 'ref'
[ 356469] citizen:/scripting/lua/scheduler.lua:277: in function <citizen:/scripting/lua/scheduler.lua:268>
[ 356485] [C]: in function 'coroutine.resume'
[ 356500] citizen:/scripting/lua/scheduler.lua:33: in field 'CreateThreadNow'
[ 356500] citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
[ 356547] Error running system event handling function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:39: Failed to execute thread: citizen:/scripting/lua/MessagePack.lua:830: missing bytes
[ 356563] stack traceback:
[ 356578] [C]: in function 'error'
[ 356594] citizen:/scripting/lua/MessagePack.lua:830: in method 'underflow'
[ 356610] citizen:/scripting/lua/MessagePack.lua:465: in field 'any'
[ 356610] citizen:/scripting/lua/MessagePack.lua:860: in field 'unpack'
[ 356625] citizen:/scripting/lua/scheduler.lua:338: in local 'cb'
[ 356641] server/player/login.lua:87: in upvalue 'handler'
[ 356656] citizen:/scripting/lua/scheduler.lua:124: in function <citizen:/scripting/lua/scheduler.lua:123>
[ 356656] stack traceback:
[ 356672] [C]: in function 'error'
[ 356688] citizen:/scripting/lua/scheduler.lua:39: in field 'CreateThreadNow'
[ 356703] citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
[ 356719] hitch warning: frame time of 288 milliseconds
[ 357281] Loaded System.Buffers, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51 into ScriptDomain_11282888
[ 357922] hitch warning: frame time of 689 milliseconds
[ 358078] [ERROR] [] An error happens on MySQL for query "SELECT * FROM users WHERE `identifier`=@identifier; {identifier=steam:11000010b8efe66}": Unknown column 'identifier' in 'where clause'
[ 494985] Sending heartbeat to live-internal.fivem.net:30110
[ 495172] hitch warning: frame time of 195 milliseconds
[ 665156] Error running call reference function for resource skin_customization: server.lua:12: attempt to index a nil value (local 'user')
[ 665344] stack traceback:
[ 665360] server.lua:12: in local 'ref'
[ 665375] citizen:/scripting/lua/scheduler.lua:277: in function <citizen:/scripting/lua/scheduler.lua:268>
[ 665391] [C]: in function 'coroutine.resume'
[ 665406] citizen:/scripting/lua/scheduler.lua:33: in field 'CreateThreadNow'
[ 665406] citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
[ 665453] Error running system event handling function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:39: Failed to execute thread: citizen:/scripting/lua/MessagePack.lua:830: missing bytes
[ 665469] stack traceback:
[ 665500] [C]: in function 'error'
[ 665500] citizen:/scripting/lua/MessagePack.lua:830: in method 'underflow'
[ 665531] citizen:/scripting/lua/MessagePack.lua:465: in field 'any'
[ 665547] citizen:/scripting/lua/MessagePack.lua:860: in field 'unpack'
[ 665563] citizen:/scripting/lua/scheduler.lua:338: in local 'cb'
[ 665563] server/player/login.lua:87: in upvalue 'handler'
[ 665578] citizen:/scripting/lua/scheduler.lua:124: in function <citizen:/scripting/lua/scheduler.lua:123>
[ 665594] stack traceback:
[ 665610] [C]: in function 'error'
[ 665625] citizen:/scripting/lua/scheduler.lua:39: in field 'CreateThreadNow'
[ 665641] citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
[ 665656] hitch warning: frame time of 515 milliseconds
[ 667563] Error running call reference function for resource skin_customization: server.lua:12: attempt to index a nil value (local 'user')
[ 667563] stack traceback:
[ 667578] server.lua:12: in local 'ref'
[ 667594] citizen:/scripting/lua/scheduler.lua:277: in function <citizen:/scripting/lua/scheduler.lua:268>
[ 667610] [C]: in function 'coroutine.resume'
[ 667625] citizen:/scripting/lua/scheduler.lua:33: in field 'CreateThreadNow'
[ 667641] citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
[ 667672] Error running system event handling function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:39: Failed to execute thread: citizen:/scripting/lua/MessagePack.lua:830: missing bytes
[ 667703] stack traceback:
[ 667719] [C]: in function 'error'
[ 667735] citizen:/scripting/lua/MessagePack.lua:830: in method 'underflow'
[ 667750] citizen:/scripting/lua/MessagePack.lua:465: in field 'any'
[ 667766] citizen:/scripting/lua/MessagePack.lua:860: in field 'unpack'
[ 667781] citizen:/scripting/lua/scheduler.lua:338: in local 'cb'
[ 667797] server/player/login.lua:87: in upvalue 'handler'
[ 667813] citizen:/scripting/lua/scheduler.lua:124: in function <citizen:/scripting/lua/scheduler.lua:123>
[ 667828] stack traceback:
[ 667844] [C]: in function 'error'
[ 667860] citizen:/scripting/lua/scheduler.lua:39: in field 'CreateThreadNow'
[ 667875] citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
[ 667891] hitch warning: frame time of 354 milliseconds
[ 674313] Error running call reference function for resource skin_customization: server.lua:12: attempt to index a nil value (local 'user')
[ 674328] stack traceback:
[ 674328] server.lua:12: in local 'ref'
[ 674344] citizen:/scripting/lua/scheduler.lua:277: in function <citizen:/scripting/lua/scheduler.lua:268>
[ 674375] [C]: in function 'coroutine.resume'
[ 674375] citizen:/scripting/lua/scheduler.lua:33: in field 'CreateThreadNow'
[ 674391] citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
[ 674453] Error running system event handling function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:39: Failed to execute thread: citizen:/scripting/lua/MessagePack.lua:830: missing bytes
[ 674453] stack traceback:
[ 674485] [C]: in function 'error'
[ 674500] citizen:/scripting/lua/MessagePack.lua:830: in method 'underflow'
[ 674516] citizen:/scripting/lua/MessagePack.lua:465: in field 'any'
[ 674531] citizen:/scripting/lua/MessagePack.lua:860: in field 'unpack'
[ 674547] citizen:/scripting/lua/scheduler.lua:338: in local 'cb'
[ 674563] server/player/login.lua:87: in upvalue 'handler'
[ 674578] citizen:/scripting/lua/scheduler.lua:124: in function <citizen:/scripting/lua/scheduler.lua:123>
[ 674594] stack traceback:
[ 674610] [C]: in function 'error'
[ 674625] citizen:/scripting/lua/scheduler.lua:39: in field 'CreateThreadNow'
[ 674641] citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
[ 674656] hitch warning: frame time of 367 milliseconds
[ 675188] Sending heartbeat to live-internal.fivem.net:30110
[ 679563] Error running call reference function for resource skin_customization: server.lua:12: attempt to index a nil value (local 'user')
[ 679578] stack traceback:
[ 679578] server.lua:12: in local 'ref'
[ 679594] citizen:/scripting/lua/scheduler.lua:277: in function <citizen:/scripting/lua/scheduler.lua:268>
[ 679610] [C]: in function 'coroutine.resume'
[ 679625] citizen:/scripting/lua/scheduler.lua:33: in field 'CreateThreadNow'
[ 679641] citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
[ 679688] Error running system event handling function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:39: Failed to execute thread: citizen:/scripting/lua/MessagePack.lua:830: missing bytes
[ 679703] stack traceback:
[ 679719] [C]: in function 'error'
[ 679735] citizen:/scripting/lua/MessagePack.lua:830: in method 'underflow'
[ 679750] citizen:/scripting/lua/MessagePack.lua:465: in field 'any'
[ 679766] citizen:/scripting/lua/MessagePack.lua:860: in field 'unpack'
[ 679781] citizen:/scripting/lua/scheduler.lua:338: in local 'cb'
[ 679813] server/player/login.lua:87: in upvalue 'handler'
[ 679828] citizen:/scripting/lua/scheduler.lua:124: in function <citizen:/scripting/lua/scheduler.lua:123>
[ 679844] stack traceback:
[ 679860] [C]: in function 'error'
[ 679875] citizen:/scripting/lua/scheduler.lua:39: in field 'CreateThreadNow'
[ 679891] citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
First Mysql-async MUST START BEFORE ESSENTIAL MODE NOT AFTER
Second Change set mysql_connection_string âserver=127.0.0.01;database=gta5_gamemode_essential;userid=root;password=rootâ to set mysql_connection_string âserver=localhost;database=essentialmode;userid=root;password=rootâ
the 127.0.0.01 should be switched to localhost or 127.0.0.1
If you copy paste the set mysql_connection from the readme it has a typo.
You might need to start the es_mysql resource as well
Are you getting a result printed from that print()?
What line in the code you posted in #20?
Iâm not sure, but the identifier variable might be causing issues since the sql query uses the same name. Try renaming that line to something like myIdentifier and try.
Nope, I got the same error. This is a pretty annoying error.
Try just doing if result[1] == nil then
. It might be bitching that result[1] is nil and be like âWhy dafuq u trying to find .identifierâ
Or is there any way to count results? I donât use this resource, so I donât know. Can you check if the rows returned == 0?
I have already tried result[1] == nil it still does the same error. I am not sure if I can do that but I will have to relook at the docs.
Try
if not result or not result[1] then TriggerEvent("xrp:createAccount", identifier, playerName) return end
TriggerClientEvent("chatMessage", -1, "Welcome " .. playerName .. " back to the server!")
I tried it but it didnât do anything.
I am trying to use the âesplugin_mysqlâ to work with essentialmode. I keep getting an error that says âError running system event handling function for resource esplugin_mysql: citizen:/scripting/lua/scheduler.lua:39: Failed to execute thread: citizen:/scripting/lua/scheduler.lua:394: No such export mysql_fetch_all in resource mysql-asyncâ
I am beginning posting here to see if any other people have this problem, and if so what the solution is.
Thanks,
Moonblaze