Jump to content
Sign in to follow this  
firefly2442

Arma2MySQL

Recommended Posts

Sensityy and me are looking through this. Arma2NET crashes our arma3server.exe

First server tells, can't load databases.txt

We are trying a freshly installed server, what works at localhost.

Edited by Firedead

Share this post


Link to post
Share on other sites

OK, well definitely check the Arma2NET and Arma2NETMySQL log files. Both of these provide very important information.

Sensityy and me are looking through this. Arma2NET crashes our arma3server.exe

Share this post


Link to post
Share on other sites

He installed me a fresh Server, now everything works.. I dunno why? I am a little speach-less.

Share this post


Link to post
Share on other sites

*shrugs* Well, glad you got it sorted.

He installed me a fresh Server, now everything works.. I dunno why? I am a little speach-less.

Share this post


Link to post
Share on other sites

Okay, I've seen the same problems earlier in the thread but no solutions posted seemed to have helped. I get the following errors:

arma3server_2014-03-02_06-16-08.rpt

6:17:55 c:\w\c_branch\poseidon\futura_stable\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
6:17:55 "Server Time: Jip Var set and synced"
6:17:55 String STR_EVAL_UNHANDLED_EXCEPTION not found
6:17:55 Error in expression <throw "System.Reflection.TargetInvocatio>
6:17:55   Error position: <throw "System.Reflection.TargetInvocatio>
6:17:55   Error
6:17:55 Error in expression <throw "System.Reflection.TargetInvocatio>
6:17:55   Error position: <throw "System.Reflection.TargetInvocatio>
6:17:55   Error 
6:17:55 Error in expression <throw "System.Reflection.TargetInvocatio>
6:17:55   Error position: <throw "System.Reflection.TargetInvocatio>
6:17:55   Error 

Arma2NET.2014-3-2.log

03/02/2014 06:17:55 Caught exception of type System.Reflection.TargetInvocationException
03/02/2014 06:17:55 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not find file 'C:\Users\Admin\AppData\Local\Arma2NETMySQL\Databases.txt'.
  at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
  at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
  at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
  at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)
  at System.IO.StreamReader..ctor(String path)
  at System.IO.File.OpenText(String path)
  at Arma2NETMySQLPlugin.Databases..ctor()
  at Arma2NETMySQLPlugin.Startup.StartupConnection()
  at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Invoke(String args, Int32 maxResultSize)
  at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
  at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
  at System.Delegate.DynamicInvokeImpl(Object[] args)
  at Arma2Net.Managed.AddInManager.DomainDoCallback()
  at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
  at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)
  at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)
  at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)
  at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)
  at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)
03/02/2014 06:17:55 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, coplevel, cop_licenses, cop_gear, adminlevel, blacklist, donatorlvl FROM players WHERE playerid='76561198030840224'']
03/02/2014 06:17:55 maxResultSize: 10239

Databases.txt seems fine, but here's the result from Arma2NETMySQL's log:

03-02-2014_06-16-08.log

Info: 06:17:55 - Logging started in directory: C:\Users\Admin\AppData\Local\Arma2NETMySQL/logs/
Info: 06:17:55 - Arma2NETMySQL Plugin Started.
Info: 06:17:55 - Version number: 0.1.0.0
Info: 06:17:55 - Loading databases...
Info: 06:17:55 - Databases.txt file loading in from: C:\Permanent\Arma 3\Dedicated Server\Databases.txt
Info: 06:17:55 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: server Password: NotShownForSecurityReasons

The game still plays, but none of the loaded addon's features work (Altis Life). Checking MySQL connection, there are no attempted connections from "server", only "root" (being me logging in from MySQL Workbench).

Can anyone help please?

Share this post


Link to post
Share on other sites

Try moving the Databases.txt file to the appdata folder location.

Okay, I've seen the same problems earlier in the thread but no solutions posted seemed to have helped. I get the following errors:

arma3server_2014-03-02_06-16-08.rpt

