[Release] MySQL Async Library - 3.3.2

Titch2000 · September 1, 2017, 4:41pm

Hi, i am getting an issue with :

I have got MySQL working with other scripts using all the same ways just different databases and things like that i have also done the following in my __resource file:

But i still continue to get the error here is the cause at line 42 but i cannot see the issue:

Thanks for any help you can give.

Deveraux · September 2, 2017, 3:01pm

Can anyone help, I get the following error:

> [     91843] [ERROR] [mysql-async] An critical error happens on MySQL for query "INSERT INTO users (`identifier`, `money`, `bank`, `group`, `permission_level`, `license`) VALUES (@identifier, @money, @bank, @group, @permission_level, @license); {money=0;identifier=steam:11000010ab482fd;permission_level=0;license=0;bank=CitizenFX.Core.CallbackDelegate;group=user}": Parameter type CallbackDelegate (DbType: AnsiString) not currently supported. Value: CitizenFX.Core.CallbackDelegate   at MySql.Data.MySqlClient.MySqlParameter.AppendSqlString (System.IO.BinaryWriter writer, MySql.Data.MySqlClient.StatementPreparerOptions options) [0x00578] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0 
>  
> [     91859]   at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlParameter:AppendSqlString (System.IO.BinaryWriter,MySql.Data.MySqlClient.StatementPreparerOptions)
>  
> [     91875]   at MySql.Data.MySqlClient.MySqlStatementPreparer+ParameterSqlParser.DoAppendParameter (System.Int32 parameterIndex, System.Int32 textIndex, System.Int32 textLength) [0x00079] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0 
>  
> [     91890]   at MySql.Data.MySqlClient.MySqlStatementPreparer+ParameterSqlParser.OnNamedParameter (System.Int32 index, System.Int32 length) [0x00029] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0 
>  
> [     91906]   at MySql.Data.MySqlClient.MySqlParser.Parse (System.String sql) [0x001be] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0 
>  
> [     91921]   at MySql.Data.MySqlClient.MySqlStatementPreparer.ParseAndBindParameters () [0x0003a] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0 
>  
> [     91921]   at MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor.CreateQueryPayload (System.String commandText, MySql.Data.MySqlClient.MySqlParameterCollection parameterCollection) [0x00056] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0 
>  
> [     91937]   at MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor+<ExecuteReaderAsync>d__3.MoveNext () [0x0001d] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0 
>  
> [     91968] --- End of stack trace from previous location where exception was thrown ---
>  
> [     91984]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 
>  
> [     92000]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 
>  
> [     92015]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 
>  
> [     92031]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 
>  
> [     92062]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 
>  
> [     92078]   at MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor+<ExecuteNonQueryAsync>d__1.MoveNext () [0x00094] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0 
>  
> [     92093] --- End of stack trace from previous location where exception was thrown ---
>  
> [     92109]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 
>  
> [     92125]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 
>  
> [     92140]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 
>  
> [     92156]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 
>  
> [     92171]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 
>  
> [     92187]   at MySQLAsync.Operation`1+<ExecuteAsync>d__3[TResult].MoveNext () [0x00171] in <47c31aecc66e42ceb969da352f30fd4c>:0 
> [     92203] hitch warning: frame time of 631 milliseconds

Brouznouf · September 2, 2017, 3:02pm

you put a function in your parameters

Deveraux · September 2, 2017, 3:42pm

Sorry what do you mean? I’m still relatively new at this. Cheers for the reply though!

Brouznouf · September 2, 2017, 4:19pm

Show the code that give this error, will tell you why then

Deveraux · September 2, 2017, 4:26pm

I wish I knew, I’ve just setup mysql async and as soon as I log into the Server this pops up.

Deveraux · September 2, 2017, 4:34pm

I’m off to bed, literally been at this for 11 hours - If you have any suggestions how to fix them please post and ill try in the morning. Thanks for replying already anyway! Your a champion.

Brouznouf · September 3, 2017, 12:18pm

New Expiremental API for mysql-async only available since build 363 of fivem, this API, will be the official and recommended way in future

https://github.com/brouznouf/fivem-mysql-async/tree/feature/promise-await

New api using coroutine to have a sync feeling while still being async : local result = MySQL.[execute|fetchScalar|fetchAll|insert](query, params) which is possible due to the Citizen.Await function which allow to wait in an asynchronous way promises.

    -- Not blocking the main thread, but block current execution context
    print(MySQL.fetchScalar('SELECT NOW() as world'))

All async functions now returns a promise which can be chained by using the next method

-- Promise api
local p = MySQL.Async.fetchScalar("SELECT 1")
p:next(function (result)
    print(result)

    return "test"
end):next(function (result)
    print(result)

    error 'An error'
end):next(nil, function(err)
    print(err)

    return ""
end)

-- Synchronisation
promise.all({
    MySQL.Async.execute('SELECT SLEEP(1)'),
    MySQL.Async.fetchScalar('SELECT "test"'),
}):next(function (results)
    print(json.encode(results))
end)

ferrum · September 3, 2017, 12:27pm

did you forget to call Await in the first sample or do you provide it in your wrapper?

Brouznouf · September 3, 2017, 12:32pm

It’s provide in the wrapper :

MySQL.x : Async + Await (non blocking io)
MySQL.Async.x : Async (return promise)
MySQL.Sync.x : blocking api (faster in many cases as there is no async / thread overhead, but blocking)

steven_dev · September 8, 2017, 5:08am

im have one error fetchScalar with last build mysql-async

https://gyazo.com/8fa9ee7bf3fa159f209b6d5ad1be645c

cause this error is no result with request not return nil

Brouznouf · September 8, 2017, 8:53am

Look at the changelog it was fixed in the last version, simply update your mod

steven_dev · September 8, 2017, 4:41pm

i’m have error after update with fetchScalar

[ERROR] [MySQL] An critical error happens on MySQL for query "SELECT name FROM inventory WHERE owner = "license:e7d37d444efb3b10fa535b0dbbc7d2bc80f9c0fe" {=}": Object reference not set to an instance of an object.   at MySQLAsync.FetchScalar.Reader (MySql.Data.MySqlClient.MySqlCommand command) [0x00007] in <4566d747b17a449f9901d640a8efcabd>:0
  at MySQLAsync.Operation`1[TResult].Execute (System.String query, System.Collections.Generic.IDictionary`2[TKey,TValue] parameters, System.Boolean debug) [0x0004c] in <4566d747b17a449f9901d640a8efcabd>:0
[ERROR] [MySQL] An critical error happens on MySQL for query "SELECT name FROM inventory WHERE owner = "license:e7d37d444efb3b10fa535b0dbbc7d2bc80f9c0fe" {=}": Object reference not set to an instance of an object.   at MySQLAsync.FetchScalar.Reader (MySql.Data.MySqlClient.MySqlCommand command) [0x00007] in <4566d747b17a449f9901d640a8efcabd>:0
  at MySQLAsync.Operation`1[TResult].Execute (System.String query, System.Collections.Generic.IDictionary`2[TKey,TValue] parameters, System.Boolean debug) [0x0004c] in <4566d747b17a449f9901d640a8efcabd>:0
nil

my request

 MySQL.Sync.fetchScalar('SELECT name FROM inventory WHERE owner = "license:e7d37d444efb3b10fa535b0dbbc7d2bc80f9c0fe"',{}, function(rowsChanged)
      print(rowsChanged)
    end)

    local countPlayer = MySQL.Sync.fetchScalar('SELECT name FROM inventory WHERE owner = "license:e7d37d444efb3b10fa535b0dbbc7d2bc80f9c0fe"')

Warxander · September 8, 2017, 7:30pm

Having the same error too.

steven_dev · September 10, 2017, 9:28am

please repair im need fetchScalar with api promise …

10 YEAR LATER … no update

Brouznouf · September 11, 2017, 11:25am

Then don’t use this library or fix it yourself, i’m not at your service.

Brouznouf · September 11, 2017, 11:26am

2.0.2 released should resolve the null bug and avoid fatal error (see 2.0.1)

steven_dev · September 11, 2017, 11:36am

nice sorry im not patient thx for fix you have a best plugin

steven_dev · September 11, 2017, 11:27pm

to execute thread: ui_srv.lua:63: attempt to call a nil value (field 'fetchScalar')
stack traceback:
        ui_srv.lua:63: in upvalue 'handler'
        citizen:/scripting/lua/scheduler.lua:163: in function <citizen:/scripting/lua/scheduler.lua:162>
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:41: in field 'CreateThreadNow'
        citizen:/scripting/lua/scheduler.lua:162: in function <citizen:/scripting/lua/scheduler.lua:131>

not work after update i’m change with Sync for fix temporarily

Brouznouf · September 12, 2017, 10:16pm

This is in the experimental branch on github only, will do a 2.1.0 when i will have time to better test this myself