Jump to content
Bohemia Interactive Forums
Sign in to follow this  
Followers 0
[kh]jman

ArmA2 Persistent Database Scripts - WIP

By [kh]jman, in ARMA 2 & OA : MISSIONS - Editing & Scripting

Recommended Posts

cowboymiller    1

cowboymiller
Posted

it looks like it is not pulling the mission into the DB. what do your other logs show? might try starting with an empty data base, remove all data that may be in the tables. ive noticed it throws that error when ever SOMETHING in the tables is missing a variable. or is "NULL" check the other logs too...

Ive recreated it the .sql that sets up the tables to include [] or "" in the fields that NEED to have a variable in them, ill try and upload it later.

Share this post

Link to post
Share on other sites

diesol    1

diesol
Posted (edited)

Ok so heres what I got.

Arma2Net.log

12/26/2012 22:46:43 Arma2Net.Unmanaged loaded successfully

Arma2NET.2012-12-26.log

12/26/2012 22:22:14 function: Arma2NETMySQL ['arma','UpdatePlayer','tsc=any,tpos=8263|2124.04|0.00143433,tdam=0,tdhe=any,tdbo=any,tdha=any,tdle=any,tdir=333.24,tsta=Stand,tsid=any,tveh=any,tsea=,ttyp=US_Delta_Force_EP1,trat=20000,tvd=any,ttd=any,tran=any,tfir=any,tek=any,tck=any,tfk=any,tsui=any,tlif=ALIVE,tdea=any,ttp=any,tlc=any,tld="12/27/2012 3:22:14 AM",tpid=5756102,tna=Diesel,tmid=any']
12/26/2012 22:22:14 maxResultSize: 10239
12/26/2012 22:46:43 Arma2NET 2.3.0.0 running on CLR 4.0.30319.296
12/26/2012 22:46:43 Loaded into process arma2oaserver
12/26/2012 22:46:43 Loading add-ins
12/26/2012 22:46:43 Found an assembly inside the add-in base directory. If this assembly is an add-in, place it inside an add-in subdirectory: C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\@Arma2NET\AddIns\MySql.Data.dll
12/26/2012 22:46:43 Domain                        Name                Version   Publisher           Description
12/26/2012 22:46:43 DefaultDomain                 Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
12/26/2012 22:46:43 DefaultDomain                 Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
12/26/2012 22:46:43 DefaultDomain                 ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
12/26/2012 22:46:43 DefaultDomain                 CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
12/26/2012 22:46:43 DefaultDomain                 Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
12/26/2012 22:46:43 DefaultDomain                 GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
12/26/2012 22:46:43 DefaultDomain                 SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
12/26/2012 22:46:43 DefaultDomain                 CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
12/26/2012 22:46:43 DefaultDomain                 DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
12/26/2012 22:46:43 Arma2NET initialized in 00:00:00.3223142
12/26/2012 22:46:43 Caught exception of type System.Reflection.TargetInvocationException
12/26/2012 22:46:43 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not find file 'C:\Users\Ck\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)
  at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
  at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize)
  at System.IO.StreamReader..ctor(String path)
  at System.IO.File.OpenText(String path)
  at Arma2NETMySQLPlugin.Databases..ctor()
  at Arma2NETMySQLPlugin.Startup.StartupConnection()
  at Arma2NETMySQLPlugin.Arma2NETMySQLPlugin.Invoke(String args, Int32 maxResultSize)
  at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  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)
12/26/2012 22:46:43 function: Arma2NETMySQL ['arma','GetMissionByName','[tna=Co18 PDB Convoy Hell]']
12/26/2012 22:46:43 maxResultSize: 10239
12/26/2012 22:46:44 Caught exception of type System.Reflection.TargetInvocationException
12/26/2012 22:46:44 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not find file 'C:\Users\Ck\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)
  at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
  at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize)
  at System.IO.StreamReader..ctor(String path)
  at System.IO.File.OpenText(String path)
  at Arma2NETMySQLPlugin.Databases..ctor()
  at Arma2NETMySQLPlugin.Startup.StartupConnection()
  at Arma2NETMySQLPlugin.Arma2NETMySQLPlugin.Invoke(String args, Int32 maxResultSize)
  at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  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)
12/26/2012 22:46:44 function: Arma2NETMySQL ['arma','GetPlayer','[tmid=<null>,tpid=5756102]']
12/26/2012 22:46:44 maxResultSize: 10239
12/26/2012 22:52:34 function: DateTime ['utcnow',]
12/26/2012 22:52:34 maxResultSize: 10239
12/26/2012 22:52:34 Result size: 23
12/26/2012 22:52:34 Result: "12/27/2012 3:52:34 AM"
12/26/2012 22:52:34 Caught exception of type System.Reflection.TargetInvocationException
12/26/2012 22:52:34 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not find file 'C:\Users\Ck\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)
  at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
  at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize)
  at System.IO.StreamReader..ctor(String path)
  at System.IO.File.OpenText(String path)
  at Arma2NETMySQLPlugin.Databases..ctor()
  at Arma2NETMySQLPlugin.Startup.StartupConnection()
  at Arma2NETMySQLPlugin.Arma2NETMySQLPlugin.Invoke(String args, Int32 maxResultSize)
  at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  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)
12/26/2012 22:52:34 function: Arma2NETMySQL ['arma','UpdatePlayer','tsc=any,tpos=8035.55|1941.26|0.00143433,tdam=0,tdhe=any,tdbo=any,tdha=any,tdle=any,tdir=345.483,tsta=Stand,tsid=any,tveh=any,tsea=,ttyp=US_Soldier_TL_EP1,trat=3500,tvd=any,ttd=any,tran=any,tfir=any,tek=any,tck=any,tfk=any,tsui=any,tlif=ALIVE,tdea=any,ttp=any,tlc=any,tld="12/27/2012 3:52:34 AM",tpid=5756102,tna=Diesel,tmid=<null>']
12/26/2012 22:52:34 maxResultSize: 10239

ArmA2OA.RPT

=====================================================================
== C:\Program Files (x86)\Steam\steamapps\common\Arma 2 Operation Arrowhead\ArmA2OA.exe
== "C:\Program Files (x86)\Steam\steamapps\common\Arma 2 Operation Arrowhead\ArmA2OA.exe"
=====================================================================
Exe timestamp: 2012/12/10 21:43:21
Current time:  2012/12/26 22:34:46