6:17:55 c:\w\c_branch\poseidon\futura_stable\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
6:17:55 "Server Time: Jip Var set and synced"
6:17:55 String STR_EVAL_UNHANDLED_EXCEPTION not found
6:17:55 Error in expression <throw "System.Reflection.TargetInvocatio>
6:17:55   Error position: <throw "System.Reflection.TargetInvocatio>
6:17:55   Error
6:17:55 Error in expression <throw "System.Reflection.TargetInvocatio>
6:17:55   Error position: <throw "System.Reflection.TargetInvocatio>
6:17:55   Error 
6:17:55 Error in expression <throw "System.Reflection.TargetInvocatio>
6:17:55   Error position: <throw "System.Reflection.TargetInvocatio>
6:17:55   Error 

Arma2NET.2014-3-2.log

03/02/2014 06:17:55 Caught exception of type System.Reflection.TargetInvocationException
03/02/2014 06:17:55 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not find file 'C:\Users\Admin\AppData\Local\Arma2NETMySQL\Databases.txt'.
  at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
  at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
  at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
  at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)
  at System.IO.StreamReader..ctor(String path)
  at System.IO.File.OpenText(String path)
  at Arma2NETMySQLPlugin.Databases..ctor()
  at Arma2NETMySQLPlugin.Startup.StartupConnection()
  at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Invoke(String args, Int32 maxResultSize)
  at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
  at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
  at System.Delegate.DynamicInvokeImpl(Object[] args)
  at Arma2Net.Managed.AddInManager.DomainDoCallback()
  at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
  at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)
  at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)
  at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)
  at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)
  at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)
03/02/2014 06:17:55 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, coplevel, cop_licenses, cop_gear, adminlevel, blacklist, donatorlvl FROM players WHERE playerid='76561198030840224'']
03/02/2014 06:17:55 maxResultSize: 10239

Databases.txt seems fine, but here's the result from Arma2NETMySQL's log:

03-02-2014_06-16-08.log

Info: 06:17:55 - Logging started in directory: C:\Users\Admin\AppData\Local\Arma2NETMySQL/logs/
Info: 06:17:55 - Arma2NETMySQL Plugin Started.
Info: 06:17:55 - Version number: 0.1.0.0
Info: 06:17:55 - Loading databases...
Info: 06:17:55 - Databases.txt file loading in from: C:\Permanent\Arma 3\Dedicated Server\Databases.txt
Info: 06:17:55 - Type: mysql Database: arma3life IPAddress: 127.0.0.1 Port: 3306 Username: server Password: NotShownForSecurityReasons

The game still plays, but none of the loaded addon's features work (Altis Life). Checking MySQL connection, there are no attempted connections from "server", only "root" (being me logging in from MySQL Workbench).

Can anyone help please?

Share this post


Link to post
Share on other sites

Hi i >think< i found a Problem/Bug with "INSERT INTO".

_QueryCreatePlayer = format ["INSERT INTO players (PlayerID) VALUES ('%1')",_PUID];

works but:

_QueryCreatePlayer = format ["INSERT INTO players (PlayerID,Name) VALUES ('%1','%2')",_PUID,_PName];

doesn't work.

Arma2NET.log

03/03/2014 04:13:39 Caught exception of type System.Reflection.TargetInvocationException
03/03/2014 04:13:39 System.Reflection.TargetInvocationException: Ein Aufrufziel hat einen Ausnahmefehler verursacht. ---> System.ArgumentException: Der Wert liegt außerhalb des erwarteten Bereichs.
  bei Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Invoke(String args, Int32 maxResultSize)
  bei Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- Ende der internen Ausnahmestapelüberwachung ---
  bei System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
  bei System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
  bei System.Delegate.DynamicInvokeImpl(Object[] args)
  bei Arma2Net.Managed.AddInManager.DomainDoCallback()
  bei System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
  bei Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)
  bei Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)
  bei Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)
  bei Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)
  bei Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)
03/03/2014 04:13:39 function: Arma2NETMySQLCommand ['test',INSERT INTO players (PlayerID,Name) VALUES ('1337','Legion')]
03/03/2014 04:13:39 maxResultSize: 10239

And in the other log file

Error: 04:13:39 - The number and/or format of the arguments passed in doesn't match.

And i have no idea why.

Then i tried different methods like:

(%1,%2)

or

('%1'',''%2')

but nothing changed.

Share this post


Link to post
Share on other sites

Hmm, that's odd. It looks similar to code in the example mission. I'll try it later today if I get a chance. Thanks for reporting it.

