[Release] MySQL Async Library - 3.3.2

FiveM Releases
, ,
746

Having this error
Capture
Can anyone help ?

747

uhh, that is on me. lemme check. it should be logger.error. Might be a typo.

edit: your connection string was discovered to be empty.

748

Connection string?

749
750

I got rid of it and it posted this Capture

751

it did not connect to your local mysql server. Maybe you should configure a proper user with username and password and set it properly in the mysql connection string?

752

Got it working thanks

753

Hello,
i have a problem. I download directory from github and put in the recources and name “mysql”.
My __resource.lua:

resource_manifest_version '44febabe-d386-4d18-afbe-5e627f4af937'

version '3.1.0'

server_scripts {
	'mysql-async.js',
	'example.lua' --for testing
}
client_script 'mysql-async-client.js'

files {
  'ui/index.html',
  'ui/app.js',
  'ui/app.css',
  'ui/fonts/fira-sans-v9-latin-700.woff',
  'ui/fonts/fira-sans-v9-latin-700.woff2',
  'ui/fonts/fira-sans-v9-latin-italic.woff',
  'ui/fonts/fira-sans-v9-latin-italic.woff2',
  'ui/fonts/fira-sans-v9-latin-regular.woff',
  'ui/fonts/fira-sans-v9-latin-regular.woff2',
  'ui/fonts/MaterialIcons-Regular.eot',
  'ui/fonts/MaterialIcons-Regular.ttf',
  'ui/fonts/MaterialIcons-Regular.woff',
  'ui/fonts/MaterialIcons-Regular.woff2',
}

ui_page 'ui/index.html'

and error:

Error loading script example.lua in resource mysql: @mysql/example.lua:30: attempt to index a nil value (global 'MySQL')
stack traceback:
        @mysql/example.lua:30: in main chunk
Failed to load script example.lua.

Thanks for any help

754

You are not loading the file from lib.

Please refer to the first section in the readme.

1 Like
755

Thank you i miss this :slight_smile:

756

Hi guys i need your help please
i have this error

ddd
ddd979×512 15.7 KB

What is this ???

757

Is this script using more serwer ram memory now? After i updated to last release my serwer uses like 4 gb ram.

758

Which server version are you using?

759

1141 …

760

How to fix this when people join this error come out player can’t join server

image
image1339×484 15.6 KB

761

@JaroSound on which OS are you running your server? I did not experience any of those issues, so I put it to production.
@R_Jacobs make sure mysql-async is loaded first, clear cache if the issue persists.

762

Debian GNU/Linux 9.9 (stretch)

763

Is there anything new about the exports error of the last posts? I got the same error. Im using mysql-async 3.1 (tried with 3.0 aswell), updated EssentialMode and esplugin_mysql. Nothing worked.

764

error
error1542×845 192 KB

v: 3.1.0
os: debian 9
mariadb 10.3

765

@ZerefGG the row is not able to contain that much data as oyu want to put in. This is not the connectors fault. Contact the resource author.

@JaroSound I’ll look into it when I got time, because in my linux dockers the mem usage is stable. If you want a quick fix, you will need to compile it yourself with mysql 2.15.1 which was stable before. The profiler bins data, so it should use less than 1MB of data.

@NutellaBoii try and clear your servers cache.