Version 1.62.95248
Warning: looped for animation: ca\anims\characters\data\anim\sdr\mov\erc\wlk\non\non\amovpercmwlksnonwnondf.rtm differs (looped now 0)! MoveName: amovpercmstpsnonwnondnon_amovpercmstpsraswpstdnon
Warning: looped for animation: ca\anims\characters\data\anim\sdr\mov\erc\wlk\non\non\amovpercmwlksnonwnondf.rtm differs (looped now 1)! MoveName: amovpercmrunsnonwbindf_rfl
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male05tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male05tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male05tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male05tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male01tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot load sound 'ca\dubbingradio_e\radio\male04tk\default\weapons\machinegun.ogg'
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Ref to nonnetwork object L 1-1-B:<No leader>
Client: Nonnetwork object 3f8ffa60.
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Client: Nonnetwork object 3f8ffa60.
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
"PDB-0 Mission Parameters"
"PDB-0    StartDate = 0"
"PDB-0    StartTime = 12"
"PDB-0    Lives = 6"
"PDB-0    MDifficulty = 2"
"PDB-0    MAircraft = 1"
"PDB-0    persistentDBHeader = 1"
"PDB-0    mpdb_save_delay_server = 600"
"PDB-0    mpdb_save_delay_player = 300"
"PDB-0    mpdb_date_enabled = 1"
"PDB-0    mpdb_weapons_enabled = 1"
"PDB-0    mpdb_landvehicles_enabled = 0"
"PDB-0    mpdb_objects_enabled = 0"
"PDB-0    mpdb_objects_contents_enabled = 0"
"PDB-0    mpdb_locations_enabled = 0"
"PDB-0    mpdb_persistentScores_enabled = 1"
"PDB-0    mpdb_globalScores_enabled = 1"
"PDB-0    mpdb_log_enabled = 1"
["PersistentDB: pdb settings loaded"]
"############################# Starting PDB for Co18 PDB Convoy Hell #############################"
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
["PersistentDB: SPAWN"]
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
You are missing the following mod: cba_main
["PersistentDB: PDB_FNC_SERVER_LOADERSTATUS: ","Mission: Co18 PDB Convoy Hell"]
["PersistentDB: FINISHED MISSION INIT, time: ",4.463]
["PersistentDB: PLAYER READY"]
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone
Cannot use magazine 75Rnd_545x39_RPK in muzzle HandGrenade_Stone

12-26-2012_22-46-43.log

Info: 22:46:43 - Arma2NETMySQL Plugin Started.
Info: 22:46:43 - Version number: 0.1.0.0
Info: 22:46:43 - Compiled against Arma2NET Version: 
Info: 22:46:43 - Loading databases...
Error: 22:46:43 - Unable to find the Databases.txt file, are you sure it's there?

It looks like it still cant find the databases.txt.

Edited by diesol

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

@Diesol:

https://www.dropbox.com/sh/ngix8aunt9nnwj7/ZHt1agEeM0

For more recent versions of the plugin (latest version can be downloaded above), it looks in both the root Arma2 directory as well as the AppData directory for the Databases.txt file. See the readme for additional details. Try that and let us know if it doesn't work.

Share this post

Link to post
Share on other sites

diesol    1

diesol
Posted

That worked thanks firefly2442 but I just have one more problem I cant seem to get it to save my score. Everytime I restart my game it just resets it.

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

Hmm, I'm not sure about that. JMan may know, AFAIK, he authored the mission and created the database design.

Share this post

Link to post
Share on other sites

diesol    1

diesol
Posted (edited)

Well thanks Its probably something I did wrong so I am going to go over what I have done and see if I spot anything and report back to you guys.

Also you said something about a read me where is this located?

Edited by diesol

Share this post

Link to post
Share on other sites

diesol    1

diesol
Posted

So this is what we found and I am not sure what this is doing maby you guys can help me out.

12-28-2012_22-38-04.log

Info: 22:38:04 - Logging started in directory: C:\Users\Ck\AppData\Local\Arma2MySQL/logs/
Info: 22:38:04 - Arma2NETMySQL Plugin Started.
Info: 22:38:04 - Version number: 0.1.0.0
Info: 22:38:04 - Loading databases...
Info: 22:38:04 - Databases.txt file loading in from: C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Databases.txt
Info: 22:38:04 - Type: mysql Database: arma IPAddress: 127.0.0.1 Port: 3306 Username: root Password: NotShownForSecurityReasons
Info: 22:38:04 - Received - Database: arma Procedure: GetMissionByName Parameters: tna=Co18 PDB Convoy Hell
Info: 22:38:04 - Parsing parameters...
Warning: 22:38:04 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma.GetMissionByName does not exist
  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: 22:38:09 - Received - Database: arma Procedure: GetPlayer Parameters: tmid=<null>,tpid=5756102
Info: 22:38:09 - Parsing parameters...
Warning: 22:38:09 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma.GetPlayer does not exist
  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: 22:38:09 - Received - Database: arma Procedure: InsertPlayer Parameters: tpid=5756102,tna=Diesel,tmid=<null>,tsid=WEST,tpos=8035.55|1941.26|0.00143433
Info: 22:38:09 - Parsing parameters...
Warning: 22:38:09 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma.InsertPlayer does not exist
  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: 22:38:09 - Received - Database: arma Procedure: GetGlobalScoreByPlayer Parameters: tpid=5756102
Info: 22:38:09 - Parsing parameters...
Warning: 22:38:09 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma.GetGlobalScoreByPlayer does not exist
  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: 22:39:37 - Received - Database: arma Procedure: UpdatePlayer Parameters: tsc=8,tpos=7927.1|1872.79|0.00143433,tdam=0,tdhe=0,tdbo=0,tdha=0,tdle=0,tdir=334.591,tsta=Stand,tsid=WEST,tveh=any,tsea=,ttyp=US_Soldier_TL_EP1,trat=5100,tvd=1600,ttd=0,tran=CAPTAIN,tfir=0,tek=0,tck=0,tfk=0,tsui=0,tlif=ALIVE,tdea=0,ttp=86.555,tlc="12/29/2012 3:38:09 AM",tld="12/29/2012 3:39:37 AM",tpid=5756102,tna=Diesel,tmid=<null>
Info: 22:39:37 - Parsing parameters...
Warning: 22:39:37 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma.UpdatePlayer does not exist
  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: 22:39:37 - Received - Database: arma Procedure: UpdatePlayerWeapons Parameters: twea="SCAR_L_STD_EGLM_RCO"|"NVGoggles"|"Binocular_Vector"|"ItemMap"|"ItemCompass"|"ItemWatch"|"ItemRadio"|"ItemGPS",tmag="30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"IR_Strobe_Target"|"SmokeShellRed"|"HandGrenade_West"|"HandGrenade_West"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_Smoke_M203"|"1Rnd_Smoke_M203"|"1Rnd_SmokeRed_M203"|"1Rnd_SmokeRed_M203",trck=,trwe=[]|[],trma=[]|[],tpid=5756102,tna=Diesel,tmid=<null>