Hi i >think< i found a Problem/Bug with "INSERT INTO".

_QueryCreatePlayer = format ["INSERT INTO players (PlayerID) VALUES ('%1')",_PUID];

works but:

_QueryCreatePlayer = format ["INSERT INTO players (PlayerID,Name) VALUES ('%1','%2')",_PUID,_PName];

doesn't work.

Arma2NET.log

03/03/2014 04:13:39 Caught exception of type System.Reflection.TargetInvocationException
03/03/2014 04:13:39 System.Reflection.TargetInvocationException: Ein Aufrufziel hat einen Ausnahmefehler verursacht. ---> System.ArgumentException: Der Wert liegt außerhalb des erwarteten Bereichs.
  bei Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Invoke(String args, Int32 maxResultSize)
  bei Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- Ende der internen Ausnahmestapelüberwachung ---
  bei System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
  bei System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
  bei System.Delegate.DynamicInvokeImpl(Object[] args)
  bei Arma2Net.Managed.AddInManager.DomainDoCallback()
  bei System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
  bei Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)
  bei Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)
  bei Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)
  bei Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)
  bei Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)
03/03/2014 04:13:39 function: Arma2NETMySQLCommand ['test',INSERT INTO players (PlayerID,Name) VALUES ('1337','Legion')]
03/03/2014 04:13:39 maxResultSize: 10239

And in the other log file

Error: 04:13:39 - The number and/or format of the arguments passed in doesn't match.

And i have no idea why.

Then i tried different methods like:

(%1,%2)

or

('%1'',''%2')

but nothing changed.

Share this post


Link to post
Share on other sites
Try moving the Databases.txt file to the appdata folder location.

I had done that before, and returned the exact same errors. I tested it again, still no luck and the error remains the same, but Databases.txt seems to be picked up by Arma2NETMySQL just fine, just no connection is ever made.

Share this post


Link to post
Share on other sites

Ok, I have ben trying for a week to get my altis life server running. I get the failed to connect after three tries message.

here are my logs

arma2net

03/03/2014 16:32:03 Result: [[]]

03/03/2014 16:32:17 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:32:17 maxResultSize: 10239

03/03/2014 16:32:17 Result size: 4

03/03/2014 16:32:17 Result: [[]]

03/03/2014 16:34:24 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:34:24 maxResultSize: 10239

03/03/2014 16:34:24 Result size: 4

03/03/2014 16:34:24 Result: [[]]

03/03/2014 16:34:26 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561198077358955']

03/03/2014 16:34:26 maxResultSize: 10239

03/03/2014 16:34:26 Result size: 4

03/03/2014 16:34:26 Result: [[]]

03/03/2014 16:34:45 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561198077358955']

03/03/2014 16:34:45 maxResultSize: 10239

03/03/2014 16:34:45 Result size: 4

03/03/2014 16:34:45 Result: [[]]

03/03/2014 16:37:40 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:37:40 maxResultSize: 10239

03/03/2014 16:37:40 Result size: 4

03/03/2014 16:37:40 Result: [[]]

03/03/2014 16:38:10 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:38:10 maxResultSize: 10239

03/03/2014 16:38:10 Result size: 4

03/03/2014 16:38:10 Result: [[]]

03/03/2014 16:38:20 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561198077358955']

03/03/2014 16:38:20 maxResultSize: 10239

03/03/2014 16:38:20 Result size: 4

03/03/2014 16:38:20 Result: [[]]

03/03/2014 16:38:35 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561198077358955']

03/03/2014 16:38:35 maxResultSize: 10239

03/03/2014 16:38:35 Result size: 4

03/03/2014 16:38:35 Result: [[]]

03/03/2014 16:47:21 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:47:21 maxResultSize: 10239

03/03/2014 16:47:21 Result size: 4

03/03/2014 16:47:21 Result: [[]]

03/03/2014 16:47:38 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:47:38 maxResultSize: 10239

03/03/2014 16:47:38 Result size: 4

03/03/2014 16:47:38 Result: [[]]

03/03/2014 17:23:33 function: Arma2NETMySQLCommand ['arma3life', 'CALL resetLifeVehicles();']

03/03/2014 17:23:33 maxResultSize: 10239

03/03/2014 17:23:33 Result size: 4

