One player is not getting database entry

Scani01 · 2019-05-26T17:36:36.622Z

Hey,
our server is otherwise working normal. But if a specific player connects, let’s call him Jeff, in the console comes folowing errors:

Error: (node:30887) 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:30887) 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: 7)
Error: (node:30887) UnhandledPromiseRejectionWarning: Error: ER_NO_DEFAULT_FOR_FIELD: Field ‘pet’ doesn’t have a default value
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
at citizen:/scripting/v8/main.js:51:18
at setImmediate (mysql-async.js:4962:9)
at Object.callback (citizen:/scripting/v8/timer.js:56:6)
at onTick (citizen:/scripting/v8/timer.js:80:27)
Error: (node:30887) 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: 8)
Error: (node:30887) UnhandledPromiseRejectionWarning: TypeError: Cannot convert undefined or null to object
at Function.values ()
at execute.then (mysql-async.js:5002:48)
Error: (node:30887) 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: 9)

Its only if Jeff is connecting. For every other Player there is no problem.
I hope someone can help me.

Greetings,
Scani01

Heady20006 · 2019-05-26T19:05:11.571Z

Go to your database, go to users and Set a default value of the field ‘pet’. Set it to null

Scani01 · 2019-05-26T19:28:18.571Z

Heady20006:

Go to your database, go to users and Set a default value of the field ‘pet’. Set it to null

Thank you sooo much, i just searched hours for this. I dont know why i didnt saw this xD.

Tanks,
Scani01

zee · 2019-06-25T19:28:23.768Z

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