Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by EBassie*:

 

Hey XP,

 

started testing the plugin on a new database.

But after a short while I came across this error:

 

Code:

Error: Error in Startstreaming: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

This error results in missing playerstats records.

 

 

Edit: Oops... just see this was already reported a couple of posts back. My bad.

[ImportBot]

Originally Posted by mase*:

 

hey guys, i'm completly new to all that mysql stuff. wanted to use this plugin with AdKats, but as soon as i enable it i get the following errors.

 

[16:45:40 26] Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlTrace" hat eine Ausnahme verursacht. ---> System.TypeLoadException: Der Typ "MySql.Data.MySqlClient.MySqlClientPermission" in der Assembly "MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" konnte nicht geladen werden.

bei MySql.Data.MySqlClient.MySqlTrace..cctor()

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:45:40 26] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:45:49 01] PRoCon Chat, GUID and Stats Logger Disabled

[16:45:51 81] Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlTrace" hat eine Ausnahme verursacht. ---> System.TypeLoadException: Der Typ "MySql.Data.MySqlClient.MySqlClientPermission" in der Assembly "MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" konnte nicht geladen werden.

bei MySql.Data.MySqlClient.MySqlTrace..cctor()

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:45:51 81] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:45:51 81] Error: getUpdateServerID1: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlTrace" hat eine Ausnahme verursacht. ---> System.TypeLoadException: Der Typ "MySql.Data.MySqlClient.MySqlClientPermission" in der Assembly "MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" konnte nicht geladen werden.

bei MySql.Data.MySqlClient.MySqlTrace..cctor()

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

i guess it has something to do with the login to the database, but since i dunno shit about that all it would be great if someone could help me out

[ImportBot]

Originally Posted by XpKiller*:

 

Please check if you sandbox is enabled.

 

edit:

it seems this could be a general procon bug:

https://github.com/Myrcon/Procon-1/issues/25

[ImportBot]

Originally Posted by mase*:

 

Please check if you sandbox is enabled.

 

edit:

it seems this could be a general procon bug:

https://github.com/Myrcon/Procon-1/issues/25

guess i need to ask my host about that. or can i check it on my own? i guess that sandbox should be disabled?

[ImportBot]

Originally Posted by XpKiller*:

 

yes if the sandbox is disabled the bug should not occur.

[ImportBot]

Originally Posted by mase*:

 

yes if the sandbox is disabled the bug should not occur.

guess it's going to be hard to get my host disableing the sandbox

will give it a try...thx for your answers!

[ImportBot]

Originally Posted by ColColonCleaner*:

 

@XpKiller where do i need to post my replies so you don't miss them?

[ImportBot]

Originally Posted by Jamesonp*:

 

Can't get the plugin to load. Tried existing database got the gameID error. Tried a blank new DB and crashed with this:

 

 

Attached Files:

• 1GMwf3h.jpg

[ImportBot]

Originally Posted by Fschjg261*:

 

Can't get the plugin to load. Tried existing database got the gameID error. Tried a blank new DB and crashed with this:

 

i got same error.

[ImportBot]

Originally Posted by Ralphvd*:

 

I got new error to:

 

On opening procon on my own pc:

[12:42:47 80] Error: Error in Startstreaming:

[12:42:47 82] Message: Cannot add or update a child row: a foreign key constraint fails (`bf4stats`.`tbl_sessions`, CONSTRAINT `tbl_sessions_ibfk_1` FOREIGN KEY (`StatsID`) REFERENCES `tbl_server_player` (`StatsID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[12:42:47 82] Native: -2147467259

[12:42:47 82] Source: MySql.Data

[12:42:47 83] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& 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.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

[12:42:48 03] Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

 

after some min:

[12:42:48 03] Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

 

 

[12:43:43 39] Error: getUpdateServerID1: System.InvalidOperationException: Nested transactions are not supported.

at MySql.Data.MySqlClient.ExceptionInterceptor.Throw( Exception exception)

at MySql.Data.MySqlClient.MySqlConnection.BeginTransa ction(IsolationLevel iso)

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

 

But so far i can see ingame, everything still working

[ImportBot]

Originally Posted by MarcoV1980*:

 

I Can't seem to get it to work on 3 servers at all.

 

2 of them use a different id, but the 3rd server, just keeps using the first. Does the plugin take the ports properly into account?

[ImportBot]

Originally Posted by XpKiller*:

 

It recommend to update due the many bugfixes.

Download in first post.

 

Changelog:

 

1.0.0.1

Bugfixes for value too long for column errors.

Bugfixes for some other bugs

Changed deprecated Tracemessages

Added an error prefix in pluginlog

New feature: Tickets/teamscores are now tracked in tbl_teamscores

New feature: Simple Stats (collects playerdata only)

New feature: Switch for disabling weaponstats

[ImportBot]

Originally Posted by KennyR*:

 

I updated to the latest update! No problems so far, thanks!

 

Edit:

Why does it creates 4x serverID 2?

http://i.imgur.com/4qE4IQo.png

[ImportBot]

Originally Posted by XpKiller*:

 

I updated to the latest update! No problems so far, thanks!

 

Edit:

Why does it creates 4x serverID 2?

http://i.imgur.com/4qE4IQo.png

it depends on the game mode which running.

ServerID and TeamID together is the primary key.

 

In Conquest mode you will have two entries per server (TeamID 1 and 2).

In Squaddeathmatch you will get 4 entries per server (TeamID 1 , 2, 3 and 4).

[ImportBot]

Originally Posted by Mavy*:

 

Did you add C3's chatlog changes?

[ImportBot]

Originally Posted by Narf!*:

 

Anyone at G-Portal with this plugin? If yes, pls PM me.

[ImportBot]

Originally Posted by mase*:

 

anyone got this working with gamed!de?

[ImportBot]

Originally Posted by ErichKlobecke*:

 

Hi mase

For me its not working with gamed!.de. Got the "PublicKeyToken" Error. Wrote a Ticket to gamed and became the answer that it seems there is a bug in Procon. They are in conversation with the developer and they are waiting for a Patch in the next few Days. At the moment it was only running local.

 

"Aktuell scheint es einen Bug in der neuen ProCon Version zu geben. Nach Rücksprache mit den Entwicklern gibt es ein Rechte Problem, wodurch Plugins mit Zugriffe auf MySQL Datenbanken unterbunden werden. Dieses Problem tritt jedoch nur in einer geschützten Server Umgebung aus.

Wir erwarten daher einen Patch in den nächsten Tagen, aktuell werden diese Plugins leider tatsächlich nur auf Ihrem Lokalem PC funktionieren."

[ImportBot]

Originally Posted by KennyR*:

 

All these http://www.teamfrostbite.com/servers/ servers run on Gamed!de

 

Edit; i run procon @ home, not on gamed!de itself.

[ImportBot]

Originally Posted by mase*:

 

Hi mase

For me its not working with gamed!.de. Got the "PublicKeyToken" Error. Wrote a Ticket to gamed and became the answer that it seems there is a bug in Procon. They are in conversation with the developer and they are waiting for a Patch in the next few Days. At the moment it was only running local.

 

"Aktuell scheint es einen Bug in der neuen ProCon Version zu geben. Nach Rücksprache mit den Entwicklern gibt es ein Rechte Problem, wodurch Plugins mit Zugriffe auf MySQL Datenbanken unterbunden werden. Dieses Problem tritt jedoch nur in einer geschützten Server Umgebung aus.

Wir erwarten daher einen Patch in den nächsten Tagen, aktuell werden diese Plugins leider tatsächlich nur auf Ihrem Lokalem PC funktionieren."

ok, thanks for that one!

[ImportBot]

Originally Posted by supermillhouse*:

 

Just noticed a date bugs in the mapstats table

 

Any thoughts_?

 

0001-01-01 00:00:00

 

Initially thought they were because of the round warm-up but it has happened a couple of full rounds where server population was 60 odd

 

date errors.png

 

Another thought, do we no longer need the weapon keylist anymore?

[ImportBot]

Originally Posted by XpKiller*:

 

Just noticed a date bugs in the mapstats table

 

Any thoughts_?

 

0001-01-01 00:00:00

 

Initially thought they were because of the round warm-up but it has happened a couple of full rounds where server population was 60 odd

 

date errors.png

 

Another thought, do we no longer need the weapon keylist anymore?

regarding mapstats:

 

everything is fine. Those entries mean that the round has not started, due too less players.

 

The weaponkey list is for alternate weaponnames for ingame commands.

[ImportBot]

Originally Posted by p19blo*:

 

getting this error which is new

 

InnerException: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

[ImportBot]

Originally Posted by Tischi*:

 

I got the error:

 

[statslogger]Error: getUpdateServerID1: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.TypeLoadException: Der Typ "MySql.Data.MySqlClient.MySqlClientPermission" in der Assembly "MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" konnte nicht geladen werden.

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by XpKiller*:

 

@p19blo

Well this appears if your mysql server is not responding. So is this no bug of the plugin.

 

@Tischi

Try to disable the procon sandbox.

This is caused by a bug in procon:

https://github.com/Myrcon/Procon-1/issues/25

 

So unfortunately i cant fix that.

[ImportBot]

Originally Posted by Tischi*:

 

@Tischi

Try to disable the procon sandbox.

This is caused by a bug in procon:

https://github.com/Myrcon/Procon-1/issues/25

 

So unfortunately i cant fix that.

i already disabled this

procon.PNG

[ImportBot]

Originally Posted by XpKiller*:

 

i already disabled this

procon.PNG

you cannot disabled the sandbox via your client. This setting is for your client only.

You need to manually edit your procon.cfg on your layerserver.

[ImportBot]

Originally Posted by Rcon-Admin*:

 

Just found this as well so I'm really not sure where the fault (bug) lies;

https://github.com/Myrcon/Procon-1/issues/25

 

Very many thanks and kind regards

Rcon-Admin.

[ImportBot]

Originally Posted by XpKiller*:

 

Hi guys,

 

Absolutely NO disrespect to you - XpKiller, but this plugin literally brought our hosting server down.

It flooded MYSQL and brought it to a standstill, then it borked something in the network.

 

I advised our client about the issue and he immediately agreed that it was deemed necessary to shut the plugin off.

Within minutes of installing it and activating it, we had hundreds/thousands of lines of errors which eventually caused the parent layer - hosted with us - to crash.

 

It also killed MYSQL and then finally the network.

 

How many requests does this plugin require?

I believe it attempted so many it flooded us out.

 

Also, what are the exact requirements for it?

 

We tried it sandbox on and off, and the errors were heavy, consistent and really caused an issue.

 

Due to the very fact that it DID bring my server to a standstill, upsetting a LOT of clients,

I do not recommend that this plugin should be available to be downloaded in order for every day use that then is run from parent layers.

 

It's very unstable

 

Absolutely no disrespect meant here, the work you do XpKiller is excellent, but this plugin needs a LOT more development to be released to the general public.

 

It's simply too unstable right now.

 

I hope that you don't become offended by this post of ours - but after discussing it with the client, we both agreed that it is essential to bring this to your attention, as it will help the development of your plugins further.

 

Very many thanks and kind regards

Rcon-Admin.

 

EDIT;

Just found this as well so I'm really not sure where the fault (bug) lies but it is a big one;

https://github.com/Myrcon/Procon-1/issues/25

@Rcon-Admin

 

i cant fix bugs, which dont occur in my test. Basically i dont get any layercrash during my testing yet.

 

So if there are some many errors where are the reports?

 

EDIT;

Just found this as well so I'm really not sure where the fault (bug) lies but it is a big one;

https://github.com/Myrcon/Procon-1/issues/25

this is NOT caused by the plugin itself. It seems a bug in procon, which i cant fix in my plugin code. Because the bug dont lies in the plugin code. So dont blame me for bug i cant fix.

 

It also killed MYSQL and then finally the network.

 

How many requests does this plugin require?

I believe it attempted so many it flooded us out.

i cant believe that since th plugin is using connection pooling to limit the active connections to the mysql server.

I would say your mysql server is not configured very well or your are using insane high values for the connection pool.

[ImportBot]

Originally Posted by Rcon-Admin*:

 

@ Morpheus - thank you for sharing this information, as you can imagine the recent issues have caused a problem, and I for one am looking forward to hearing how you get on with this and how the patch/remedy goes.

 

Many thanks