Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by bonster*:

 

hi have this plug in and it was working fine until yesterday have spoke to my provider and the keep telling me to speak with you guys so here is the error message I'm getting

 

15:03:20 75] [statslogger]Error: SQLQuery:

[15:03:20 75] Message: Unknown column 'tsp.PlayerID' in 'on clause'

[15:03:20 75] Native: -2147467259

[15:03:20 75] Source: MySql.Data

[15:03:20 75] StackTrace: bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bei MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

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

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

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

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

bei MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataR eader(CommandBehavior behavior)

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

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

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

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

bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[15:03:20 75] [statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[15:03:23 52] [AdKats] EXCEPTION-7010-D-FetchPlayer-PlayerListing11: [Error while fetching player.][MySql.Data.MySqlClient.MySqlException: Unknown column 'tbl_server_player.PlayerID' in 'where clause'

bei PRoConEvents.AdKats.SafeExecuteReader(MySqlCommand command)

 

 

if any one could point me in the right direction I wold be grateful

[ImportBot]

Originally Posted by ty_ger07*:

 

A PlayerID column is missing from a table? That's bad. It sounds like a corruption issue. Do you have a recent backup you can fall back on? Or, have you attempted CHECK TABLE or REPAIR TABLE SQL query commands against the database using phpMyAdmin or some similar SQL utility environment?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

hi have this plug in and it was working fine until yesterday have spoke to my provider and the keep telling me to speak with you guys so here is the error message I'm getting

 

15:03:20 75] [statslogger]Error: SQLQuery:

[15:03:20 75] Message: Unknown column 'tsp.PlayerID' in 'on clause'

[15:03:20 75] Native: -2147467259

[15:03:20 75] Source: MySql.Data

[15:03:20 75] StackTrace: bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bei MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

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

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

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

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

bei MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataR eader(CommandBehavior behavior)

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

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

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

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

bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[15:03:20 75] [statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[15:03:23 52] [AdKats] EXCEPTION-7010-D-FetchPlayer-PlayerListing11: [Error while fetching player.][MySql.Data.MySqlClient.MySqlException: Unknown column 'tbl_server_player.PlayerID' in 'where clause'

bei PRoConEvents.AdKats.SafeExecuteReader(MySqlCommand command)

 

 

if any one could point me in the right direction I wold be grateful

Also, if you are just setting this up for the first time i would suggest NOT modifying the names of the tables from their defaults. It can cause some compatibility issues with other plugins if you ever install them and they are expecting to interface with stat logger.

[ImportBot]

Originally Posted by Devis*:

 

Hi, I installed this plugin on the game server Bad Company 2, connected the mysql database. tbl_currentplayers filled. But tbl_weapons_stats is not filled.

plugin1.jpg

plugin2.jpg

BFBC2.def file with all the weapons.

Why tbl_weapons_stats is not filled?

[ImportBot]

Originally Posted by KiTiTy*:

 

what is SQL database, do i need to rent another server for this?

 

im confused, can someone help me get this requirement for installation?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

what is SQL database, do i need to rent another server for this?

 

im confused, can someone help me get this requirement for installation?

You should be able to get one through your server host, or your procon host. A database is basically a fast way for programs to store their data without using clunky files/folders. You connect to a database and have that store your data. This is what the stat logger and AdKats plugins, along with a few others, use to store their information.

 

Your host should have a relatively cheap option for you. Be careful of free options though, because they are usually very limited and might sell your data off to other people. That would be an issue security-wise because player IP addresses are stored by this plugin.

 

If you have a computer that's always online you can set up your own MySQL database, since the software itself is free, but that's more complicated to set up. Requires static IPs, possibly some port forwarding on your router, among other things.

[ImportBot]

Originally Posted by skepmeister*:

 

Hi,

Having a lot of fun playing around with this plugin. Looks great.

I am looking at the weapon stats, top10 {weapon} works a treat, but stats {weapon} gives me my kills etc and says I am no.1 rank with {weapon} [famas] is my real world example. I am not actually in the top10 for the [famas].

Any Ideas?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Hi,

Having a lot of fun playing around with this plugin. Looks great.

I am looking at the weapon stats, top10 {weapon} works a treat, but stats {weapon} gives me my kills etc and says I am no.1 rank with {weapon} [famas] is my real world example. I am not actually in the top10 for the [famas].

Any Ideas?

Stats with this plugin are local to your server only, not the entire world. For world stats just look up your player on battlelog. So for your server specifically you're the one most using the famas.

[ImportBot]

Originally Posted by skepmeister*:

 

Stats with this plugin are local to your server only, not the entire world. For world stats just look up your player on battlelog. So for your server specifically you're the one most using the famas.

Hi.

I meant all on my server.

I am not in the !top10 for famas on my server, but !stats famas tells me no.1 for my server. Something strange going on.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Hi.

I meant all on my server.

I am not in the !top10 for famas on my server, but !stats famas tells me no.1 for my server. Something strange going on.

Oh, it just hasn't updated the ranks yet. It doesn't update ranks as fast as everything else because it's a more expensive operation. I forget how often it does that. It might be a setting but it's been a long time since i looked at this plugin.

[ImportBot]

Originally Posted by skepmeister*:

 

Thanks for your quick replies.

It has been that way for about a week. So not sure.

[ImportBot]

Originally Posted by skepmeister*:

 

I changed the option --> overall ranking (merged server ranking) to on and now it shows the correct ranking for my famas (no.17 rank).

I change it back and it shows I am no.1 rank. Is that how it should work? doesn't sound right

[ImportBot]

Originally Posted by ColColonCleaner*:

 

I changed the option --> overall ranking (merged server ranking) to on and now it shows the correct ranking for my famas (no.17 rank).

I change it back and it shows I am no.1 rank. Is that how it should work? doesn't sound right

Seems like a bug, yes. However the chances of a bug being fixed at this point are very low. Glad you found a way that works though.

[ImportBot]

Originally Posted by payver*:

 

Hi,

currently i'm using "CChatGUIDStatsLogger-1.0.0.2-ty_gerMOD-master" and there are 2 threads for Bf3 this thread and showthread....er-1-1-0-1-BF3*. The main reason why i wanted to update is because of the crashes of my server (Procon and Server restart) and i don't know which is the cause. Maybe its already a stable version, maybe i set something wrong, but there is no documentation of the settings? I once deactivated the plugin and turned chatlogging off. Today i saw into phpmyadmin SQL-DB and it was still logging the chat.

 

Is it possible to keep the tables and data and update to a newer version and which do i better use, the version in this thread or in the other BF3 only version?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Hi,

currently i'm using "CChatGUIDStatsLogger-1.0.0.2-ty_gerMOD-master" and there are 2 threads for Bf3 this thread and showthread....er-1-1-0-1-BF3*. The main reason why i wanted to update is because of the crashes of my server (Procon and Server restart) and i don't know which is the cause. Maybe its already a stable version, maybe i set something wrong, but there is no documentation of the settings? I once deactivated the plugin and turned chatlogging off. Today i saw into phpmyadmin SQL-DB and it was still logging the chat.

 

Is it possible to keep the tables and data and update to a newer version and which do i better use, the version in this thread or in the other BF3 only version?

Do not use the one from the BF3 thread. Update to the latest version in this thread which is 1.0.0.3.

[ImportBot]

Originally Posted by payver*:

 

Ok thank you ColColonCleaner.

 

Edit: Is there a solution to migrate the current database (simple stats without weaponstats, mapstats, sessionstats)?

[ImportBot]

Originally Posted by Gam3R*:

 

Yea that is what I use. Infact downloaded it again and tried but same error.

Still doesn't work

 

P.S : I was off all these days.

Here is the post where it ended

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry46617

 

And seems like someone else also couldn't get this to work with BFBC2

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry46631

[ImportBot]

Originally Posted by xloneshadowx*:

 

So I am running a contest in my server for the top 5 !rank players. When I go to the database all I need to clear is the rank table or should I do player stats as well? I am also planning on saving the ranks and stats to put back in after the contest.

[ImportBot]

Originally Posted by ty_ger07*:

 

Clearing the ranks table wouldn't reset their ranks. The ranks table would just rebuild back to what it is.

 

I THINK:

1)If your contest is based on score, you would have to stop the plugin, back up the data (I assume that you would want to), set every player's score to 0, clear the ranks table, and then start the plugin over again.

 

2)Then, after the contest is over, stop the plugin, restore the backup, and start the plugin again. You could also try adding the month's score per player onto the backup's score per player to keep the running total, but that gets tricky and you would want to create an intermediary database or intermediary table to do so.

 

But, the most sure method is to run the contest in a separate database. And not try to reuse any data from before the contest and not try to merge any data after the contest.

 

Alternatively, you could rent a second layer server and connect it to the same game server, and get a second database and run the contest on the second layer server and separate database while the original layer server and database continued to update the stats quietly in the background. You would need to temporarily disable all commands on the original layer server in order to not see duplicate messages in the game. But would the game server suffer performance issues from having two layer servers connected to it simultaneously? Maybe.

 

 

I am sure that someone else may have better ideas.

[ImportBot]

Originally Posted by xloneshadowx*:

 

I have Three servers and right now right everything off of one database the contest is happening on a server where the database is empty so yeah I could just do that. But I think the safest bet is the first option. Thanks

[ImportBot]

Originally Posted by kot163*:

 

Hi! Help guys! I have error. I want run this plugin on BC2 server

Code:

[23:24:32 56] <span style="font-family: Arial Black">PRoCon Chat, GUID and Stats Logger Enabled</span>
[23:24:32 56] <span style="font-family: Arial Black">PRoCon Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player</span>
[23:25:09 65] [Statslogger]Error: SQLQuery:System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
   at System.Guid..ctor(String g)
   at MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal)
   at MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject)
   at MySql.Data.MySqlClient.ResultSet.ReadColumnData(Boolean outputParms)
   at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlDataReader.Read()
   at MySql.Data.MySqlClient.Driver.LoadCharacterSets(MySqlConnection connection)
   at MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet 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.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)