Info: 22:39:37 - Parsing parameters...
Warning: 22:39:37 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma.UpdatePlayerWeapons does not exist
  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)

Arma2NET.2012-12-28.log

12/28/2012 03:16:36 Arma2NET 2.3.0.0 running on CLR 4.0.30319.296
12/28/2012 03:16:36 Loaded into process Arma2NetExplorer
12/28/2012 03:16:36 Loading add-ins
12/28/2012 03:16:36 Found an assembly inside the add-in base directory. If this assembly is an add-in, place it inside an add-in subdirectory: C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\@Arma2NET\AddIns\MySql.Data.dll
12/28/2012 03:16:37 Domain                        Name                Version   Publisher           Description
12/28/2012 03:16:37 Arma2NetExplorer.exe          Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
12/28/2012 03:16:37 Arma2NetExplorer.exe          Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
12/28/2012 03:16:37 Arma2NetExplorer.exe          ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
12/28/2012 03:16:37 Arma2NetExplorer.exe          CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
12/28/2012 03:16:37 Arma2NetExplorer.exe          Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
12/28/2012 03:16:37 Arma2NetExplorer.exe          GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
12/28/2012 03:16:37 Arma2NetExplorer.exe          SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
12/28/2012 03:16:37 Arma2NetExplorer.exe          CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
12/28/2012 03:16:37 Arma2NetExplorer.exe          DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
12/28/2012 03:16:37 Arma2NET initialized in 00:00:00.8438883
12/28/2012 03:16:37 Caught exception of type Arma2Net.Managed.FunctionNotFoundException
12/28/2012 03:16:37 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: "Arma2NETMySQL"
  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)
12/28/2012 03:16:37 function: "Arma2NETMySQL"
12/28/2012 03:16:37 maxResultSize: 4095
12/28/2012 03:16:46 Caught exception of type System.Reflection.TargetInvocationException
12/28/2012 03:16:46 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: Could not load file or assembly 'MySql.Data, Version=6.5.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
  at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)
  at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)
  at Arma2NETMySQLPlugin.Databases..ctor()
  at Arma2NETMySQLPlugin.Startup.StartupConnection()
  at Arma2NETMySQLPlugin.Arma2NETMySQLPlugin.Invoke(String args, Int32 maxResultSize)
  at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  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)
12/28/2012 03:16:46 function: Arma2NETMySQL
12/28/2012 03:16:46 maxResultSize: 4095
12/28/2012 22:07:23 Arma2NET 2.3.0.0 running on CLR 4.0.30319.296
12/28/2012 22:07:23 Loaded into process Arma2NetExplorer
12/28/2012 22:07:23 Loading add-ins
12/28/2012 22:07:23 Found an assembly inside the add-in base directory. If this assembly is an add-in, place it inside an add-in subdirectory: C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\@Arma2NET\AddIns\MySql.Data.dll
12/28/2012 22:07:24 Domain                        Name                Version   Publisher           Description
12/28/2012 22:07:24 Arma2NetExplorer.exe          Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
12/28/2012 22:07:24 Arma2NetExplorer.exe          Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
12/28/2012 22:07:24 Arma2NetExplorer.exe          ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
12/28/2012 22:07:24 Arma2NetExplorer.exe          CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
12/28/2012 22:07:24 Arma2NetExplorer.exe          Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
12/28/2012 22:07:24 Arma2NetExplorer.exe          GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
12/28/2012 22:07:24 Arma2NetExplorer.exe          SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
12/28/2012 22:07:24 Arma2NetExplorer.exe          CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
12/28/2012 22:07:24 Arma2NetExplorer.exe          DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
12/28/2012 22:07:24 Arma2NET initialized in 00:00:00.6968310
12/28/2012 22:07:24 Caught exception of type Arma2Net.Managed.FunctionNotFoundException
12/28/2012 22:07:24 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: "Arma2NETMySQL"
  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)
12/28/2012 22:07:24 function: "Arma2NETMySQL"
12/28/2012 22:07:24 maxResultSize: 4095
12/28/2012 22:08:05 Caught exception of type Arma2Net.Managed.FunctionNotFoundException
12/28/2012 22:08:05 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: "Arma2NETMySQL"
  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)
12/28/2012 22:08:05 function: "Arma2NETMySQL"
12/28/2012 22:08:05 maxResultSize: 4095
12/28/2012 22:09:04 Caught exception of type Arma2Net.Managed.FunctionNotFoundException
12/28/2012 22:09:04 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: "Arma2NETMySQL"
  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)
12/28/2012 22:09:04 function: "Arma2NETMySQL"
12/28/2012 22:09:04 maxResultSize: 4095
12/28/2012 22:09:06 Caught exception of type Arma2Net.Managed.FunctionNotFoundException
12/28/2012 22:09:06 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: "Arma2NETMySQL"
  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)
12/28/2012 22:09:06 function: "Arma2NETMySQL"
12/28/2012 22:09:06 maxResultSize: 4095
12/28/2012 22:09:11 Caught exception of type System.Reflection.TargetInvocationException
12/28/2012 22:09:11 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not find file 'C:\Users\Ck\AppData\Local\Arma2MySQL\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)
  at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
  at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize)
  at System.IO.StreamReader..ctor(String path)
  at System.IO.File.OpenText(String path)
  at Arma2NETMySQLPlugin.Databases..ctor()
  at Arma2NETMySQLPlugin.Startup.StartupConnection()
  at Arma2NETMySQLPlugin.Arma2NETMySQLPlugin.Invoke(String args, Int32 maxResultSize)
  at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  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)
12/28/2012 22:09:11 function: Arma2NETMySQL
12/28/2012 22:09:11 maxResultSize: 4095
12/28/2012 22:11:09 Caught exception of type System.Reflection.TargetInvocationException
12/28/2012 22:11:09 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: Could not load file or assembly 'MySql.Data, Version=6.5.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
  at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString)
  at Arma2NETMySQLPlugin.DatabaseObject..ctor(String[] values)
  at Arma2NETMySQLPlugin.Databases..ctor()
  at Arma2NETMySQLPlugin.Startup.StartupConnection()
  at Arma2NETMySQLPlugin.Arma2NETMySQLPlugin.Invoke(String args, Int32 maxResultSize)
  at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args)
  --- End of inner exception stack trace ---
  at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  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)
