[Release] MySQL Async Library - 3.3.2

FiveM Resource Development & Modding Releases
, ,
982

i can check setting mysql like that worked for me. no more timeout error

1 Like
983

I did fix the issue on my side by doing this

set mysql_connection_string “server=0.0.0.0;database=.;userid=user;password=pwd;connectTimeout=20000;supportBigNumbers=true;acquireTimeout=20000”

1 Like
984

“Failed to load script @mysql-async/lib/MySQL.lua” any idea guys ?

1 Like
985

[ script:mysql-async] [MySQL] [WARNING] [esx_vehicleshop] [115ms] SELECT * FROM vehicles : []
[ script:mysql-async] [MySQL] [WARNING] [esx_addoninventory] [105ms] SELECT * FROM addon_inventory : []
[ script:mysql-async] [MySQL] [WARNING] [esx_addonaccount] [76ms] SELECT * FROM addon_account_data WHERE account_name = ? : [“caution”]
[ script:mysql-async] [MySQL] [WARNING] [esx_society] [105ms] SELECT * FROM job_grades : []
[ script:mysql-async] [MySQL] [WARNING] [es_extended] [161ms] SELECT * FROM job_grades : []
[ script:mysql-async] [MySQL] [WARNING] [esx_datastore] [112ms] SELECT * FROM datastore_data WHERE name = ? : [“society_ambulance”]
[ script:mysql-async] [MySQL] [WARNING] [esx_addoninventory] [64ms] SELECT * FROM addon_inventory_items WHERE inventory_name = ? : [“society_police”]
[ script:mysql-async] [MySQL] [WARNING] [esx_addonaccount] [54ms] SELECT * FROM addon_account_data WHERE account_name = ? : [“society_police”]
[ script:mysql-async] [MySQL] [WARNING] [esx_datastore] [56ms] SELECT * FROM datastore_data WHERE name = ? : [“user_ears”]

who can help

1 Like
986

These are warnings when you boot up the server most probably and you can ignore them.

1 Like
987

For those of you receiving warnings like those below add mysql_log_level 9 (This will only display errors in console) under your connection string like this:

set es_enableCustomData 1
set mysql_connection_string “server=xxxxxxxx;database=xxxxxxx;userid=xxxxxx;password=xxxxxx”
set mysql_log_level 9
endpoint_add_tcp “xxxx”
endpoint_add_udp “xxxxx”
start mapmanager
start chat
start spawnmanager
start sessionmanager
start fivem
start hardcap
ETC…

[ script:mysql-async] [MySQL] [WARNING] [esx_vehicleshop] [115ms] SELECT * FROM vehicles : []
[ script:mysql-async] [MySQL] [WARNING] [esx_addoninventory] [105ms] SELECT * FROM addon_inventory : []
[ script:mysql-async] [MySQL] [WARNING] [esx_addonaccount] [76ms] SELECT * FROM addon_account_data WHERE account_name = ? : [“caution”]
[ script:mysql-async] [MySQL] [WARNING] [esx_society] [105ms] SELECT * FROM job_grades : []
[ script:mysql-async] [MySQL] [WARNING] [es_extended] [161ms] SELECT * FROM job_grades : []
[ script:mysql-async] [MySQL] [WARNING] [esx_datastore] [112ms] SELECT * FROM datastore_data WHERE name = ? : [“society_ambulance”]
[ script:mysql-async] [MySQL] [WARNING] [esx_addoninventory] [64ms] SELECT * FROM addon_inventory_items WHERE inventory_name = ? : [“society_police”]
[ script:mysql-async] [MySQL] [WARNING] [esx_addonaccount] [54ms] SELECT * FROM addon_account_data WHERE account_name = ? : [“society_police”]
[ script:mysql-async] [MySQL] [WARNING] [esx_datastore] [56ms] SELECT * FROM datastore_data WHERE name = ? : [“user_ears”]

@Sayedadib08

988

Screenshot 2021-06-29 233146
Screenshot 2021-06-29 233146995×73 10.2 KB

i have done almot evrey thing still not working

989

i always getting this error

script error:es_extended:modules/core/player/server/module.lua:180: attempt to index a nil value (global ‘Async’)

is there any help i can get?

990

It’s work, thanks

991

Install async

993

any idea of how can a mysql-async query using a where clause on a primary key can tick a 128ms warning, but running the same query on the same db using heidi sql it runs in less than a 1ms?

994

@zr0iq Hey, are you planning on adding exports to this resource?
I am really wanting to use this script in my c# project, but dont want to switch to the older release of this script for the c# wrapper.
Right now I am using lua for the MySQL stuff, and everything else is in c#, But want everything to be c# based.

Is there a way to get this (latest) to work with c#?

995

If you want, I can try and set something like that up. I have been quite busy working on a lot of different projects, I will try my best to help out as best as I can.

996

Which MySQL server version is best for async?

997

That work for me