Citizen Scripting error?

FiveM Resource Development & Modding Discussion
1

I installed essentialmode through mysql and it linked through mysqlconnector but now I am getting a error.

[    101641] Sending heartbeat to live-internal.fivem.net:30110
[    144797] Loaded System.Threading.Tasks.Extensions, Version=4.1.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51 into ScriptDomain_728320624
[    144875] hitch warning: frame time of 158 milliseconds
[    145047] [ERROR] [MySQL] An error happens on MySQL for query "SELECT * FROM users WHERE `identifier`=@identifier; {identifier=steam:11000010b40980d}": Unable to connect to any of the specified MySQL hosts.
[    148453] Error running call reference function for resource es_admin2: server.lua:310: attempt to index a nil value (local 'user')
[    148469] stack traceback:
[    148485] 	server.lua:310: in local 'ref'
[    148516] 	citizen:/scripting/lua/scheduler.lua:317: in function <citizen:/scripting/lua/scheduler.lua:308>
[    148563] Error running call reference function for resource essentialmode: citizen:/scripting/lua/MessagePack.lua:830: missing bytes
[    148578] stack traceback:
[    148594] 	[C]: in function 'error'
[    148610] 	citizen:/scripting/lua/MessagePack.lua:830: in method 'underflow'
[    148625] 	citizen:/scripting/lua/MessagePack.lua:465: in field 'any'
[    148641] 	citizen:/scripting/lua/MessagePack.lua:860: in field 'unpack'
[    148657] 	citizen:/scripting/lua/scheduler.lua:378: in upvalue 'callback'
[    148672] 	server/main.lua:154: in local 'ref'
[    148688] 	citizen:/scripting/lua/scheduler.lua:317: in function <citizen:/scripting/lua/scheduler.lua:308>
[    148703] hitch warning: frame time of 287 milliseconds
[    281703] Sending heartbeat to live-internal.fivem.net:30110
[    461766] Sending heartbeat to live-internal.fivem.net:30110
2

Hello.

The error is associated with MySQL directly. Unable to connect to any of the specified MySQL hosts could mean a few things. You’ve either: Installed MySQL server incorrectly, did not specify correct convars or specified wrong username/password in the convar located in server.cfg. Check your server.cfg and make sure your host, username and password is correct. Make sure you are also loading all of the needed resources in the recommended order.

If that does not work, then you may be using the latest EssentialMode5.x, which I believe doesn’t support MySQL by the looks of it? https://goo.gl/rVqkBN
Someone correct me if I am wrong anyways :stuck_out_tongue:

3

I am using the latest version of essentialmode what version should I use?

4

As it seems that ES5 doesn’t seem to support MySQL, you are better off using Couchdb or making it compatible. You’re better off asking on the essentialmode topic thread

5

Moved to Development Discussion boards.

6

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.