03/03/2014 17:23:33 Result: [[]]

03/03/2014 17:23:33 function: Arma2NETMySQLCommand ['arma3life', 'CALL deleteDeadVehicles();']

03/03/2014 17:23:33 maxResultSize: 10239

03/03/2014 17:23:33 Result size: 4

03/03/2014 17:23:33 Result: [[]]

03/03/2014 17:23:40 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:40 maxResultSize: 10239

03/03/2014 17:23:40 Result size: 4

03/03/2014 17:23:40 Result: [[]]

03/03/2014 17:23:40 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:40 maxResultSize: 10239

03/03/2014 17:23:40 Result size: 4

03/03/2014 17:23:40 Result: [[]]

03/03/2014 17:23:40 function: Arma2NETMySQLCommand ['arma3life', 'INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561197994310711', 'GazzTheDude', '0', '3000', '0', '"[`GazzTheDude`]"','"[]"')']

03/03/2014 17:23:40 maxResultSize: 10239

03/03/2014 17:23:40 Result size: 13

03/03/2014 17:23:40 Result: [[["Error"]]]

03/03/2014 17:23:40 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:40 maxResultSize: 10239

03/03/2014 17:23:40 Result size: 4

03/03/2014 17:23:40 Result: [[]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 4

03/03/2014 17:23:41 Result: [[]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561197994310711', 'GazzTheDude', '0', '3000', '0', '"[`GazzTheDude`]"','"[]"')']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 13

03/03/2014 17:23:41 Result: [[["Error"]]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 4

03/03/2014 17:23:41 Result: [[]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 4

03/03/2014 17:23:41 Result: [[]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561197994310711', 'GazzTheDude', '0', '3000', '0', '"[`GazzTheDude`]"','"[]"')']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 13

03/03/2014 17:23:41 Result: [[["Error"]]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 4

03/03/2014 17:23:41 Result: [[]]

03/03/2014 17:23:56 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:56 maxResultSize: 10239

03/03/2014 17:23:56 Result size: 4

03/03/2014 17:23:56 Result: [[]]

03/03/2014 17:24:09 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 17:24:09 maxResultSize: 10239

03/03/2014 17:24:09 Result size: 4

03/03/2014 17:24:09 Result: [[]]

i really need help on this one. Thanks in advance

Share this post


Link to post
Share on other sites

I was not able to replicate your problem. Here is the code I copied into the initialization of a unit.

idval = "12345";
uid = "123";
query = format ["INSERT INTO users (id, uid) VALUES ('%1','%2')", idval, uid];
hint(query);
run = "Arma2Net.Unmanaged" callExtension format ["Arma2NETMySQLCommand ['weaponsArma3', '%1']", query];
hint(run);

I'm honestly not quite sure... it looks the same as yours. Are you trying to insert any data with commas in them?

Hi i >think< i found a Problem/Bug with "INSERT INTO".

_QueryCreatePlayer = format ["INSERT INTO players (PlayerID) VALUES ('%1')",_PUID];

works but:

_QueryCreatePlayer = format ["INSERT INTO players (PlayerID,Name) VALUES ('%1','%2')",_PUID,_PName];

doesn't work.

Arma2NET.log

03/03/2014 04:13:39 Caught exception of type System.Reflection.TargetInvocationException
03/03/2014 04:13:39 System.Reflection.TargetInvocationException: Ein Aufrufziel hat einen Ausnahmefehler verursacht. ---> System.ArgumentException: Der Wert liegt außerhalb des erwarteten Bereichs.
  bei Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Invoke(String args, Int32 maxResultSize)
  bei Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- Ende der internen Ausnahmestapelüberwachung ---
  bei System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
  bei System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
  bei System.Delegate.DynamicInvokeImpl(Object[] args)
  bei Arma2Net.Managed.AddInManager.DomainDoCallback()
  bei System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
  bei Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)
  bei Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)
  bei Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize)
  bei Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize)
  bei Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize)
03/03/2014 04:13:39 function: Arma2NETMySQLCommand ['test',INSERT INTO players (PlayerID,Name) VALUES ('1337','Legion')]
03/03/2014 04:13:39 maxResultSize: 10239

And in the other log file

Error: 04:13:39 - The number and/or format of the arguments passed in doesn't match.

