Hello,
I’m trying to insert the resource “esx_policejob”
for a while.
on my last server, this worked without any problems but now I get the following error messages when starting the server.
Error 1 : ( - fixed- @ protaknium )
es_extended: TriggerServerCallback => [esx_policejob:isCop] does not exist
Error 2 :
Error resuming coroutine: server/main.lua:41: table index is nil
stack traceback:
server/main.lua:41: in local ‘cb’
@mysql-async/lib/MySQL.lua:204: in upvalue ‘handler’
citizen:/scripting/lua/scheduler.lua:219: in function citizen:/scripting/lua/scheduler.lua:218
Error resuming coroutine: citizen:/scripting/lua/json.lua:397: bad argument #1 to ‘strfind’ (string expected, got nil)
stack traceback:
[C]: in function ‘string.find’
citizen:/scripting/lua/json.lua:397: in upvalue ‘scanwhite’
citizen:/scripting/lua/json.lua:553: in function citizen:/scripting/lua/json.lua:551
(…tail calls…)
server/main.lua:45: in local ‘cb’
@mysql-async/lib/MySQL.lua:204: in upvalue ‘handler’
citizen:/scripting/lua/scheduler.lua:219: in function citizen:/scripting/lua/scheduler.lua:218
Error 3:
Error running system event handling function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:323: attempt to concatenate a table value (local ‘group’)
stack traceback:
server/main.lua:323: in function ‘addGroupCommand’
server/main.lua:354: in upvalue ‘handler’
citizen:/scripting/lua/scheduler.lua:219: in function citizen:/scripting/lua/scheduler.lua:218
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:41: in field ‘CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:218: in function citizen:/scripting/lua/scheduler.lua:182
Error 4: ( if i buy a police vehicle )
Error running call reference function for resource esx_property: citizen:/scripting/lua/scheduler.lua:403: server/main.lua:329: attempt to index a nil value (local ‘xPlayer’)
stack traceback:
server/main.lua:329: in upvalue ‘ref’
citizen:/scripting/lua/scheduler.lua:389: in function citizen:/scripting/lua/scheduler.lua:388
[C]: in function ‘xpcall’
citizen:/scripting/lua/scheduler.lua:388: in function citizen:/scripting/lua/scheduler.lua:387
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:403: in function citizen:/scripting/lua/scheduler.lua:372
Error running system event handling function for resource es_extended: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: citizen:/scripting/lua/MessagePack.lua:830: missing bytes
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/MessagePack.lua:830: in method ‘underflow’
citizen:/scripting/lua/MessagePack.lua:465: in field ‘any’
citizen:/scripting/lua/MessagePack.lua:860: in field ‘unpack’
citizen:/scripting/lua/scheduler.lua:626: in field ‘?’
server/functions.lua:33: in field ‘TriggerServerCallback’
server/common.lua:88: in upvalue ‘handler’
citizen:/scripting/lua/scheduler.lua:219: in function citizen:/scripting/lua/scheduler.lua:218
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:41: in field ‘CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:218: in function citizen:/scripting/lua/scheduler.lua:182
hitch warning: frame time of 436 milliseconds
esx_ambulancejob: steam:110000112e1f3db attempted combat logging!
esx_policejob: steam:110000112e1f3db attempted to exploit the shop! (invalid vehicle model)
[ERROR] [MySQL] [esx_policejob] An error happens on MySQL for query “[object Object]”: ER_BAD_FIELD_ERROR: Unknown column ‘type’ in ‘field list’
Error: (node:11884) UnhandledPromiseRejectionWarning: AssertionError [ERR_ASSERTION]: unexpected PromiseRejectEvent
at process. (internal/process/promises.js:27:25)
at
at Query.db.query [as _callback] (mysql-async.js:4973:13)
at Query.Sequence.end (mysql-async.js:280:24)
at Query.ErrorPacket (mysql-async.js:2122:8)
at Protocol._parsePacket (mysql-async.js:5941:23)
at Parser.write (mysql-async.js:6198:12)
at Protocol.write (mysql-async.js:5701:16)
at Socket. (mysql-async.js:693:28)
at emitOne (events.js:116:13)
Error: (node:11884) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
Error: (node:11884) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
Error: (node:11884) UnhandledPromiseRejectionWarning: Error: ER_BAD_FIELD_ERROR: Unknown column ‘type’ in ‘field list’
at Query.Sequence._packetToError (mysql-async.js:244:14)
at Query.ErrorPacket (mysql-async.js:2109:18)
at Protocol._parsePacket (mysql-async.js:5941:23)
at Parser.write (mysql-async.js:6198:12)
at Protocol.write (mysql-async.js:5701:16)
at Socket. (mysql-async.js:693:28)
at emitOne (events.js:116:13)
at Socket.emit (events.js:211:7)
at addChunk (_stream_readable.js:263:12)
at readableAddChunk (_stream_readable.js:250:11)
--------------------
at Pool.query (mysql-async.js:4728:23)
at Promise (mysql-async.js:4970:12)
at new Promise ()
at execute (mysql-async.js:4967:26)
at Object.global.exports [as callback] (mysql-async.js:4985:5)
at citizen:/scripting/v8/main.js:87:41
Error: (node:11884) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 2)
1
1
1
1
1
1
I have already tried reinstalling the FiveM server or reinstalling the scripts and database entries, but to no avail.
I used the manual of " @Sorrora ". Post : [Release] [ESX] [Police Job]
I can use the server as far as normal but without police.
I hope someone can help me to fix these errors.
If more information is needed please ask.
Server Running on Windows x64