[Release] MySQL Async Library - 3.3.2

S38STER · 2018-11-11T12:32:09.616Z

Where is problem? ???

zr0iq · 2018-11-12T08:46:50.285Z

your server version.

FortuN · 2018-11-12T23:05:33.651Z

Is there any way to check my CURRENT version of server (using zaphost) so that i can see if that could be the problem if its old so i just can upgrade?

SpecialX · 2018-11-14T13:29:59.676Z

[MySQL] [Slow Query Warning] [esx_eden_garage] [85ms] SELECT * FROM owned_vehicl
es WHERE owner=‘steam:110000113a7xxxx’
[MySQL] [Slow Query Warning] [esx_eden_garage] [56ms] SELECT * FROM owned_vehicl
es WHERE owner=‘steam:110000113a7xxxx’

Capture1298×395 25.4 KB

S38STER · 2018-11-17T08:31:39.566Z

AddEventHandler('playerConnecting', function(playerName, setKickReason)
	local pName = GetPlayerName(source)
	print(pName)
	MySQL.Async.fetchAll("SELECT * FROM `needrp_postacie` WHERE `p_name` = @pName",
	{
		['@pName'] = pName
	},
		function(result)
		print(#result)
		if result then
			print('Nie Znaleziono gracza')
		else
			print('Znaleziono gracza')
		end
    end)
end)

How to correctly check if the player’s account is in the database?

89537kay · 2018-11-18T02:27:08.006Z

@zr0iq Can you have a look at this for me?

MySQL aSync & Functions Discussion

I have a client event, that triggers a server event every 15 seconds. It’s basically to check if a database entry is different, and if it is, show a notifcation - My code looks like this: RegisterServerEvent("cadUpdate") AddEventHandler("cadUpdate", function(CAD) identifiers = GetPlayerIdentifiers( source ) MySQL.ready(function () MySQL.Async.fetchAll('SELECT * FROM units WHERE steamid = @SteamID', { ['@SteamID'] = identifiers[1] }, function(unitinfo) if (unitinfo[1…

milo2491 · 2018-11-18T03:32:17.560Z

mysql-async.js error on server boot

Error: (node:19044) UnhandledPromiseRejectionWarning: Error: No valid connection string found
at parseConnectingString (mysql-async.js:5036:18)
at global.on (mysql-async.js:5043:18)
at citizen:/scripting/v8/main.js:193:28
Error: (node:19044) 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:19044) [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.

need help to fix error
thank you
milo

Beardlife · 2018-11-18T16:36:59.799Z

I’m also having this isseu. Tried to downgrade to version 3.0.2 and see if that fixes it. Happens when there are more than 10-15 players online.

Even with the older version this starts to happen after 30 minutes. Must be some resource doing it.

milo2491 · 2018-11-18T17:01:33.324Z

this is on server boot no when playing

gamziboi · 2018-11-19T21:36:58.395Z

whenever I upgrade to the newest mysql-async (3.0.8) my server freezes of commands and all that. It only happens when players starts joining, any advices? running on newest es_extended

zr0iq · 2018-11-20T13:36:45.069Z

Which server version are you on?

gamziboi · 2018-11-20T14:21:32.493Z

Currently I’m on 2.1.1.0

zr0iq · 2018-11-20T22:07:19.947Z

Server version. The artifacts, not mysql-async.

Beardlife · 2018-11-20T22:31:21.377Z

I was using the latest version when this was happening. I’m now reinstalling again all the scripts and will try this one more time >.<

milo2491 · 2018-11-21T04:11:49.240Z

i fix the error.
i was using this in the server config
set mysql_connection_string “addr=127.0.0.1;uid=username;database=essentialmode;pwd=password”

and i changed to this code and all worked
set mysql_connection_string “server=127.0.0.1;database=essentialmode;userid=username;password=password”

gamziboi · 2018-11-21T11:18:29.617Z

oh well, I’m on an old version of mysql-async. Doesn’t really say.

image720×260 7.94 KB

Ogge0101 · 2018-11-25T13:36:41.889Z

Hey everyfing worked find when i installed the basics for ESX but first start up and i got this error anybody that can help me?

help1901×1029 31.8 KB

zr0iq · 2018-11-27T17:12:20.439Z

@Ogge0101 use localhost in the connection string.
@gamziboi server version, but I think you use according to some other topic zap anyways?
@Beardlife you need to give some more information than, I got issue x,y,z? Maybe update your artifacts version.

HalCroves · 2018-12-02T19:23:13.684Z

Hi @zr0iq
First of all thank you for the work done on this version!

However, on my test server, i have a [MySQL] [Slow Query Warning].

[MySQL] [Slow Query Warning] [esplugin_mysql] [842ms] UPDATE users SET `bank`=229643,`money`=2150 WHERE `identifier`='steam:xxxxxxxxxxxxxxx'
[MySQL] [Slow Query Warning] [esplugin_mysql] [1106ms] UPDATE users SET `bank`=23703,`money`=119045 WHERE `identifier`='steam:steam:xxxxxxxxxxxxxxx'

~ 520 users.

Simple question :
These are just warnings ? And to avoid this, we should review the MysQl requests ?

I have the last artefact version for linux and the last version of your mysql-async.
Version of mysql : Server version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6

Cordially,
Hal.

zr0iq · 2018-12-03T16:44:02.946Z

You should add an index over identifier.