And i have no idea why.

Then i tried different methods like:

(%1,%2)

or

('%1'',''%2')

but nothing changed.

---------- Post added at 01:40 ---------- Previous post was at 01:36 ----------

I'm not able to replicate your problem. Can you provide any other details?

I had done that before, and returned the exact same errors. I tested it again, still no luck and the error remains the same, but Databases.txt seems to be picked up by Arma2NETMySQL just fine, just no connection is ever made.

---------- Post added at 01:41 ---------- Previous post was at 01:40 ----------

Please provide Arma2NETMySQL log files.

Ok, I have ben trying for a week to get my altis life server running. I get the failed to connect after three tries message.

here are my logs

arma2net

03/03/2014 16:32:03 Result: [[]]

03/03/2014 16:32:17 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:32:17 maxResultSize: 10239

03/03/2014 16:32:17 Result size: 4

03/03/2014 16:32:17 Result: [[]]

03/03/2014 16:34:24 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:34:24 maxResultSize: 10239

03/03/2014 16:34:24 Result size: 4

03/03/2014 16:34:24 Result: [[]]

03/03/2014 16:34:26 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561198077358955']

03/03/2014 16:34:26 maxResultSize: 10239

03/03/2014 16:34:26 Result size: 4

03/03/2014 16:34:26 Result: [[]]

03/03/2014 16:34:45 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561198077358955']

03/03/2014 16:34:45 maxResultSize: 10239

03/03/2014 16:34:45 Result size: 4

03/03/2014 16:34:45 Result: [[]]

03/03/2014 16:37:40 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:37:40 maxResultSize: 10239

03/03/2014 16:37:40 Result size: 4

03/03/2014 16:37:40 Result: [[]]

03/03/2014 16:38:10 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:38:10 maxResultSize: 10239

03/03/2014 16:38:10 Result size: 4

03/03/2014 16:38:10 Result: [[]]

03/03/2014 16:38:20 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561198077358955']

03/03/2014 16:38:20 maxResultSize: 10239

03/03/2014 16:38:20 Result size: 4

03/03/2014 16:38:20 Result: [[]]

03/03/2014 16:38:35 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561198077358955']

03/03/2014 16:38:35 maxResultSize: 10239

03/03/2014 16:38:35 Result size: 4

03/03/2014 16:38:35 Result: [[]]

03/03/2014 16:47:21 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:47:21 maxResultSize: 10239

03/03/2014 16:47:21 Result size: 4

03/03/2014 16:47:21 Result: [[]]

03/03/2014 16:47:38 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 16:47:38 maxResultSize: 10239

03/03/2014 16:47:38 Result size: 4

03/03/2014 16:47:38 Result: [[]]

03/03/2014 17:23:33 function: Arma2NETMySQLCommand ['arma3life', 'CALL resetLifeVehicles();']

03/03/2014 17:23:33 maxResultSize: 10239

03/03/2014 17:23:33 Result size: 4

03/03/2014 17:23:33 Result: [[]]

03/03/2014 17:23:33 function: Arma2NETMySQLCommand ['arma3life', 'CALL deleteDeadVehicles();']

03/03/2014 17:23:33 maxResultSize: 10239

03/03/2014 17:23:33 Result size: 4

03/03/2014 17:23:33 Result: [[]]

03/03/2014 17:23:40 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:40 maxResultSize: 10239

03/03/2014 17:23:40 Result size: 4

03/03/2014 17:23:40 Result: [[]]

03/03/2014 17:23:40 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:40 maxResultSize: 10239

03/03/2014 17:23:40 Result size: 4

03/03/2014 17:23:40 Result: [[]]

03/03/2014 17:23:40 function: Arma2NETMySQLCommand ['arma3life', 'INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561197994310711', 'GazzTheDude', '0', '3000', '0', '"[`GazzTheDude`]"','"[]"')']

03/03/2014 17:23:40 maxResultSize: 10239

03/03/2014 17:23:40 Result size: 13

03/03/2014 17:23:40 Result: [[["Error"]]]

03/03/2014 17:23:40 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:40 maxResultSize: 10239

03/03/2014 17:23:40 Result size: 4

