Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MY SQL Async wont connect. #184

Open
TLBRP opened this issue Aug 19, 2021 · 2 comments
Open

MY SQL Async wont connect. #184

TLBRP opened this issue Aug 19, 2021 · 2 comments

Comments

@TLBRP
Copy link

TLBRP commented Aug 19, 2021

Describe the bug
[ script:mysql-async] [mysql-async] [ERROR] connect ETIMEDOUT
[script:esx_addonacco] SCRIPT ERROR: @esx_addonaccount/server/main.lua:6: attempt to get length of a nil value (local 'result')
[MySQL] [WARNING] [esx_addonaccount] [231ms] SELECT * FROM addon_account : []

To Reproduce
not sure what this means

Expected behavior
i expected my sql to connnect, not time out. I also expext my sql to find 'result' as its there.

Screenshots / Logs
[ script:mysql-async] [mysql-async] [ERROR] connect ETIMEDOUT
[ script:mysql-async] [mysql-async] [INFO] [es_extended] Stored [0] : UPDATE users SET accounts = ?, job = ?, job_grade = ?, group = ?, position = ?, inventory = ?, loadout = ? WHERE identifier = ?
[ script:mysql-async] [mysql-async] [INFO] [es_extended] Stored [1] : INSERT INTO users SET accounts = ?, identifier = ?, group = ?
[ script:mysql-async] [mysql-async] [INFO] [es_extended] Stored [2] : SELECT accounts, job, job_grade, group, position, inventory, skin, loadout, firstname, lastname, dateofbirth, sex, height FROM users WHERE identifier = ?
[ citizen-server-impl] server thread hitch warning: timer interval of 864 milliseconds
[ script:mysql-async] [mysql-async] [INFO] [es_extended] Stored [0] : UPDATE users SET accounts = ?, job = ?, job_grade = ?, group = ?, position = ?, inventory = ?, loadout = ? WHERE identifier = ?
[ script:mysql-async] [mysql-async] [INFO] [es_extended] Stored [1] : INSERT INTO users SET accounts = ?, identifier = ?, group = ?
[ script:mysql-async] [mysql-async] [INFO] [es_extended] Stored [2] : SELECT accounts, job, job_grade, group, position, inventory, skin, loadout, firstname, lastname, dateofbirth, sex, height FROM users WHERE identifier = ?
[ script:mysql-async] [MySQL] [WARNING] [esx_addonaccount] [231ms] SELECT * FROM addon_account : []
[ script:mysql-async] [MySQL] [WARNING] [esx_addoninventory] [226ms] SELECT * FROM items : []
[ script:mysql-async] [MySQL] [WARNING] [esx_datastore] [215ms] SELECT * FROM datastore : []
[ script:mysql-async] [MySQL] [WARNING] [esx_weaponshop] [199ms] SELECT * FROM weashops : []
[ script:mysql-async] [MySQL] [WARNING] [es_extended] [191ms] SELECT * FROM jobs : []
[ script:mysql-async] [MySQL] [WARNING] [es_extended] [195ms] SELECT * FROM items : []
[ script:mysql-async] [MySQL] [WARNING] [esx_boat] [223ms] UPDATE owned_vehicles SET stored = true WHERE stored = false AND type = ? : ["boat"]
[ script:mysql-async] [MySQL] [WARNING] [esx_vehicleshop] [234ms] SELECT * FROM vehicle_categories : []
[ citizen-server-impl] -- [server notice: tebex_not_set]
[ citizen-server-impl] ================
[ citizen-server-impl] Monetize your server using Tebex! Visit https://tebex.io/fivem for more info.
[ citizen-server-impl] ================
[ citizen-server-impl]
[ script:es_extended] [INFO] ESX Legacy initialized

Software:

  • OS: [e.g. Windows 10]
  • Version of the resource [e.g. 3.3]
  • Database Version [e.g. MariaDB 10.4 or MySQL 8.0]

Additional context
Add any other context about the problem here.

@TLBRP TLBRP assigned ghost Aug 19, 2021
@togesie
Copy link

togesie commented Sep 17, 2021

I think you haven't added the SQL database correctly, maybe retry to add your vehicle shop and boat shop database again. It seems to be missing information here thats why it cannot select the SQL database.

@togesie
Copy link

togesie commented Sep 17, 2021

There is also a script error making your database not connect on line 6 in your server main.lua...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants