I already did, still not working. Or do I have to reset users cache aswell?
Does anyone know what hell this means?
[ERROR] [MySQL] An critical error happens on MySQL for query "SELECT * FROM item
s {=}": Object reference not set to an instance of an object. at MySqlConnecto
r.Core.ConnectionPool.GetPool (System.String connectionString) [0x0001a] in <149
068887d4e4bc08e7b4c05a59a923b>:0
at MySql.Data.MySqlClient.MySqlConnection.CreateSessionAsync (System.Nullable`
1[T] ioBehavior, System.Threading.CancellationToken cancellationToken) [0x00012]
in <149068887d4e4bc08e7b4c05a59a923b>:0
at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1+ConfiguredVa
lueTaskAwaiter[TResult].GetResult () [0x0001e] in <4ac30274d31c4b8099694c24336fc
b22>:0
at MySql.Data.MySqlClient.MySqlConnection.OpenAsync (System.Nullable`1[T] ioBe
havior, System.Threading.CancellationToken cancellationToken) [0x000bc] in <1490
68887d4e4bc08e7b4c05a59a923b>:0
at MySQLAsync.Operation`1[TResult].ExecuteAsync (System.String query, System.C
ollections.Generic.IDictionary`2[TKey,TValue] parameters, CitizenFX.Core.Callbac
kDelegate callback, System.Boolean debug) [0x000aa] in <6f835765886c4fada3e5ffb1
ffcd6998>:0
[ERROR] [MySQL] An critical error happens on MySQL for query "SELECT * FROM item
s {=}": Object reference not set to an instance of an object. at MySqlConnecto
r.Core.ConnectionPool.GetPool (System.String connectionString) [0x0001a] in <149
068887d4e4bc08e7b4c05a59a923b>:0
at MySql.Data.MySqlClient.MySqlConnection.CreateSessionAsync (System.Nullable`
1[T] ioBehavior, System.Threading.CancellationToken cancellationToken) [0x00012]
in <149068887d4e4bc08e7b4c05a59a923b>:0
at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1+ConfiguredVa
lueTaskAwaiter[TResult].GetResult () [0x0001e] in <4ac30274d31c4b8099694c24336fc
b22>:0
at MySql.Data.MySqlClient.MySqlConnection.OpenAsync (System.Nullable`1[T] ioBe
havior, System.Threading.CancellationToken cancellationToken) [0x000bc] in <1490
68887d4e4bc08e7b4c05a59a923b>:0
at MySQLAsync.Operation`1[TResult].ExecuteAsync (System.String query, System.C
ollections.Generic.IDictionary`2[TKey,TValue] parameters, CitizenFX.Core.Callbac
kDelegate callback, System.Boolean debug) [0x000aa] in <6f835765886c4fada3e5ffb1
On zap hosting says that this resource is :" MySql Async Version 2.1.1
if i downloaded and added it on top of other folder would it update it?
Cause here it says 3.1.0???
Error: (node:12132) UnhandledPromiseRejectionWarning: TypeError: logger.Error is not a function
at global.on (mysql-async.js:5142:14)
at citizen:/scripting/v8/main.js:204:28
Error: (node:12132) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
Error: (node:12132) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
Are you for real using win xp lol
That will be fixed next version, but that error appears when you do not have a proper connection string set.
See Installation in the readme.
I have finished, thank you
It looks nice, would it be possible to make slowest queries into a scroll bar rather than page by page so you can sort all at once?
it sorts all at once, it only displays some of the 21, you can navigate the table.
Update to 3.1.1
- Removed excessive error reporting.
- Removed
MySQL.Ready's reliance on events
1 Like
The interface should still show. I can fix the error though, but I will do so after investigating some other issues.
Hello everyone. Could anyone help me with this! I am an admin on a successful RP server and we are in the process of writing some new jobs and scenarios but I have a problem with my local test server. I am trying to setup a standard fx server with essential mode but I seem to have an issue getting the game talking to my database. I have followed so many guides and videos that I have well and truely confused myself I have a an error in the start up which I’m hoping will point you wizards to the problem
I am using xaamp to run the DB and have pulled across the table as per all the guides which all looks good. But every time I run the server it doesn’t appear to save any positions etc. My home screen is working and if I try and assign any permissions or money I get that same error as I do when I load the server. I appreciate any help given on this as I’v been trying solo for last few weeks.
so upon testing save for the server data base i get this error…
[ERROR] [MySQL] [mysql] An error happens on MySQL for query “INSERT INTO main (id, name, args) VALUES(‘steam:110000137344743’, ‘Skibidi’, ‘test’)”: Handshake inactivity timeout
and i dont know what it means or wants me to do. could anyone help me out?
dont know if its to do with when loading
if you know why or know something about it add my discord Eddie#4661
is it the first query or does it happen later?
this usually means you got some network configuration issues.
but, if it is not the first query, you could just add ;keepAlive=60 on the connection string. which would send keepAlive queries.
hey… im really trying to learn how to setup my sql and am at a disadvantage as i know nothing about it or its possible uses outside of a script im trying to use requires it. if anyone could dm me on discord and offer assistance in getting it setup and educating me on this type off script id greatly appreciate it. thanks all
Big Red#2182
Hi zr0iq. Not sure if the keep alive command was was for me or the other chap?
Has anyone seen these sort of numbers? I’ve had ex_extended go up to 40k+ ms with the most up to date version of async (with 20+ players). I was getting 90k+ ms with the previous async build.
I believe this leads to constant server hitch warnings with some going as much as 1000ms in the console. Any sort of insight would be helpful
Thanks in advance!