03/03/2014 17:23:40 Result: [[]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 4

03/03/2014 17:23:41 Result: [[]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561197994310711', 'GazzTheDude', '0', '3000', '0', '"[`GazzTheDude`]"','"[]"')']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 13

03/03/2014 17:23:41 Result: [[["Error"]]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 4

03/03/2014 17:23:41 Result: [[]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 4

03/03/2014 17:23:41 Result: [[]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561197994310711', 'GazzTheDude', '0', '3000', '0', '"[`GazzTheDude`]"','"[]"')']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 13

03/03/2014 17:23:41 Result: [[["Error"]]]

03/03/2014 17:23:41 function: Arma2NETMySQLCommand ['arma3life', 'SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:41 maxResultSize: 10239

03/03/2014 17:23:41 Result size: 4

03/03/2014 17:23:41 Result: [[]]

03/03/2014 17:23:56 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 17:23:56 maxResultSize: 10239

03/03/2014 17:23:56 Result size: 4

03/03/2014 17:23:56 Result: [[]]

03/03/2014 17:24:09 function: Arma2NETMySQLCommand ['arma3life', 'SELECT name, aliases FROM players WHERE playerid=76561197994310711']

03/03/2014 17:24:09 maxResultSize: 10239

03/03/2014 17:24:09 Result size: 4

03/03/2014 17:24:09 Result: [[]]

i really need help on this one. Thanks in advance

Share this post


Link to post
Share on other sites

---------- Post added at 01:41 ---------- Previous post was at 01:40 ----------

Please provide Arma2NETMySQL log files.

they are empty?

Share this post


Link to post
Share on other sites
I was not able to replicate your problem. Here is the code I copied into the initialization of a unit.

idval = "12345";
uid = "123";
query = format ["INSERT INTO users (id, uid) VALUES ('%1','%2')", idval, uid];
hint(query);
run = "Arma2Net.Unmanaged" callExtension format ["Arma2NETMySQLCommand ['weaponsArma3', '%1']", query];
hint(run);

I'm honestly not quite sure... it looks the same as yours. Are you trying to insert any data with commas in them?

Sry my fault..

Forget the " '' " @ the "%1" here:

_ReturnCreatePlayer = "Arma2NET.Unmanaged" callExtension format ["Arma2NETMySQLCommand ['stalker_players',%1]", _QueryCreatePlayer];

Share this post


Link to post
Share on other sites

I'm not able to replicate your problem. Can you provide any other details?

Picking through the Arma2NET log file, I found this error too:

03/03/2014 15:08:07 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019) ---> System.IO.FileLoadException: Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019)
  --- End of inner exception stack trace ---
  at System.Reflection.RuntimeAssembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection, SecurityContextSource securityContextSource)
  at System.Reflection.Assembly.Load(Byte[] rawAssembly)
  at Arma2Net.Managed.AddInManager.DomainLoadAddIn(String assemblyFile)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
  at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
  at System.Delegate.DynamicInvokeImpl(Object[] args)
  at Arma2Net.Managed.AddInManager.DomainDoCallback()
  at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
  at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)
  at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)
  at Arma2Net.Managed.AddInManager.LoadAddIn(String assemblyFile)

System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies.

^This part especially has be wondering. It's giving an error with SQLite dependencies when I'm using MySQL, clearly defined in my Databases.txt file...

Share this post


Link to post
Share on other sites

Yep, as explained in the readme you need both dependencies, even if you're using just MySQL. http://arma2netmysqlplugin.readthedocs.org/en/latest/#requirements

Picking through the Arma2NET log file, I found this error too:

03/03/2014 15:08:07 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019) ---> System.IO.FileLoadException: Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019)
  --- End of inner exception stack trace ---
  at System.Reflection.RuntimeAssembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection, SecurityContextSource securityContextSource)
  at System.Reflection.Assembly.Load(Byte[] rawAssembly)
  at Arma2Net.Managed.AddInManager.DomainLoadAddIn(String assemblyFile)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
  at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
  at System.Delegate.DynamicInvokeImpl(Object[] args)
  at Arma2Net.Managed.AddInManager.DomainDoCallback()
  at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
  at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg)
  at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg)
  at Arma2Net.Managed.AddInManager.LoadAddIn(String assemblyFile)

System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies.