12/28/2012 22:11:09 function: Arma2NETMySQL
12/28/2012 22:11:09 maxResultSize: 4095
12/28/2012 22:38:04 Arma2NET 2.3.0.0 running on CLR 4.0.30319.296
12/28/2012 22:38:04 Loaded into process arma2oaserver
12/28/2012 22:38:04 Loading add-ins
12/28/2012 22:38:04 Found an assembly inside the add-in base directory. If this assembly is an add-in, place it inside an add-in subdirectory: C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\@Arma2NET\AddIns\MySql.Data.dll
12/28/2012 22:38:04 Domain                        Name                Version   Publisher           Description
12/28/2012 22:38:04 DefaultDomain                 Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
12/28/2012 22:38:04 DefaultDomain                 Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
12/28/2012 22:38:04 DefaultDomain                 ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
12/28/2012 22:38:04 DefaultDomain                 CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
12/28/2012 22:38:04 DefaultDomain                 Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
12/28/2012 22:38:04 DefaultDomain                 GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
12/28/2012 22:38:04 DefaultDomain                 SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
12/28/2012 22:38:04 DefaultDomain                 CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
12/28/2012 22:38:04 DefaultDomain                 DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
12/28/2012 22:38:04 Arma2NET initialized in 00:00:00.1350536
12/28/2012 22:38:04 function: Arma2NETMySQL ['arma','GetMissionByName','[tna=Co18 PDB Convoy Hell]']
12/28/2012 22:38:04 maxResultSize: 10239
12/28/2012 22:38:04 Result size: 13
12/28/2012 22:38:04 Result: [[["Error"]]]
12/28/2012 22:38:09 function: Arma2NETMySQL ['arma','GetPlayer','[tmid=<null>,tpid=5756102]']
12/28/2012 22:38:09 maxResultSize: 10239
12/28/2012 22:38:09 Result size: 13
12/28/2012 22:38:09 Result: [[["Error"]]]
12/28/2012 22:38:09 function: DateTime ['utcnow',]
12/28/2012 22:38:09 maxResultSize: 10239
12/28/2012 22:38:09 Result size: 23
12/28/2012 22:38:09 Result: "12/29/2012 3:38:09 AM"
12/28/2012 22:38:09 function: Arma2NETMySQL ['arma','InsertPlayer','[tpid=5756102,tna=Diesel,tmid=<null>,tsid=WEST,tpos=8035.55|1941.26|0.00143433]']
12/28/2012 22:38:09 maxResultSize: 10239
12/28/2012 22:38:09 Result size: 13
12/28/2012 22:38:09 Result: [[["Error"]]]
12/28/2012 22:38:09 function: Arma2NETMySQL ['arma','GetGlobalScoreByPlayer','[tpid=5756102]']
12/28/2012 22:38:09 maxResultSize: 10239
12/28/2012 22:38:09 Result size: 13
12/28/2012 22:38:09 Result: [[["Error"]]]
12/28/2012 22:39:37 function: DateTime ['utcnow',]
12/28/2012 22:39:37 maxResultSize: 10239
12/28/2012 22:39:37 Result size: 23
12/28/2012 22:39:37 Result: "12/29/2012 3:39:37 AM"
12/28/2012 22:39:37 function: Arma2NETMySQL ['arma','UpdatePlayer','tsc=8,tpos=7927.1|1872.79|0.00143433,tdam=0,tdhe=0,tdbo=0,tdha=0,tdle=0,tdir=334.591,tsta=Stand,tsid=WEST,tveh=any,tsea=,ttyp=US_Soldier_TL_EP1,trat=5100,tvd=1600,ttd=0,tran=CAPTAIN,tfir=0,tek=0,tck=0,tfk=0,tsui=0,tlif=ALIVE,tdea=0,ttp=86.555,tlc="12/29/2012 3:38:09 AM",tld="12/29/2012 3:39:37 AM",tpid=5756102,tna=Diesel,tmid=<null>']
12/28/2012 22:39:37 maxResultSize: 10239
12/28/2012 22:39:37 Result size: 13
12/28/2012 22:39:37 Result: [[["Error"]]]
12/28/2012 22:39:37 function: Arma2NETMySQL ['arma','UpdatePlayerWeapons','twea="SCAR_L_STD_EGLM_RCO"|"NVGoggles"|"Binocular_Vector"|"ItemMap"|"ItemCompass"|"ItemWatch"|"ItemRadio"|"ItemGPS",tmag="30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"30Rnd_556x45_Stanag"|"IR_Strobe_Target"|"SmokeShellRed"|"HandGrenade_West"|"HandGrenade_West"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_HE_M203"|"1Rnd_Smoke_M203"|"1Rnd_Smoke_M203"|"1Rnd_SmokeRed_M203"|"1Rnd_SmokeRed_M203",trck=,trwe=[]|[],trma=[]|[],tpid=5756102,tna=Diesel,tmid=<null>']
12/28/2012 22:39:37 maxResultSize: 10239
12/28/2012 22:39:37 Result size: 13
12/28/2012 22:39:37 Result: [[["Error"]]]

Is it timing out?

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

It looks like you're missing the stored procedures in your database. Make sure to use the provided SQL file and load those stored procedures in. It doesn't seem to be able to find them.

Share this post

Link to post
Share on other sites

diesol    1

diesol
Posted

Ok that would make sense but my friend who knows about this stuff had to go out of town for a little while so I am on my own. He set this up for me so I am new to mysql so I use mysql workbench I log into where the database.txt is suppose to be saving this. Now how do I make it so it read it? I would guess "Create a new schema in the connected server" then save the name as "arma". After i get this far idk what to do.

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

The SQL file creates the database and necessary stored procedures. I have no experience with mysql workbench, however, you can do all this from the commandline as well:

http://forum.codecall.net/topic/35612-import-sql-file-command-line/#axzz2GUmrDA4D

Open command prompt and change directory (cd) to the appropriate place where you installed MySQL. Then run mysql with the appropriate parameters as can be seen in the above link. Make sure you specify the SQL file provided by the PDB mission.

Share this post

Link to post
Share on other sites

diesol    1

diesol
Posted

I tried it with the workbench and I found out how to install it and everything looks correct. I even tried your way through the Command line and it looks like its the same info as last time.

Arma2NET.2012-12-30.log

