Chat, GUID, Stats and Mapstats Logger[1.1.0.1][BF3]

[ImportBot]

Originally Posted by Ghostryder81*:

 

Updated to 0.0.0.7beta and now got this error (before 0.0.0.7beta it worked fine).

 

[15:32:32 49] Error: Error in Startstreaming: System.InvalidOperationException: ExecuteNonQuery erfordert, dass der Befehl über eine Transaktion verfügt, wenn die dem Befehl zugewiesene Verbindung eine ausstehende lokale Verbindung ist. Die Transaction-Eigenschaft des Befehls wurde nicht initialisiert.

bei System.Data.Odbc.OdbcConnection.SetStateExecuting( String method, OdbcTransaction transaction)

bei System.Data.Odbc.OdbcCommand.ValidateConnectionAnd Transaction(String method)

bei System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

bei System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

bei System.Data.Odbc.OdbcCommand.ExecuteNonQuery()

bei PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

[15:32:44 52] Error: Error in Startstreaming: System.InvalidOperationException: OdbcTransaction wurde beendet und kann nicht mehr verwendet werden.

bei System.Data.Odbc.OdbcTransaction.Commit()

bei PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

 

 

UPDATE: Now its working without error. Dont know why

[ImportBot]

Originally Posted by XpKiller*:

 

@Ghostryder81

 

I didnt got such errors during testing.

[ImportBot]

Originally Posted by Clay52*:

 

Btw can you verify if we're to use the bf3.def file you link to at top of first post or the one in the plugin zip file? Thanks.

[ImportBot]

Originally Posted by Clay52*:

 

I just got this:

 

[11:59:01 29] Error: SQLQuery:System.NullReferenceException: Object reference not set to an instance of an object.

at System.Data.Odbc.OdbcDataReader.GetRowCount()

at System.Data.Odbc.OdbcDataReader.FirstResult()

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)

at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[11:59:10 58] [insane Balancer] check state started 12/6/2011 11:59:02 AM

[11:59:10 59] [insane Balancer] check state phase-0 started 12/6/2011 11:59:02 AM

[11:59:10 59] [insane Balancer] Requesting player list

[11:59:12 33] [insane Balancer] check state phase-1 started 12/6/2011 11:59:02 AM

[11:59:12 34] [insane Balancer] Teams are balanced, going to wait state

[11:59:12 35] [insane Balancer] wait state re-started 12/6/2011 11:59:03 AM

[11:59:12 72] Error: SQLQuery:System.NullReferenceException: Object reference not set to an instance of an object.

at System.Data.Odbc.OdbcDataReader.GetRowCount()

at System.Data.Odbc.OdbcDataReader.FirstResult()

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)

at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[11:59:15 20] Error: SQLQuery:System.NullReferenceException: Object reference not set to an instance of an object.

at System.Data.Odbc.OdbcDataReader.GetRowCount()

at System.Data.Odbc.OdbcDataReader.FirstResult()

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)

at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[11:59:15 44] Error: Error in Startstreaming:

[11:59:15 45] Index #0

[11:59:15 45] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56]Duplicate entry 'EA_FA0DBEE07F0BF13ADB15770AE220C3C8' for key 'UNIQUE_playerdata'

[11:59:15 45] Native: 1062

[11:59:15 46] Source: myodbc5.dll

[11:59:15 46] SQL: 23000

[ImportBot]

Originally Posted by Clay52*:

 

Overall It seems to be working but wtf is causing this error? Very annoying...

[ImportBot]

Originally Posted by XpKiller*:

 

Overall It seems to be working but wtf is causing this error? Very annoying...

unfortunately i cant reproduce this error. (actually i have never such an error)

 

Im not sure if have already posted your specs like Mysql Server version if it is a local or remote db.

 

If possible try out if this error occurs with a new db.

 

I have the feeling that this error is causes by unexpected behavior of the DB.

[ImportBot]

Originally Posted by EBassie*:

 

Hey XpKiller,

 

Just a quick question:

When a player leaves before a round is finished, are his stats still saved?

And what with players who enter the server half way the round?

 

Still searching an answer why stats of some players are not saved.

[ImportBot]

Originally Posted by XpKiller*:

 

Hey XpKiller,

 

Just a quick question:

When a player leaves before a round is finished, are his stats still saved?

And what with players who enter the server half way the round?

 

Still searching an answer why stats of some players are not saved.

Yes their stats are saved.

[ImportBot]

Originally Posted by EBassie*:

 

Yes their stats are saved.

Hmmz... Then I'm still bugged somehow..

Have you seen my traces I posted a page back?

 

Are you willing to take a look at them to see if there is anything wrong with it?

I would really appreciate it.

[ImportBot]

Originally Posted by XpKiller*:

 

@EBastard

 

i looked trough the trace files and found something.

My Plugin needs the eaguid to check if a player is in the database. The the eaguid is null the plugin skips this player. Because the data inside the db would get inconsistent so the plugin skips the Player.

Some time around 20% of the players get skip.

it seems that this is a problem, which causes wrong stats/no update on stats.

I need to look at the process when the eaguid is stored. for me it seems the game server or procon report no eaguid of some player.

 

Thank for the trace-files!

I will increase the trace level in the next version a little bit to find more errors.

 

Edit:

Possible Solution for this Problem:

Adding a check which prevent that a already store eaguid gets overwritten by an empty string.

[ImportBot]

Originally Posted by Legate*:

 

The new version solved my problem

 

Thanks Xpkiller ;-)

[ImportBot]

Originally Posted by CptChaos*:

 

XPKiller, you gave this query, to see which soldiers have a kdr higher than 3. But it gives it results per server. Is there a way to have such thing return it globally? I am admin of 7 servers (total), and am interested in a global kdr higher than 3.

 

The query you gave was like:Code:

SELECT tpd.PlayerID AS PlayerID, tpd.SoldierName AS SoldierName, tps.Score AS Score, tps.Kills AS Kills, tps.Deaths AS Deaths, (tps.Kills/tps.Deaths) AS KDR, tps.Headshots AS Headshots, (tps.Headshots/tps.Kills * 100) AS HeadPerc ,tps.Suicide AS Suicide, tps.TKs AS TKs, tps.Playtime AS Playtime, (Playtime / 3600) AS Hours, tps.Rounds AS Rounds, tps.Killstreak AS Killstr, tps.Deathstreak AS Deathstr 
FROM tbl_playerstats tps 
INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
WHERE (tps.Kills/tps.Deaths) >= 3 AND (tps.Headshots/tps.Kills) >= 0.5 AND tps.Killstreak >= 10 AND tps.Rounds >= 2
ORDER BY KDR DESC

I've modded it already slightly, but my MySQL knowledge is lacking me.

I tried to sum some stuff, but din't seem to work and gave one row in return.

[ImportBot]

Originally Posted by XpKiller*:

 

@CptChaos

 

For such a kind of Query you need to use "HAVING" instead of "WHERE".

The where condition can not handle aggregated Field( SUM(), MAX()...).

 

Code:

SELECT tpd.PlayerID AS PlayerID, tpd.SoldierName AS SoldierName, SUM(tps.Score )AS Score, SUM(tps.Kills) AS Kills, SUM(tps.Deaths) AS Deaths, (SUM(tps.Kills)/SUM(tps.Deaths)) AS KDR, SUM( tps.Headshots) AS  Headshots, (SUM(tps.Headshots)/SUM(tps.Kills) * 100) AS HeadPerc ,SUM(tps.Suicide) AS Suicide,  SUM(tps.TKs) AS TKs,  SUM(tps.Playtime) AS Playtime, ( SUM(tps.Playtime) / 3600) AS Hours, SUM(tps.Rounds) AS Rounds, MAX(tps.Killstreak) AS Killstr, MAX(tps.Deathstreak) AS Deathstr 
FROM tbl_playerstats tps 
INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID
INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
GROUP BY PlayerID
HAVING  (SUM(tps.Kills)/SUM(tps.Deaths)) >= 3  AND (SUM(tps.Headshots)/SUM(tps.Kills) )>= 0.5 AND MAX(tps.Killstreak) >= 10 AND SUM(tps.Rounds) >= 2
ORDER BY KDR DESC

[ImportBot]

Originally Posted by EBassie*:

 

@EBastard

 

i looked trough the trace files and found something.

My Plugin needs the eaguid to check if a player is in the database. The the eaguid is null the plugin skips this player. Because the data inside the db would get inconsistent so the plugin skips the Player.

Some time around 20% of the players get skip.

it seems that this is a problem, which causes wrong stats/no update on stats.

I need to look at the process when the eaguid is stored. for me it seems the game server or procon report no eaguid of some player.

 

Thank for the trace-files!

I will increase the trace level in the next version a little bit to find more errors.

 

Edit:

Possible Solution for this Problem:

Adding a check which prevent that a already store eaguid gets overwritten by an empty string.

I'm glad the tracefiles are of any help. Already started to dislike myself with all the nagging

[ImportBot]

Originally Posted by noox163*:

 

Good night!

Sorry for the stupid questions. did everything according to instructions.

to Def. time.

stood on the stage

The database.

I can not figure it must be installed on my home computer or to connect it to.

put MySQL on the link.

writes an error.

 

 

Error: System.Security.SecurityException: ???? ??? ??????? ?????????? ???? "System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

? System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

? System.Security.PermissionSet.Demand()

? System.Data.Common.DbConnectionOptions.DemandPermi ssion()

? System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

? System.Data.Odbc.OdbcConnection.Open()

? PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

??????? ??????????? ????????? ????????:

Demand

??????? ??????????? ?????? ?????????? ?????????? ????:

System.Data.Odbc.OdbcPermission

??????? ??????????? ?????? ?? ????????? ?????????? Zone:

MyComputer

 

I apologize in advance for Broken English

[ImportBot]

Originally Posted by Legate*:

 

Something new (for me):

 

[06:41:17 70] Error: Error in Startstreaming:

[06:41:17 70] Index #0

[06:41:17 70] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.13]Duplicate entry 'EA_D053AE8583CCA60B2D16F*******' for key 'UNIQUE_playerdata'

[06:41:17 71] Native: 1062

[06:41:17 71] Source: myodbc5.dll

[06:41:17 71] SQL: 23000

 

This happens when a player change his nick.

[ImportBot]

Originally Posted by XpKiller*:

 

@Legate

was able to produce such an error today for the first time.

i maybe can find out now what causes this.

[ImportBot]

Originally Posted by Waterboyeee*:

 

Errors after/during map change.

 

 

Error: SQLQuery:System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.

at System.Data.Odbc.OdbcConnection.SetStateExecuting( String method, OdbcTransaction transaction)

at System.Data.Odbc.OdbcCommand.ValidateConnectionAnd Transaction(String method)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)

at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(C ommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(Odbc Command selectQuery)

[ImportBot]

Originally Posted by XpKiller*:

 

@noox163

You need to turn off the proconsandbox or add your MySQL server to the trusted hostlist.

[ImportBot]

Originally Posted by Clay52*:

 

I've had some issues so I started over from scratch but I'm not sure things are working, I'm here at the moment:

 

 

 

I'm not seeing any stats or rank come up for anyone in the greeting.

[ImportBot]

Originally Posted by XpKiller*:

 

On you picture all tables are empty except the tanle tbl_server ,tbl_chatlog.

 

You should get entrys after map switch. The Plugin does not work in realtime( is possible) except for chat logging.

[ImportBot]

Originally Posted by Clay52*:

 

pm sent, I'm lost

[ImportBot]

Originally Posted by Clay52*:

 

Ok I click onto player_stats and get this:

 

[ImportBot]

Originally Posted by Clay52*:

 

I'm trying to follow along with the pics you have posted but I'm lost with how I get to where you are in them.

[ImportBot]

Originally Posted by Clay52*:

 

It' still not giving player server stats etc. upon a join.

[ImportBot]

Originally Posted by GitSum*:

 

Starting to see this error - any ideas?

 

Code:

[15:12:02 00] Error: Error in Startstreaming: System.NullReferenceException: Object reference not set to an instance of an object.
   at System.Data.Odbc.OdbcDataReader.GetRowCount()
   at System.Data.Odbc.OdbcDataReader.FirstResult()
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreaming()

[ImportBot]

Originally Posted by traustic*:

 

Plugin seemed to do its job with a few random failure to communicate with mysql database. Data was recorded and did a table dump for stats just fine. However this plugin also caused continuous server crashes. Disabled the plugin and no more crashes.

[ImportBot]

Originally Posted by ty_ger07*:

 

It' still not giving player server stats etc. upon a join.

I don't get any player welcome stats either. I assumed it was an issue with the PlayerSay functionality being broken by DICE in the latest patches.

[ImportBot]

Originally Posted by XpKiller*:

 

Plugin seemed to do its job with a few random failure to communicate with mysql database. Data was recorded and did a table dump for stats just fine. However this plugin also caused continuous server crashes. Disabled the plugin and no more crashes.

There is nothing wrong with the way the plugin communicate with the

MySQL server. The Problem is caused by the SQL Server which kills connections or don't answer queries c orectly. Those behaviors often found by freesql services because their server limit query count and query execution time. They do this because they want prenvent commercial use.

[ImportBot]

Originally Posted by EBassie*:

 

There is nothing wrong with the way the plugin communicate with the

MySQL server. The Problem is caused by the SQL Server which kills connections or don't answer queries c orectly. Those behaviors often found by freesql services because their server limit query count and query execution time. They do this because they want prenvent commercial use.

Hey XpKiller,

 

we moved our Procon Layer to an offsite Virtual XP, because the server where it used to run had some problems with the VMware install.

But we still use the same MySQL database on the Linux server of the old machine, which runs our clan website.

 

But somehow Procon Layer now crashes more then 5 times a day, until I disabled the plugin.

 

When reading your comment above: Is there something we must change about out MySQL server?