^This part especially has be wondering. It's giving an error with SQLite dependencies when I'm using MySQL, clearly defined in my Databases.txt file...

Share this post


Link to post
Share on other sites
Yep, as explained in the readme you need both dependencies, even if you're using just MySQL. http://arma2netmysqlplugin.readthedocs.org/en/latest/#requirements

I don't see it explained how to install sqlite in there. It seems like it needs to be in an /sqlite folder but both methods I tried (all contents of /"sqlite download folder"/bin in /sqlite and all contents of /"sqlite download folder" in /sqlite). I was using 1.0.91.0 though, as 1.0.89.0 isn't available for download on their site, and their backup that had legacy version was down.

Share this post


Link to post
Share on other sites

http://system.data.sqlite.org/index.html/artifact/d15406bb51f93db2?ln

Yeah, you can't use 1.0.91.0. You need to install this specific version. Or, compile it yourself if you absolutely want to use the latest version.

I don't see it explained how to install sqlite in there. It seems like it needs to be in an /sqlite folder but both methods I tried (all contents of /"sqlite download folder"/bin in /sqlite and all contents of /"sqlite download folder" in /sqlite). I was using 1.0.91.0 though, as 1.0.89.0 isn't available for download on their site, and their backup that had legacy version was down.

Share this post


Link to post
Share on other sites

Ok now it hangs up befor it can read mission

log

Info: 17:56:47 - Logging started in directory: C:\Games\Arma3\A3Master\logs\

Info: 17:56:47 - Arma2NETMySQL Plugin Started.

Info: 17:56:47 - Version number: 0.1.0.0

Info: 17:56:47 - Loading databases...

Warning: 17:56:47 - Unable to find the Databases.txt file here: C:\Games\Arma3\A3Master\Databases.txt

Info: 17:56:48 - Databases.txt file loading in from: C:\Users\Administrator\AppData\Local\Arma2NETMySQL/Databases.txt

Info: 17:56:48 - Type: mysql Database: arma3life IPAddress: localhost Port: 3336 Username: root Password: NotShownForSecurityReasons

Info: 17:56:50 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles();

Info: 17:56:50 - Received - Database: arma3life SQL Query: CALL deleteDeadVehicles();

Info: 17:56:58 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198102917060'

Info: 17:56:58 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198102917060'

Info: 17:56:58 - Received - Database: arma3life SQL Query: INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561198102917060', 'Robinette', '0', '3000', '0', '"[`Robinette`]"','"[]"')

Warning: 17:56:58 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'cop_gear' doesn't have a default value

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()

at Arma2NETMySQLPlugin.MySQL.RunOnDatabase(MySqlCommand command, Int32 maxResultSize)

Info: 17:56:58 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198102917060'

Info: 17:56:59 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198102917060'

Info: 17:56:59 - Received - Database: arma3life SQL Query: INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561198102917060', 'Robinette', '0', '3000', '0', '"[`Robinette`]"','"[]"')

Warning: 17:56:59 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'cop_gear' doesn't have a default value

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()

at Arma2NETMySQLPlugin.MySQL.RunOnDatabase(MySqlCommand command, Int32 maxResultSize)

Info: 17:56:59 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198102917060'

Info: 17:56:59 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198102917060'

Info: 17:56:59 - Received - Database: arma3life SQL Query: INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561198102917060', 'Robinette', '0', '3000', '0', '"[`Robinette`]"','"[]"')

Warning: 17:56:59 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'cop_gear' doesn't have a default value

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()

at Arma2NETMySQLPlugin.MySQL.RunOnDatabase(MySqlCommand command, Int32 maxResultSize)

Info: 17:56:59 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198102917060'

Share this post


Link to post
Share on other sites

http://forums.bistudio.com/showthread.php?168139-Altis-Life-RPG&p=2552484&viewfull=1#post2552484

Ok now it hangs up befor it can read mission

log

Info: 17:56:47 - Logging started in directory: C:\Games\Arma3\A3Master\logs\

Info: 17:56:47 - Arma2NETMySQL Plugin Started.

Info: 17:56:47 - Version number: 0.1.0.0

Info: 17:56:47 - Loading databases...

Warning: 17:56:47 - Unable to find the Databases.txt file here: C:\Games\Arma3\A3Master\Databases.txt