12/30/2012 01:01:21 Arma2NET 2.3.0.0 running on CLR 4.0.30319.296
12/30/2012 01:01:21 Loaded into process arma2oaserver
12/30/2012 01:01:21 Loading add-ins
12/30/2012 01:01:21 Found an assembly inside the add-in base directory. If this assembly is an add-in, place it inside an add-in subdirectory: C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\@Arma2NET\AddIns\MySql.Data.dll
12/30/2012 01:01:22 Domain                        Name                Version   Publisher           Description
12/30/2012 01:01:22 DefaultDomain                 Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
12/30/2012 01:01:22 DefaultDomain                 Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
12/30/2012 01:01:22 DefaultDomain                 ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
12/30/2012 01:01:22 DefaultDomain                 CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
12/30/2012 01:01:22 DefaultDomain                 Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
12/30/2012 01:01:22 DefaultDomain                 GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
12/30/2012 01:01:22 DefaultDomain                 SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
12/30/2012 01:01:22 DefaultDomain                 CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
12/30/2012 01:01:22 DefaultDomain                 DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
12/30/2012 01:01:22 Arma2NET initialized in 00:00:00.2820566
12/30/2012 01:01:22 function: Arma2NETMySQL ['arma','GetMissionByName','[tna=Co18 PDB Convoy Hell]']
12/30/2012 01:01:22 maxResultSize: 10239
12/30/2012 01:01:22 Result size: 13
12/30/2012 01:01:22 Result: [[["Error"]]]
12/30/2012 01:01:26 function: Arma2NETMySQL ['arma','GetPlayer','[tmid=<null>,tpid=5756102]']
12/30/2012 01:01:26 maxResultSize: 10239
12/30/2012 01:01:26 Result size: 13
12/30/2012 01:01:26 Result: [[["Error"]]]
12/30/2012 01:01:26 function: DateTime ['utcnow',]
12/30/2012 01:01:26 maxResultSize: 10239
12/30/2012 01:01:26 Result size: 23
12/30/2012 01:01:26 Result: "12/30/2012 6:01:26 AM"
12/30/2012 01:01:26 function: Arma2NETMySQL ['arma','InsertPlayer','[tpid=5756102,tna=Diesel,tmid=<null>,tsid=WEST,tpos=8035.55|1941.26|0.00143433]']
12/30/2012 01:01:26 maxResultSize: 10239
12/30/2012 01:01:26 Result size: 13
12/30/2012 01:01:26 Result: [[["Error"]]]
12/30/2012 01:01:26 function: Arma2NETMySQL ['arma','GetGlobalScoreByPlayer','[tpid=5756102]']
12/30/2012 01:01:26 maxResultSize: 10239
12/30/2012 01:01:26 Result size: 13
12/30/2012 01:01:26 Result: [[["Error"]]]

12-30-2012_01-01-22.log

Info: 01:01:22 - Logging started in directory: C:\Users\Ck\AppData\Local\Arma2MySQL/logs/
Info: 01:01:22 - Arma2NETMySQL Plugin Started.
Info: 01:01:22 - Version number: 0.1.0.0
Info: 01:01:22 - Loading databases...
Info: 01:01:22 - Databases.txt file loading in from: C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Databases.txt
Info: 01:01:22 - Type: mysql Database: arma IPAddress: 127.0.0.1 Port: 3306 Username: root Password: NotShownForSecurityReasons
Info: 01:01:22 - Received - Database: arma Procedure: GetMissionByName Parameters: tna=Co18 PDB Convoy Hell
Info: 01:01:22 - Parsing parameters...
Warning: 01:01:22 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma.GetMissionByName does not exist
  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: 01:01:26 - Received - Database: arma Procedure: GetPlayer Parameters: tmid=<null>,tpid=5756102
Info: 01:01:26 - Parsing parameters...
Warning: 01:01:26 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma.GetPlayer does not exist
  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: 01:01:26 - Received - Database: arma Procedure: InsertPlayer Parameters: tpid=5756102,tna=Diesel,tmid=<null>,tsid=WEST,tpos=8035.55|1941.26|0.00143433
Info: 01:01:26 - Parsing parameters...
Warning: 01:01:26 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma.InsertPlayer does not exist
  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: 01:01:26 - Received - Database: arma Procedure: GetGlobalScoreByPlayer Parameters: tpid=5756102
Info: 01:01:26 - Parsing parameters...
Warning: 01:01:26 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE arma.GetGlobalScoreByPlayer does not exist
  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)

arma2oaserver.RPT

=====================================================================
== C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Expansion\beta\arma2oaserver.exe
== "C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Expansion\beta\arma2oaserver.exe" -arma2netdev -port=2302 -config=Server.cfg -mod=expansion\beta;expansion\beta\expansion;@CBA;@CBA_A2;@CBA_OA;@Arma2NET
=====================================================================
Exe timestamp: 2012/12/27 21:21:01
Current time:  2012/12/30 01:00:37

Version 1.62.100257
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Server error: Player without identity Diesel (id 599292829)
Warning: looped for animation: ca\anims\characters\data\anim\sdr\mov\erc\wlk\non\non\amovpercmwlksnonwnondf.rtm differs (looped now 0)! MoveName: amovpercmstpsnonwnondnon_amovpercmstpsraswpstdnon
[5647,66.508,0,"XEH: PreInit Started. v1.0.0.187. MISSINIT: missionName=Co18 PDB Convoy Hell, worldName=Takistan, isMultiplayer=true, isServer=true, isDedicated=true"]
[5647,69.05,0,"XEH: PreInit Finished. CACHE DISABLED? (Disable caching with cba_disable_cache.pbo): SLX_XEH_RECOMPILE=false, CBA_COMPILE_RECOMPILE=false, CBA_FUNC_RECOMPILE=false"]
Client: Nonnetwork object 21b7e040.
Client: Nonnetwork object 21d78080.
Error in expression <s = _this select 2;
_spawndelay = _this select 3;


_vehicle = false;
_sim = get>
 Error position: <select 3;


_vehicle = false;
_sim = get>
 Error Zero divisor
