[Release] MySQL Async Library - 3.3.2

ChristopherM · August 16, 2019, 6:22am

Which resource contains the loadWhiteList function? That looks like it is causing the problem.

1111666 · August 16, 2019, 2:45pm

Error resuming coroutine: server/main.lua:7: attempt to index a nil value (global ‘MySQL’)
stack traceback:
server/main.lua:7: in function ‘loadWhiteList’
server/main.lua:28: in function <server/main.lua:24>

What the Eror, help please

ChristopherM · August 16, 2019, 2:47pm

I am trying to help, but you need to provide more information. What resource calls loadWhiteList?

d3was · August 16, 2019, 8:46pm

2500 ID’s then i got this
this is my 3rd time restarting my data

ChristopherM · August 17, 2019, 12:10am

2500 IDs in your DB? Also, what data are you resetting?

d3was · August 17, 2019, 4:12am

i rest the data to 0 ID’s , then if i reach 2500 i got this error

DocWeird · August 25, 2019, 7:30pm

same here… i have almost 4500 and i got this error when i restart the server and i have to restart a couple of times till i get “the right one”

[vRP/C#] query exception vRP/init_user_identity : System.AggregateException: One or more errors occurred. (Parameter '@registration' must be defined. To use this as a variable, set 'Allow User Variables=true' in the connection string.) ---> MySql.Data.MySqlClient.MySqlException: Parameter '@registration' must be defined. To use this as a variable, set 'Allow User Variables=true' in the connection string.
  at MySql.Data.MySqlClient.MySqlStatementPreparer+ParameterSqlParser.OnNamedParameter (System.Int32 index, System.Int32 length) [0x0005b] in <c9032194188746cfa5d8bb7625c7912b>:0
  at MySql.Data.MySqlClient.MySqlParser.Parse (System.String sql) [0x001be] in <c9032194188746cfa5d8bb7625c7912b>:0
  at MySql.Data.MySqlClient.MySqlStatementPreparer.ParseAndBindParameters () [0x0003a] in <c9032194188746cfa5d8bb7625c7912b>:0
  at MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor.ExecuteReaderAsync (System.String commandText, MySql.Data.MySqlClient.MySqlParameterCollection parameterCollection, System.Data.CommandBehavior behavior, MySql.Data.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x000c6] in <c9032194188746cfa5d8bb7625c7912b>:0
  at MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor.ExecuteNonQueryAsync (System.String commandText, MySql.Data.MySqlClient.MySqlParameterCollection parameterCollection, MySql.Data.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x00094] in <c9032194188746cfa5d8bb7625c7912b>:0
  at vRP.MySQL+<>c__DisplayClass11_2.<e_query>b__0 () [0x0022c] in <8dfc0861f4df44189d833de5e878b97b>:0
   Exception_EndOfInnerExceptionStack
---> (Inner Exception #0) MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '@registration' must be defined. To use this as a variable, set 'Allow User Variables=true' in the connection string.
  at MySql.Data.MySqlClient.MySqlStatementPreparer+ParameterSqlParser.OnNamedParameter (System.Int32 index, System.Int32 length) [0x0005b] in <c9032194188746cfa5d8bb7625c7912b>:0
  at MySql.Data.MySqlClient.MySqlParser.Parse (System.String sql) [0x001be] in <c9032194188746cfa5d8bb7625c7912b>:0
  at MySql.Data.MySqlClient.MySqlStatementPreparer.ParseAndBindParameters () [0x0003a] in <c9032194188746cfa5d8bb7625c7912b>:0
  at MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor.ExecuteReaderAsync (System.String commandText, MySql.Data.MySqlClient.MySqlParameterCollection parameterCollection, System.Data.CommandBehavior behavior, MySql.Data.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x000c6] in <c9032194188746cfa5d8bb7625c7912b>:0
  at MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor.ExecuteNonQueryAsync (System.String commandText, MySql.Data.MySqlClient.MySqlParameterCollection parameterCollection, MySql.Data.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x00094] in <c9032194188746cfa5d8bb7625c7912b>:0
  at vRP.MySQL+<>c__DisplayClass11_2.<e_query>b__0 () [0x0022c] in <8dfc0861f4df44189d833de5e878b97b>:0 <---

[vRP] task 3462 failed.
[vRP] task 3462 failed.
[vRP] task 3462 failed.
[vRP] task 3462 failed.
[vRP] task 3462 failed.
[vRP] task 3462 failed.
[vRP] task 3462 failed.
[vRP] task 3462 failed.

d3was · August 26, 2019, 7:43pm

here is what i did to resolve this problem

delete all user_identity table then start

u wont face this problem again , and if u . do the same thing

DocWeird · August 26, 2019, 11:54pm

but it’s like a total wipe :S

ChristopherM · August 27, 2019, 12:48am

If I had to take a guess, I would say that the issues is that the database has too many entires for the SQL query to handle. If you have a last active column or similar in your database, you could go though and remove inactive accounts?

d3was · August 27, 2019, 8:49am

other thing u can do is
make it a premium key

DocWeird · August 28, 2019, 5:49am

i have removed the registration number on first spawn, it could fix i think. They will get the reg number later at the town hall when they chose their names etc

d3was · August 28, 2019, 5:10pm

well thats good i think , gl bro

d3was · August 29, 2019, 5:52pm

good , pm me

rashed_0900 · August 29, 2019, 11:38pm

do you get the solution yet?

d3was · August 30, 2019, 9:38am

read above

DocWeird · September 1, 2019, 2:59pm

Since I made that edit i had only 1 db crash but not vRP/init_user_identity, it was vRP/update_user_identity, other than that everything was perfect!

kingsroleplay · September 11, 2019, 4:50am

can I completely migrate VRP to use only this drive?

Bobthejoy_YT_eZ · September 22, 2019, 1:41pm

Hi I have this error in my server the server cmd

SCRIPT ERROR: citizen:/scripting/lua/scheduler.lua:890: No such export is_ready in resource mysql-async

[vBasic] You are running the latest version of vBasic. Good job!

SCRIPT ERROR: citizen:/scripting/lua/scheduler.lua:890: No such export is_ready in resource mysql-async
Performing version check against: https://api.kanersps.pw/em/version?version=6.2.2&uuid=de6c8794-2e83-4eae-4c80-8f56284582b0

SCRIPT ERROR: citizen:/scripting/lua/scheduler.lua:890: No such export is_ready in resource mysql-async
SCRIPT ERROR: citizen:/scripting/lua/scheduler.lua:890: No such export is_ready in resource mysql-async
SCRIPT ERROR: citizen:/scripting/lua/scheduler.lua:890: No such export is_ready in resource mysql-async
SCRIPT ERROR: citizen:/scripting/lua/scheduler.lua:890: No such export is_ready in resource mysql-async
SCRIPT ERROR: citizen:/scripting/lua/scheduler.lua:890: No such export is_ready in resource mysql-async

help pls

D_WOOD · October 15, 2019, 7:17am

nui://mysql-async/ui/app.js:14, Uncaught TypeError: Cannot read property 'type' of undefined

This is the error we are receiving and seeing in the F8 console log. I have seen it noted a few times but unsure what it is calling?