brouznouf / fivem-mysql-async

MySql Async Library for FiveM
MIT License
111 stars 106 forks source link

MY SQL Async wont connect. #184

Open TLBRP opened 3 years ago

TLBRP commented 3 years ago

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:

Additional context Add any other context about the problem here.

togesie commented 2 years ago

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 commented 2 years ago

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