File mpmissions\__cur_mp.Takistan\mxr_scripts\spawn_groups\third_group.sqf, line 47
Unit not created: Subgroup 0:0 not found
Cannot create object 3:1
[5847,86.661,0,"XEH: PostInit Started"]
[5847,86.69,0,"CBA_VERSIONING: cba=1.0.0.188, cba_a2=1.0.0.8, cba_oa=1.0.0.6, "]
[5847,87.209,0,"XEH: PostInit Finished. State: _isClient=false, _isJip=false, _isDedClient=false, _isServer=true, _isDedServer=true, _playerCheckDone=true, _sp=false, _startInitDone=true, _postInitDone=true, _mpRespawn=true, _machineType=0, _sessionId=1, _level=0, _timeOut=false, _game=1, BIS_functions=L 1-1-B:1, group=L 1-1-B"]
"--------------------------------"
"UPSMON started"
"PDB-0 Mission Parameters"
"PDB-0    StartDate = 0"
"PDB-0    StartTime = 12"
"PDB-0    Lives = 6"
"PDB-0    MDifficulty = 2"
"PDB-0    MAircraft = 1"
"PDB-0    persistentDBHeader = 1"
"PDB-0    mpdb_save_delay_server = 600"
"PDB-0    mpdb_save_delay_player = 300"
"PDB-0    mpdb_date_enabled = 1"
"PDB-0    mpdb_weapons_enabled = 1"
"PDB-0    mpdb_landvehicles_enabled = 0"
"PDB-0    mpdb_objects_enabled = 0"
"PDB-0    mpdb_objects_contents_enabled = 0"
"PDB-0    mpdb_locations_enabled = 0"
"PDB-0    mpdb_persistentScores_enabled = 1"
"PDB-0    mpdb_globalScores_enabled = 1"
"PDB-0    mpdb_log_enabled = 1"
Server: Object 2:971 not found (message 221)
Server: Object 2:972 not found (message 221)
["PersistentDB: pdb settings loaded"]
"############################# Starting PDB for Co18 PDB Convoy Hell #############################"
Server: Object 2:987 not found (message 221)
Server: Object 2:988 not found (message 221)
Server: Object 2:989 not found (message 221)
Server: Object 2:1004 not found (message 221)
Server: Object 2:1005 not found (message 221)
Server: Object 2:1209 not found (message 132)
Server: Object 2:1233 not found (message 132)
"SERVER MSG: count MISSIONDATA, 0"
0:01:34.794 (0:00:00.603) versioning - cba_main - Not running! (Machine: S1 (Diesel))
["PASS: _player: ",S1]
["PASS: _puid: ","5756102"]
["PASS: _pname: ","Diesel"]
["PASS: _playerSide: ",WEST]
"SERVER MSG: Mission ID (ARRAY) is <null>"
"SERVER MSG: Player connected Diesel, puid 5756102"
Error in expression <nt _dataRead > 0) then {

if (_dataRead select 2 == _puid) then {

_seen = true;>
 Error position: <select 2 == _puid) then {

_seen = true;>
 Error Zero divisor
File mpmissions\__cur_mp.Takistan\core\modules\persistentDB\initPlayerConnection.sqf, line 51
"SERVER MSG: Adding score 0 to Diesel, playerObject:S1, puid:5756102"
["PersistentDB: SERVER PV - PDB_ACTIVATEPLAYER: ",[s1,"Diesel",false]]

Share this post

Link to post
Share on other sites

diesol    1

diesol
Posted

It says everything is running but now its giving me somthing new in one of the logs.

Info: 00:21:58 - Logging started in directory: C:\Users\Ck\AppData\Local\Arma2MySQL/logs/
Info: 00:21:58 - Arma2NETMySQL Plugin Started.
Info: 00:21:58 - Version number: 0.1.0.0
Info: 00:21:58 - Loading databases...
Info: 00:21:58 - Databases.txt file loading in from: C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Databases.txt
Info: 00:21:58 - Type: mysql Database: arma IPAddress: 127.0.0.1 Port: 3306 Username: root Password: NotShownForSecurityReasons
Info: 00:21:58 - Received - Database: arma Procedure: GetMissionByName Parameters: tna=Co18 PDB Convoy Hell
Info: 00:21:58 - Parsing parameters...
Warning: 00:21:58 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): The user specified as a definer ('arma'@'localhost') does not exist
  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: 00:22:12 - Received - Database: arma Procedure: GetPlayer Parameters: tmid=<null>,tpid=5756102
Info: 00:22:12 - Parsing parameters...
Warning: 00:22:12 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: '<null>' for column 'tmid' at row 1
  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: 00:22:12 - Received - Database: arma Procedure: InsertPlayer Parameters: tpid=5756102,tna=Diesel,tmid=<null>,tsid=WEST,tpos=8035.55|1941.26|0.00143433
Info: 00:22:12 - Parsing parameters...
Warning: 00:22:12 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: '<null>' for column 'tmid' at row 1
  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: 00:22:12 - Received - Database: arma Procedure: GetGlobalScoreByPlayer Parameters: tpid=5756102
Info: 00:22:12 - Parsing parameters...
Warning: 00:22:12 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): The user specified as a definer ('arma'@'localhost') does not exist
  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)

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted

It looks like the stored procedures and SQL are all setup to use arma@localhost. This means the username is "arma". This MySQL user needs to exist and have privileges to the appropriate database.

http://serverfault.com/questions/117525/how-can-i-show-users-privileges-in-mysql

This may help for showing MySQL users and privileges. I would guess the "arma" user doesn't exist or the privileges are incorrect.

Share this post

Link to post
Share on other sites

diesol    1

diesol
Posted

We finally got it working one of your older posts said don't use root as username. We changed that and it worked everything is working great so thanks for your help.

I just have another problem with the mission I need to know if there's a way to hide the loading screens for the database. I am running domination on the server but I really don't want too remove the intro for that. They have a problem when they both load in it gets stuck on Please Wait loading player data.

If your not sure its fine I can always find out myself and post back how to do it.

Thanks

Share this post

Link to post
Share on other sites

[kh]jman    49

[kh]jman
Posted

Development of the standalone PDB scripts has ceased, we have moved development be to exclusively MSO based.

Share this post

Link to post
Share on other sites

cowboymiller    1

cowboymiller
Posted

@diesol,

its not the loading screen conflicting with your other loading screen thats the problem, if its hung up on "loading player data" this tends to be a problem with the specific player data being pulled from the data base, do you have any entries in the player table? you may want to delete the record and start fresh. I use NaviCat, its a way easier way to see the tables and change tables if need be.

Share this post

Link to post
Share on other sites

mikie boy    18

mikie boy
Posted
Development of the standalone PDB scripts has ceased, we have moved development be to exclusively MSO based.

shame - but good luck with it, hope combining it with MSO works out.

Share this post

Link to post
Share on other sites

diesol    1

diesol
Posted

I decided to remove all the data and set it up again but I still seem to be getting this issue. It keeps getting stuck on "Please wait setting up client" I checked my logs and there is a error going on.

01-05-2013_17-04-29

