After changing set es_enableCustomData from 1 to 0, I’m getting the error:
Unhandled task exception:
code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
no such table: players
at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, System.UInt32 timeoutMS, System.String& strRemain) [0x003e9] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x000f6] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at System.Data.SQLite.SQLiteCommand.GetStatement (System.Int32 index) [0x00008] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteCommand.GetStatement(int)
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00127] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x00090] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at System.Data.Common.DbCommand.ExecuteNonQueryAsync (System.Threading.CancellationToken cancellationToken) [0x00049] in <aec29233340943578097b360aec4b398>:0
--- End of stack trace from previous location where exception was thrown ---
at SQLite.Main+<>c__DisplayClass4_0.<DoesUserExist>b__0 () [0x00071] in <d9601824428540b9a7e0ba8d7ddf823e>:0
I’m not sure why this is happening… I’m using mysql-async latest version with ESX, Ubuntu 18 and MySQL database.
I honestly just realised what I did…
I was supposed to change sv_scriptHookAllowed from 1 to 0
But I got another issue though:
[ERROR] connect ETIMEDOUT
[ERROR] [MySQL] [esx_trunk] An error happens on MySQL for query "SELECT * FROM trunk_inventory": connect ETIMEDOUT
[ERROR] [MySQL] [esx_trunk] An error happens on MySQL for query "DELETE FROM `trunk_inventory` WHERE `owned` = 0": Handshake inactivity timeout
[ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query "SELECT * FROM vehicle_categories": Handshake inactivity timeout
[ERROR] [MySQL] [esx_jb_eden_garage2] An error happens on MySQL for query "UPDATE owned_vehicles SET state=true WHERE state=false": Handshake inactivity timeout
Error calling system tick function in resource mysql-async: AssertionError [ERR_ASSERTION]: unexpected PromiseRejectEvent
stack:
[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]
[ERROR] [MySQL] [esx_shops] An error happens on MySQL for query "SELECT * FROM shops LEFT JOIN items ON items.name = shops.item": Handshake inactivity timeout
[ERROR] [MySQL] [esx_weaponshop] An error happens on MySQL for query "SELECT * FROM weashops": Handshake inactivity timeout
[ERROR] [MySQL] [esx_addonaccount] An error happens on MySQL for query "SELECT * FROM addon_account": Handshake inactivity timeout
[ERROR] [MySQL] [esx_society] An error happens on MySQL for query "SELECT * FROM jobs": Handshake inactivity timeout
[ERROR] [MySQL] [esx_datastore] An error happens on MySQL for query "SELECT * FROM datastore": Handshake inactivity timeout
[ERROR] [MySQL] [esx_boatshop] An error happens on MySQL for query "SELECT * FROM boat_categories": ER_NO_SUCH_TABLE: Table 'essentialmode.boat_categories' doesn't exist
SCRIPT ERROR: @esx_trunk/server/trunk.lua:15: attempt to get length of a nil value (local 'result')
SCRIPT ERROR: @esx_shops/server/main.lua:8: attempt to get length of a nil value (local 'shopResult')
> ref (@esx_shops/server/main.lua:8)
> setImmediate (@mysql-async/mysql-async.js:14431)
SCRIPT ERROR: @esx_vehicleshop/server/main.lua:33: attempt to get length of a nil value (upvalue 'Categories')
> fn (@mysql-async/lib/MySQL.lua:197)
SCRIPT ERROR: @esx_addonaccount/server/main.lua:11: attempt to get length of a nil value (local 'result')
> fn (@mysql-async/lib/MySQL.lua:197)
SCRIPT ERROR: @esx_society/server/main.lua:18: attempt to get length of a nil value (local 'result')
> fn (@mysql-async/lib/MySQL.lua:197)
SCRIPT ERROR: @esx_datastore/server/main.lua:11: attempt to get length of a nil value (local 'result')
> fn (@mysql-async/lib/MySQL.lua:197)
