1

i need a help.I was test to upload my server on zap hosting but i have many trouble because my db error in the console.I give u the pict.

ade
ade643×546 48.2 KB

i have many trouble look like this.The Error its not always in the same place.Yesterday i have trouble same to on the garage.I dont know how to fix it.Please help me

this is the list of error on my console

[MySQL] [Slow Query Warning] [esx_datastore] [1048ms] SELECT * FROM datastore
[ERROR] [MySQL] [esx_datastore] An error happens on MySQL for query “[object Object]”: connect ECONNREFUSED 127.0.0.1:3306
[MySQL] [Slow Query Warning] [esx_vehicleshop] [1038ms] SELECT * FROM vehicle_categories
[ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query “[object Object]”: connect ECONNREFUSED 127.0.0.1:3306
Error: (node:254288) UnhandledPromiseRejectionWarning: Error: connect ECONNREFUSED 127.0.0.1:3306
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)

at Protocol._enqueue (mysql-async.js:5807:48)
at Protocol.handshake (mysql-async.js:5714:23)
at PoolConnection.connect (mysql-async.js:720:18)
at Pool.getConnection (mysql-async.js:4577:16)
at Pool.query (mysql-async.js:4731:8)
at Promise (mysql-async.js:4970:12)
at new Promise (<anonymous>)
at execute (mysql-async.js:4967:26)
at Object.global.exports [as callback] (mysql-async.js:4993:5)
at citizen:/scripting/v8/main.js:96:41
Error: (node:254288) 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:254288) UnhandledPromiseRejectionWarning: AssertionError [ERR_ASSERTION]: unexpected PromiseRejectEvent
at process.<anonymous> (internal/process/promises.js:27:25)
at <anonymous>
at Query.db.query [as _callback] (mysql-async.js:4973:13)
at Query.Sequence.end (mysql-async.js:280:24)
at mysql-async.js:4734:13
at Handshake.onConnect [as _callback] (mysql-async.js:4587:9)
at Handshake.Sequence.end (mysql-async.js:280:24)
at Protocol.handleNetworkError (mysql-async.js:6025:14)
at PoolConnection.Connection._handleNetworkError (mysql-async.js:1018:18)
at emitOne (events.js:116:13)
Error: (node:254288) 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)
Error: (node:254288) UnhandledPromiseRejectionWarning: Error: connect ECONNREFUSED 127.0.0.1:3306
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)

at Protocol._enqueue (mysql-async.js:5807:48)
at Protocol.handshake (mysql-async.js:5714:23)
at PoolConnection.connect (mysql-async.js:720:18)
at Pool.getConnection (mysql-async.js:4577:16)
at Pool.query (mysql-async.js:4731:8)
at Promise (mysql-async.js:4970:12)
at new Promise (<anonymous>)
at execute (mysql-async.js:4967:26)
at Object.global.exports [as callback] (mysql-async.js:4993:5)
at citizen:/scripting/v8/main.js:96:41
Error: (node:254288) 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: 10)
[MySQL] [Slow Query Warning] [es_extended] [1065ms] SELECT * FROM items
[ERROR] [MySQL] [es_extended] An error happens on MySQL for query “[object Object]”: connect ECONNREFUSED 127.0.0.1:3306
[MySQL] [Slow Query Warning] [esx_weaponshop] [1038ms] SELECT * FROM weashops
[ERROR] [MySQL] [esx_weaponshop] An error happens on MySQL for query “[object Object]”: connect ECONNREFUSED 127.0.0.1:3306
Error: (node:254288) UnhandledPromiseRejectionWarning: Error: connect ECONNREFUSED 127.0.0.1:3306
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)

at Protocol._enqueue (mysql-async.js:5807:48)
at Protocol.handshake (mysql-async.js:5714:23)
at PoolConnection.connect (mysql-async.js:720:18)
at Pool.getConnection (mysql-async.js:4577:16)
at Pool.query (mysql-async.js:4731:8)
at Promise (mysql-async.js:4970:12)
at new Promise (<anonymous>)
at execute (mysql-async.js:4967:26)
at Object.global.exports [as callback] (mysql-async.js:4993:5)
at citizen:/scripting/v8/main.js:96:41
Error: (node:254288) 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: 11)
Error: (node:254288) UnhandledPromiseRejectionWarning: AssertionError [ERR_ASSERTION]: unexpected PromiseRejectEvent
at process.<anonymous> (internal/process/promises.js:27:25)
at <anonymous>
at Query.db.query [as _callback] (mysql-async.js:4973:13)
at Query.Sequence.end (mysql-async.js:280:24)
at mysql-async.js:4734:13
at Handshake.onConnect [as _callback] (mysql-async.js:4587:9)
at Handshake.Sequence.end (mysql-async.js:280:24)
at Protocol.handleNetworkError (mysql-async.js:6025:14)
at PoolConnection.Connection._handleNetworkError (mysql-async.js:1018:18)
at emitOne (events.js:116:13)
Error: (node:254288) 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: 12)
Error: (node:254288) UnhandledPromiseRejectionWarning: Error: connect ECONNREFUSED 127.0.0.1:3306
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)

at Protocol._enqueue (mysql-async.js:5807:48)
at Protocol.handshake (mysql-async.js:5714:23)
at PoolConnection.connect (mysql-async.js:720:18)
at Pool.getConnection (mysql-async.js:4577:16)
at Pool.query (mysql-async.js:4731:8)
at Promise (mysql-async.js:4970:12)
at new Promise (<anonymous>)
at execute (mysql-async.js:4967:26)
at Object.global.exports [as callback] (mysql-async.js:4993:5)
at citizen:/scripting/v8/main.js:96:41
Error: (node:254288) 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: 13)
[MySQL] [Slow Query Warning] [esx_addoninventory] [1059ms] SELECT * FROM items
[ERROR] [MySQL] [esx_addoninventory] An error happens on MySQL for query “[object Object]”: connect ECONNREFUSED 127.0.0.1:3306
Error: (node:254288) UnhandledPromiseRejectionWarning: Error: connect ECONNREFUSED 127.0.0.1:3306
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)

Not all of my erro.Please help me guys!

2

Looks like you entered the wrong database credentials. If i remember you have to create a database at Zap and enther those credentials

3

if we change the database its just in server.cfg right? no more place right?

4

On zap’s website

Yesterday morning we had a failure of a database cluster for gameservers.
Unfortunately, game servers with installed games that require an external database connection were not available during this time.
A rebuild of the cluster could be successfully completed today at around 08:30 (UTC +1).
Important: Please restart your gameserver so a new DB connection can be established.
We apologize for the long time until the cluster was restored
Visit our support team and we will credit your game server 5 days as compensation.
Best regards,
your ZAP team!

5

I still have problems with the connection but the server works as well but as I have 32 players throughout the day, it disconnects the database on a live server for 30 seconds …

e[91mError: (node:27121) 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: 245)e[0m
e[91mError: (node:27121) UnhandledPromiseRejectionWarning: Error: ER_BAD_NULL_ERROR: Column ‘identifier’ cannot be null
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)

6

has this happened again today?? i seem to have this issue