Info: 17:56:48 - Databases.txt file loading in from: C:\Users\Administrator\AppData\Local\Arma2NETMySQL/Databases.txt

Info: 17:56:48 - Type: mysql Database: arma3life IPAddress: localhost Port: 3336 Username: root Password: NotShownForSecurityReasons

Info: 17:56:50 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles();

Info: 17:56:50 - Received - Database: arma3life SQL Query: CALL deleteDeadVehicles();

Info: 17:56:58 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198102917060'

Info: 17:56:58 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198102917060'

Info: 17:56:58 - Received - Database: arma3life SQL Query: INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561198102917060', 'Robinette', '0', '3000', '0', '"[`Robinette`]"','"[]"')

Warning: 17:56:58 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'cop_gear' doesn't have a default value

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()

at Arma2NETMySQLPlugin.MySQL.RunOnDatabase(MySqlCommand command, Int32 maxResultSize)

Info: 17:56:58 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198102917060'

Info: 17:56:59 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198102917060'

Info: 17:56:59 - Received - Database: arma3life SQL Query: INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561198102917060', 'Robinette', '0', '3000', '0', '"[`Robinette`]"','"[]"')

Warning: 17:56:59 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'cop_gear' doesn't have a default value

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()

at Arma2NETMySQLPlugin.MySQL.RunOnDatabase(MySqlCommand command, Int32 maxResultSize)

Info: 17:56:59 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198102917060'

Info: 17:56:59 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='76561198102917060'

Info: 17:56:59 - Received - Database: arma3life SQL Query: INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('76561198102917060', 'Robinette', '0', '3000', '0', '"[`Robinette`]"','"[]"')

Warning: 17:56:59 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'cop_gear' doesn't have a default value

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()

at Arma2NETMySQLPlugin.MySQL.RunOnDatabase(MySqlCommand command, Int32 maxResultSize)

Info: 17:56:59 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='76561198102917060'

Share this post


Link to post
Share on other sites

hi, this project is very good! i would like to know if there's any solution for the mysqlcommand to work correctly when in a servere there are a lot of players, because i've altis life and when the server reach about 50 players arma2net stop working and can update or get anything from the database, i read the mysqlcommandasync but the problem is that if 2 or more player makes a request concurrently from the database with this command the result is exchanged between the players, there an incoming fix for the mysqlcommand?

Share this post


Link to post
Share on other sites

One solution is to use the asynchronous call. This will return back to the server immediately as you mentioned preventing it from locking the server waiting for the return. There is currently no way to make multiple query calls from the server before they return, and return results to the correct person. Even if you could do this, I don't think it would result in any speed improvements since it all has to go through the server anyway. My only suggestions would be:

1) Make sure the SQL server is on the same machine as the game server.

2) Use the asynchronous method

3) Try to combine multiple queries into one.

If you have suggestions or improvements for the existing system I would love to hear them. I've done my best to try to keep decent performance but if there is a way to speed it up, I would certainly like to improve it. At the current level though, I can't think of anything that would help.

hi, this project is very good! i would like to know if there's any solution for the mysqlcommand to work correctly when in a servere there are a lot of players, because i've altis life and when the server reach about 50 players arma2net stop working and can update or get anything from the database, i read the mysqlcommandasync but the problem is that if 2 or more player makes a request concurrently from the database with this command the result is exchanged between the players, there an incoming fix for the mysqlcommand?

Share this post


Link to post
Share on other sites

tnx for your reply, yes for certain operation we are using the async command, is possible that 2 server in a machine with 2 arma2net makes conflicts?

One solution is to use the asynchronous call. This will return back to the server immediately as you mentioned preventing it from locking the server waiting for the return. There is currently no way to make multiple query calls from the server before they return, and return results to the correct person. Even if you could do this, I don't think it would result in any speed improvements since it all has to go through the server anyway. My only suggestions would be:

1) Make sure the SQL server is on the same machine as the game server.

2) Use the asynchronous method

3) Try to combine multiple queries into one.

If you have suggestions or improvements for the existing system I would love to hear them. I've done my best to try to keep decent performance but if there is a way to speed it up, I would certainly like to improve it. At the current level though, I can't think of anything that would help.

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
Sign in to follow this  

×