Info: 17:04:29 - Logging started in directory: C:\Users\Ck\AppData\Local\Arma2MySQL/logs/
Info: 17:04:29 - Arma2NETMySQL Plugin Started.
Info: 17:04:29 - Version number: 0.1.0.0
Info: 17:04:29 - Loading databases...
Info: 17:04:29 - Databases.txt file loading in from: C:\Program Files (x86)\Steam\steamapps\common\Arma 2 Operation Arrowhead\Databases.txt
Info: 17:04:29 - Type: mysql Database: arma IPAddress: 127.0.0.1 Port: 3306 Username: arma Password: NotShownForSecurityReasons
Info: 17:04:30 - Received - Database: arma Procedure: UpdatePlayer Parameters: tsc=any,tpos=8263.11|2124.25|0.00143433,tdam=0,tdhe=any,tdbo=any,tdha=any,tdle=any,tdir=333.24,tsta=Stand,tsid=any,tveh=any,tsea=,ttyp=US_Delta_Force_EP1,trat=0,tvd=any,ttd=any,tran=any,tfir=any,tek=any,tck=any,tfk=any,tsui=any,tlif=ALIVE,tdea=any,ttp=any,tlc=any,tld="1/5/2013 10:04:28 PM",tpid=5756102,tna=Diesel,tmid=any
Info: 17:04:30 - Parsing parameters...
Warning: 17:04:31 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: 'any' for column 'tsc' at row 198
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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:04:32 - Received - Database: arma Procedure: UpdatePlayerWeapons Parameters: twea="SCAR_H_CQC_CCO"|"NVGoggles"|"Binocular_Vector"|"M9"|"ItemMap"|"ItemCompass"|"ItemWatch"|"ItemRadio"|"ItemGPS",tmag="20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"HandGrenade_West"|"HandGrenade_West"|"IR_Strobe_Target"|"SmokeShellRed"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9",trck=US_Backpack_Specops_EP1,trwe=[]|[],trma=["1Rnd_HE_M203"|"1Rnd_SmokeRed_M203"|"PipeBomb"|"HandGrenade_West"|"SmokeShellRed"|"Laserbatteries"|"IR_Strobe_Target"]|[2|2|1|2|2|1|1],tpid=5756102,tna=Diesel,tmid=any
Info: 17:04:32 - Parsing parameters...
Warning: 17:04:32 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: 'any' for column 'tmid' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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:09:05 - Received - Database: arma Procedure: UpdateDate Parameters: tda=2013|1|2|6|50,tmid=any
Info: 17:09:05 - Parsing parameters...
Warning: 17:09:05 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: 'any' for column 'tmid' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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:10:20 - Received - Database: arma Procedure: UpdatePlayer Parameters: tsc=any,tpos=8263.11|2124.25|0.00143433,tdam=0,tdhe=any,tdbo=any,tdha=any,tdle=any,tdir=333.24,tsta=Stand,tsid=any,tveh=any,tsea=,ttyp=US_Delta_Force_EP1,trat=0,tvd=any,ttd=any,tran=any,tfir=any,tek=any,tck=any,tfk=any,tsui=any,tlif=ALIVE,tdea=any,ttp=any,tlc=any,tld="1/5/2013 10:10:20 PM",tpid=5756102,tna=Diesel,tmid=any
Info: 17:10:20 - Parsing parameters...
Warning: 17:10:20 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: 'any' for column 'tsc' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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:10:21 - Received - Database: arma Procedure: UpdatePlayerWeapons Parameters: twea="SCAR_H_CQC_CCO"|"NVGoggles"|"Binocular_Vector"|"M9"|"ItemMap"|"ItemCompass"|"ItemWatch"|"ItemRadio"|"ItemGPS",tmag="20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"HandGrenade_West"|"HandGrenade_West"|"IR_Strobe_Target"|"SmokeShellRed"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9",trck=US_Backpack_Specops_EP1,trwe=[]|[],trma=["1Rnd_HE_M203"|"1Rnd_SmokeRed_M203"|"PipeBomb"|"HandGrenade_West"|"SmokeShellRed"|"Laserbatteries"|"IR_Strobe_Target"]|[2|2|1|2|2|1|1],tpid=5756102,tna=Diesel,tmid=any
Info: 17:10:21 - Parsing parameters...
Warning: 17:10:21 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: 'any' for column 'tmid' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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)

Arma2NET.2013-1-5

01/05/2013 16:57:09 Arma2NET 2.3.0.0 running on CLR 4.0.30319.296
01/05/2013 16:57:09 Loaded into process arma2oaserver
01/05/2013 16:57:09 Loading add-ins
01/05/2013 16:57:10 Found an assembly inside the add-in base directory. If this assembly is an add-in, place it inside an add-in subdirectory: C:\Program Files (x86)\Steam\steamapps\common\Arma 2 Operation Arrowhead\@Arma2NET\AddIns\MySql.Data.dll
01/05/2013 16:57:19 Domain                        Name                Version   Publisher           Description
01/05/2013 16:57:19 DefaultDomain                 Arma2NETMySQL       0.1.0.0   firefly2442         Runs MySQL procedure commands.
01/05/2013 16:57:19 DefaultDomain                 Arma2NETMySQLCommand0.1.0.0   firefly2442         Runs raw MySQL/SQLite commands
01/05/2013 16:57:19 DefaultDomain                 ClrVersion          2.0.0.0   Scott_NZ            Retrieves the version of the Common Language Runtime.
01/05/2013 16:57:19 DefaultDomain                 CompareVersion      2.0.0.0   Scott_NZ            Compares two version strings and returns an integer indicating how they compare.
01/05/2013 16:57:19 DefaultDomain                 Version             2.0.0.0   Scott_NZ            Returns the version of Arma2NET.
01/05/2013 16:57:19 DefaultDomain                 GetClipboardText    1.0.0.0   Scott_NZ            Gets the clipboard text value.
01/05/2013 16:57:19 DefaultDomain                 SetClipboardText    1.0.0.0   Scott_NZ            Sets the clipboard to a text value.
01/05/2013 16:57:19 DefaultDomain                 CommandLine         2.0.0.0   Scott_NZ            Returns the command line used to start the application.
01/05/2013 16:57:19 DefaultDomain                 DateTime            2.0.0.0   Scott_NZ            Returns the current date and time.
01/05/2013 16:57:19 Arma2NET initialized in 00:00:14.1162480
01/05/2013 16:57:19 Caught exception of type Arma2Net.Managed.FunctionNotFoundException
01/05/2013 16:57:19 Arma2Net.Managed.FunctionNotFoundException: The specified add-in was not found: DomDatabase
  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)
01/05/2013 16:57:19 function: DomDatabase ['Init','DomDatabase','Dom.db']
01/05/2013 16:57:19 maxResultSize: 4095
01/05/2013 17:04:28 function: DateTime ['utcnow',]
01/05/2013 17:04:28 maxResultSize: 4095
01/05/2013 17:04:28 Result size: 22
01/05/2013 17:04:28 Result: "1/5/2013 10:04:28 PM"
01/05/2013 17:04:31 function: Arma2NETMySQL ['arma','UpdatePlayer','tsc=any,tpos=8263.11|2124.25|0.00143433,tdam=0,tdhe=any,tdbo=any,tdha=any,tdle=any,tdir=333.24,tsta=Stand,tsid=any,tveh=any,tsea=,ttyp=US_Delta_Force_EP1,trat=0,tvd=any,ttd=any,tran=any,tfir=any,tek=any,tck=any,tfk=any,tsui=any,tlif=ALIVE,tdea=any,ttp=any,tlc=any,tld="1/5/2013 10:04:28 PM",tpid=5756102,tna=Diesel,tmid=any']
01/05/2013 17:04:31 maxResultSize: 4095
01/05/2013 17:04:31 Result size: 13
01/05/2013 17:04:31 Result: [[["Error"]]]
01/05/2013 17:04:32 function: Arma2NETMySQL ['arma','UpdatePlayerWeapons','twea="SCAR_H_CQC_CCO"|"NVGoggles"|"Binocular_Vector"|"M9"|"ItemMap"|"ItemCompass"|"ItemWatch"|"ItemRadio"|"ItemGPS",tmag="20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"HandGrenade_West"|"HandGrenade_West"|"IR_Strobe_Target"|"SmokeShellRed"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9",trck=US_Backpack_Specops_EP1,trwe=[]|[],trma=["1Rnd_HE_M203"|"1Rnd_SmokeRed_M203"|"PipeBomb"|"HandGrenade_West"|"SmokeShellRed"|"Laserbatteries"|"IR_Strobe_Target"]|[2|2|1|2|2|1|1],tpid=5756102,tna=Diesel,tmid=any']
01/05/2013 17:04:32 maxResultSize: 4095
01/05/2013 17:04:32 Result size: 13
01/05/2013 17:04:32 Result: [[["Error"]]]
01/05/2013 17:09:05 function: Arma2NETMySQL ['arma','UpdateDate','[tda=2013|1|2|6|50,tmid=any]']
01/05/2013 17:09:05 maxResultSize: 4095
01/05/2013 17:09:05 Result size: 13
01/05/2013 17:09:05 Result: [[["Error"]]]
01/05/2013 17:10:20 function: DateTime ['utcnow',]
01/05/2013 17:10:20 maxResultSize: 4095
01/05/2013 17:10:20 Result size: 22
01/05/2013 17:10:20 Result: "1/5/2013 10:10:20 PM"
01/05/2013 17:10:20 function: Arma2NETMySQL ['arma','UpdatePlayer','tsc=any,tpos=8263.11|2124.25|0.00143433,tdam=0,tdhe=any,tdbo=any,tdha=any,tdle=any,tdir=333.24,tsta=Stand,tsid=any,tveh=any,tsea=,ttyp=US_Delta_Force_EP1,trat=0,tvd=any,ttd=any,tran=any,tfir=any,tek=any,tck=any,tfk=any,tsui=any,tlif=ALIVE,tdea=any,ttp=any,tlc=any,tld="1/5/2013 10:10:20 PM",tpid=5756102,tna=Diesel,tmid=any']
01/05/2013 17:10:20 maxResultSize: 4095
01/05/2013 17:10:20 Result size: 13
01/05/2013 17:10:20 Result: [[["Error"]]]
01/05/2013 17:10:21 function: Arma2NETMySQL ['arma','UpdatePlayerWeapons','twea="SCAR_H_CQC_CCO"|"NVGoggles"|"Binocular_Vector"|"M9"|"ItemMap"|"ItemCompass"|"ItemWatch"|"ItemRadio"|"ItemGPS",tmag="20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"20Rnd_762x51_B_SCAR"|"HandGrenade_West"|"HandGrenade_West"|"IR_Strobe_Target"|"SmokeShellRed"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9"|"15Rnd_9x19_M9",trck=US_Backpack_Specops_EP1,trwe=[]|[],trma=["1Rnd_HE_M203"|"1Rnd_SmokeRed_M203"|"PipeBomb"|"HandGrenade_West"|"SmokeShellRed"|"Laserbatteries"|"IR_Strobe_Target"]|[2|2|1|2|2|1|1],tpid=5756102,tna=Diesel,tmid=any']
01/05/2013 17:10:21 maxResultSize: 4095
01/05/2013 17:10:21 Result size: 13
01/05/2013 17:10:21 Result: [[["Error"]]]

Share this post

Link to post
Share on other sites

GhostSniper    28

GhostSniper
Posted

diesol,

I do not know if your problem will be solved by following this tip, but my problem was similar to yours, when I tried to install the new version of MSO and decided as follows:

The username that has write access to the database "arma" in mysql should be arma

PS: sorry my english, but do not dominate the language and use the google translator

[]'s

Share this post

Link to post
Share on other sites

Jest    10

Jest
Posted

I'm interested in the sqlite option, but I'm having trouble creating a sqlite.db database with the proper tables and procedures. I've tried a few mysql to sqlite converters but have not had any luck getting the included .sql file to work when creating an sqlite database from it. Could a working sqlite db be provided, or further instructions on how to make one? I may just be going at it all wrong.

Share this post

Link to post
Share on other sites

firefly2442    6

firefly2442
Posted
I'm interested in the sqlite option, but I'm having trouble creating a sqlite.db database with the proper tables and procedures. I've tried a few mysql to sqlite converters but have not had any luck getting the included .sql file to work when creating an sqlite database from it. Could a working sqlite db be provided, or further instructions on how to make one? I may just be going at it all wrong.

While PDB development has ceased, yes, and yes. I'll be providing one as part of the plugin example mission:

https://github.com/firefly2442/Arma2NetMySQLPlugin-ExampleMission

There's a separate thread on the forums here that you can follow:

http://forums.bistudio.com/showthread.php?128795-Arma2MySQL

I'm tied up for a few days but when I get back, the last parts will be improving the documentation and adding the sqlite database. This tool was what I used to create the sqlite database:

https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

Hope this helps.

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  
Followers 0
Go To Topic Listing ARMA 2 & OA : MISSIONS - Editing & Scripting
×