[23:25:09 89] [Statslogger]Error: SQLQuery:System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
   at System.Guid..ctor(String g)
   at MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal)
   at MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject)
   at MySql.Data.MySqlClient.ResultSet.ReadColumnData(Boolean outputParms)
   at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlDataReader.Read()
   at MySql.Data.MySqlClient.Driver.LoadCharacterSets(MySqlConnection connection)
   at MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet 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.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)

[ImportBot]

Originally Posted by Gam3R*:

 

Forget it, doesnt seem to work for BC2

[ImportBot]

Originally Posted by xloneshadowx*:

 

Ok, this weird. So when someone hits !stats in-game there stats are not corrected the number one guy is like rank 11245. But if you hit !top10 they show the correct stats for the players also the stats website shows correct numbers. I reset procons and everything checked the database and everything is correct. but typing !stats or !rank is showing something completly different. Anyone have this happen before

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Ok, this weird. So when someone hits !stats in-game there stats are not corrected the number one guy is like rank 11245. But if you hit !top10 they show the correct stats for the players also the stats website shows correct numbers. I reset procons and everything checked the database and everything is correct. but typing !stats or !rank is showing something completly different. Anyone have this happen before

Um, do you have another service running stats? Like another system like game.me or anything else? If it's the same plugin then i would expect the same data to be across both commands.

[ImportBot]

Originally Posted by xloneshadowx*:

 

Um, do you have another service running stats? Like another system like game.me or anything else? If it's the same plugin then i would expect the same data to be across both commands.

ok so it's only for the top 2 players it shows im third and when i hit !rank it shows me 3rd.. so something is messed up for the top 2 people. but when you type !top 10 it shows them at #1 and #2 and the server stats website shows the correct data. No i have nothing else running stats this is just weird

[ImportBot]

Originally Posted by ColColonCleaner*:

 

ok so it's only for the top 2 players it shows im third and when i hit !rank it shows me 3rd.. so something is messed up for the top 2 people. but when you type !top 10 it shows them at #1 and #2 and the server stats website shows the correct data. No i have nothing else running stats this is just weird

Yeah I haven't heard of this happening before, that's weird. What ranks does it show for the two erroring players?

[ImportBot]

Originally Posted by xloneshadowx*:

 

somewhere in the one thousands

[ImportBot]

Originally Posted by ColColonCleaner*:

 

somewhere in the one thousands

No idea. Since this is only an issue with these two players and they can use !top10 so see their rank anyway i'd suggest just telling them to do that. I'm not sure what it could be.

[ImportBot]

Originally Posted by xloneshadowx*:

 

Yeah that's what i told them ok. thanks

[ImportBot]

Originally Posted by payver*:

 

Hi,

1) i'm getting this error. I started tracing but its only 1 error line and sometimes happens (3 times yesterday) on mapchange.

[statslogger]Error: getUpdateServerID1: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

 

And sometimes in the trace log i see these messages:

2) - [statslogger]Trace: is not in Cache!(empty GUID_)

3) - [statslogger]Trace: Weapon: FreeFall is missing in the BF3.def file!!!

4) - [statslogger]Trace: playerLeftServer: playernamehidden not in session dic

 

I once installed everything new, also deleted whole database and created new. When i installed the plugins, started Procon, closed Procon, overwrote the old configuration files of the plugins (CChatGUIDStatsLogger.cfg etc.) and started Procon again. Is it a wrong way to do? Some complications with dll files ( i have no clue whats in there if static or dynamic infos)?

 

Edit: I compared now the former (no errors) and the recent DB. The recent database has collation (german Kollation, i don't know in english) "utf8_general_ci" and the old one "latin1_swedish_ci". Could this the reason?

But beside that the statslogging is working and the requests (!rank, !top10) are working.

 

Edit2: It was the option Livescoreboard. Maybe that error can be ignored(_).