Jump to content

Chat, GUID, Stats and Mapstats Logger [1.0.0.3]


ColColonCleaner

Recommended Posts

Originally Posted by ColColonCleaner*:

 

Its been working fine for me. Make sure you have your sql permissions set to allow connection from a remote host.

 

@XPKiller: Is there a way to prevent the server messages (spambot,balancer,etc) from being logged to the chat log?

Set "Log server spam" to false.
* Restored post. It could be that the author is no longer active.
Link to post
  • Replies 2k
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

Description: This plugin is used to log player chat, player GUID's, player Stats, Weaponstats and Mapstats. This includes: Chat, PBGUID, EAGUID, IP, Stats, Weaponstats, Dogtags, Killstreaks, Country,

This should not happen. Wait for at least one round. If this does not help: Stop PRoCon Delete the config at Configs/IP/StatsLogger..... cfg Start PRoCon Do not modify anyth

Check the value of this field. Set it to 0. Does this help? Do you use AdKats? Not sure if AdKats updates the offset, but AdKats has an option to adjust the logger settings.

Posted Images

Originally Posted by exadmin*:

 

got this errors even though i already updated my bf3.def file to latest bf4.def file

 

[19:41:00 24] Trace: Weapon: U_V40 is missing in the bf3.def file!!!

[19:41:05 17] Trace: Weapon: U_GalilACE52 is missing in the bf3.def file!!!

[19:41:07 56] Trace: Weapon: U_GalilACE52 is missing in the bf3.def file!!!

 

.

Can someone help me on this? The plugin runs fine but it's not logging all weapon kills due to it isn't recognize in the bf3.def file.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

@Mandizzy

seems like a bug. It seems sometimes the country code is longer than 2 chars.

 

I will check those messages too.

 

@alexlive1076

Your PRocon is missing the Mysql.data.dll file or it can not be executed due permission issue.

Your hoster needs to check for that file in the PRoCon dir.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by Narf!*:

 

I've got the same issue like alexlive1076. I've checked if that Mysql.data.dll is there... Yes, it's there. FTP says it has "777". That should be ok this way?

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by exadmin*:

 

@exadmin

these trace messages dont show errors. Please ignore these messages.

Hi bro,

 

I believe stat logging for those weapons isn't recorded. I just did a 2 round with the plugin on and next round it doesnt log the weapon i used at the previous round when i typed !stats because of that log "weapon is missing in BF3.def file"

 

I already copy pasted all the contents of BF4.def file on the BF3.def file but still it says the weapons is missing.

 

UPDATE1: Score is updated but the kills isn't registering with some of the weapons used that is saying it is missing from the BF3.def

 

UPDATE2:I just deleted BF3.def on the procon folder and it still saying it's missing weapons on bf3.def LOL. Can someone check their stats if it's recording as intended?

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by jking54*:

 

Dont get it, how do i connect it to my mysql base on my website ?

Enter your site or domain in the site field, port is 3306, make sure you have the port in your "trusted host/domains" under options in procon, then enter your MySQL password, and your user name and database name
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

I've got the same issue like alexlive1076. I've checked if that Mysql.data.dll is there... Yes, it's there. FTP says it has "777". That should be ok this way?

This file should be in the PRocon root dir and in the plugin dir.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

Hi bro,

 

I believe stat logging for those weapons isn't recorded. I just did a 2 round with the plugin on and next round it doesnt log the weapon i used at the previous round when i typed !stats because of that log "weapon is missing in BF3.def file"

 

I already copy pasted all the contents of BF4.def file on the BF3.def file but still it says the weapons is missing.

 

UPDATE1: Score is updated but the kills isn't registering with some of the weapons used that is saying it is missing from the BF3.def

 

UPDATE2:I just deleted BF3.def on the procon folder and it still saying it's missing weapons on bf3.def LOL. Can someone check their stats if it's recording as intended?

Those bf3.def error are old debug messages i forgot to remove.

 

The plugin is recording stats for weapons known by Procon. Those weapons are in the bf3.def (for bf3) and bf4.def(for bf4).

 

Also note the bf4.def files in not complete yet. The procon devs still looking for missing weaponcodes.

 

You can run the following SQL-command to see which weapons are known by the plugin/procon.

 

Code:

SELECT `tbl_games`.`Name`, tbl_weapons.* FROM tbl_weapons
INNER JOIN tbl_games using (`GameID`);
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

Will this version make the necessary table changes if run on a database previously running the BF3 version of this plugin?

No it will not make those changes. I could provide a script instead if needed.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by Athlon*:

 

^^^

I for one would very much like that script. No rush, I just don't want to lose my stats collected so far on my BF4 server using your BF3 plugin.

 

Thanks for the great work!!

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by ColColonCleaner*:

 

GameID in your playerdata table doesn't have a default value, and throws this:

 

MySql.Data.MySqlClient.MySqlException: Field 'GameID' doesn't have a default value

 

When performing this:

 

SELECT

`PlayerID` as `player_id`,

`SoldierName` as `player_name`,

`EAGUID` as `player_guid`,

`PBGUID` as `player_pbguid`,

`IP_Address` as `player_ip`

FROM `tbl_playerdata`;

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by ColColonCleaner*:

 

^^^

I for one would very much like that script. No rush, I just don't want to lose my stats collected so far on my BF4 server using your BF3 plugin.

 

Thanks for the great work!!

For now we have completely separated our bf4 and bf3 databases. It seems to be running well that way, especially for keeping bans separate between games.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by ColColonCleaner*:

 

@XpKiller

Could you add a prefix to your console log messages so it's clear when a message comes from your plugin?

 

Like this:

[15:52:35 67] [AdKats] ListPlayers ran out of time for TeamSwap. 10 sec.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by tonnic*:

 

See my previous reply, stats are only sent to the database at the end of a round.

Hi ColColonCleaner,

Thanks for the response. The issue is that there have been dozens and dozens of rounds... there is data in the database, but not in the ranks. I have it installed on 2 servers from the same layer host. One of my servers works great, but the other doesn't work. I can see some data in some tables, but it always says that we need to wait a round to see stats.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by exadmin*:

 

Those bf3.def error are old debug messages i forgot to remove.

 

The plugin is recording stats for weapons known by Procon. Those weapons are in the bf3.def (for bf3) and bf4.def(for bf4).

 

Also note the bf4.def files in not complete yet. The procon devs still looking for missing weaponcodes.

 

You can run the following SQL-command to see which weapons are known by the plugin/procon.

 

Code:

SELECT `tbl_games`.`Name`, tbl_weapons.* FROM tbl_weapons
INNER JOIN tbl_games using (`GameID`);
Tried running the code and it fetched only 37 records and when i check the results the gun i used mostly wasn't there and almost 80% of the weapons on the game isn't there, thats why it didn't record.

 

Server is running 8hours of 64players and it should be logging higher than 37 recorded weapons.

 

Is this a bug? Or i need to recreate the database? This is a fresh database btw.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by sourtimer*:

 

First off, thank you for updating this for BF4.

 

It's been a while since I ran this, which was on a BF3 server.

 

I have my SQL server all setup, as well as the plugin in Procon and that all went fine, both running on the same local machine here at home.

 

My question is I seem to remember having to play around with the BF3.DEF file for Procon to get this plugin working properly when I used it in BF3. Do I need to do anything with BF3.DEF or BF4.DEF for the plugin to function correctly ?

 

Thanks

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by ColColonCleaner*:

 

Hi ColColonCleaner,

Thanks for the response. The issue is that there have been dozens and dozens of rounds... there is data in the database, but not in the ranks. I have it installed on 2 servers from the same layer host. One of my servers works great, but the other doesn't work. I can see some data in some tables, but it always says that we need to wait a round to see stats.

There are settings in the logger where you can set whether to store rank/stat information. You probably have that set to false on some of your servers.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by exadmin*:

 

Tried running the code and it fetched only 37 records and when i check the results the gun i used mostly wasn't there and almost 80% of the weapons on the game isn't there, thats why it didn't record.

 

Server is running 8hours of 64players and it should be logging higher than 37 recorded weapons.

 

Is this a bug? Or i need to recreate the database? This is a fresh database btw.

Just an update.

 

I created a new database just to test it out and found out it still it only has 37 weapons mapped. This is the logs.

 

Code:

[10:51:48] PRoCon Chat, GUID and Stats Logger Enabled
[10:51:48] PRoCon Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[10:51:48] Info: Table suffix set to
[10:51:48] Trace: generateWeaponList
[10:51:48] Trace: PrepareKeywordDic: Preparing
[10:51:48] Trace: Weaponlist: DamageType: Suicide Name: DamageArea
[10:51:48] Trace: Weaponlist: DamageType: Suicide Name: SoldierCollision
[10:51:48] Trace: Weaponlist: DamageType: Suicide Name: Suicide
[10:51:48] Trace: Weaponlist: DamageType: None Name: Death
[10:51:48] Trace: Weaponlist: DamageType: None Name: RoadKill
[10:51:48] Trace: Weaponlist: DamageType: Melee Name: Melee
[10:51:48] Trace: Weaponlist: DamageType: Melee Name: U_Repairtool
[10:51:48] Trace: Weaponlist: DamageType: Shotgun Name: U_870
[10:51:48] Trace: Weaponlist: DamageType: Shotgun Name: U_M26Mass
[10:51:48] Trace: Weaponlist: DamageType: Shotgun Name: U_QBS09
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_ACR
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_AK12
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_AK5C
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_MX4
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_RFB
[10:51:48] Trace: Weaponlist: DamageType: AssaultRifle Name: U_SCAR-H
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_AK12_M320_HE
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_FIM92
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_M320_HE
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_MGL
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_RPG7
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_SCAR-H_M26_Buck
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_SCAR-H_M320_HE
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_Starstreak
[10:51:48] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_XM25
[10:51:48] Trace: Weaponlist: DamageType: Explosive Name: U_C4
[10:51:48] Trace: Weaponlist: DamageType: Explosive Name: U_M67
[10:51:48] Trace: Weaponlist: DamageType: SniperRifle Name: U_CS-LR4
[10:51:48] Trace: Weaponlist: DamageType: SniperRifle Name: U_M40A5
[10:51:48] Trace: Weaponlist: DamageType: SniperRifle Name: U_M82A3_MED
[10:51:48] Trace: Weaponlist: DamageType: SniperRifle Name: U_MK11
[10:51:48] Trace: Weaponlist: DamageType: Handgun Name: U_M9
[10:51:48] Trace: Weaponlist: DamageType: Handgun Name: U_P226
[10:51:48] Trace: Weaponlist: DamageType: SMG Name: U_PP2000
[10:51:48] Trace: Weaponlist: DamageType: Nonlethal Name: U_PortableMedicpack
[10:51:49] Trace: Weaponlist: DamageType: LMG Name: U_Type88
[10:51:49] Trace: Weaponlist: DamageType: LMG Name: U_Ultimax
[10:51:51] Trace: getUpdateServerID
[10:51:52] Info: Start tablebuilder
[10:51:52] Trace: generateWeaponList
[10:51:52] Trace: PrepareKeywordDic: Preparing
[10:51:52] Trace: Weaponlist: DamageType: Suicide Name: DamageArea
[10:51:52] Trace: Weaponlist: DamageType: Suicide Name: SoldierCollision
[10:51:52] Trace: Weaponlist: DamageType: Suicide Name: Suicide
[10:51:52] Trace: Weaponlist: DamageType: None Name: Death
[10:51:52] Trace: Weaponlist: DamageType: None Name: RoadKill
[10:51:52] Trace: Weaponlist: DamageType: Melee Name: Melee
[10:51:52] Trace: Weaponlist: DamageType: Melee Name: U_Repairtool
[10:51:52] Trace: Weaponlist: DamageType: Shotgun Name: U_870
[10:51:52] Trace: Weaponlist: DamageType: Shotgun Name: U_M26Mass
[10:51:52] Trace: Weaponlist: DamageType: Shotgun Name: U_QBS09
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_ACR
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_AK12
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_AK5C
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_MX4
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_RFB
[10:51:52] Trace: Weaponlist: DamageType: AssaultRifle Name: U_SCAR-H
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_AK12_M320_HE
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_FIM92
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_M320_HE
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_MGL
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_RPG7
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_SCAR-H_M26_Buck
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_SCAR-H_M320_HE
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_Starstreak
[10:51:52] Trace: Weaponlist: DamageType: ProjectileExplosive Name: U_XM25
[10:51:52] Trace: Weaponlist: DamageType: Explosive Name: U_C4
[10:51:52] Trace: Weaponlist: DamageType: Explosive Name: U_M67
[10:51:52] Trace: Weaponlist: DamageType: SniperRifle Name: U_CS-LR4
[10:51:52] Trace: Weaponlist: DamageType: SniperRifle Name: U_M40A5
[10:51:52] Trace: Weaponlist: DamageType: SniperRifle Name: U_M82A3_MED
[10:51:52] Trace: Weaponlist: DamageType: SniperRifle Name: U_MK11
[10:51:52] Trace: Weaponlist: DamageType: Handgun Name: U_M9
[10:51:52] Trace: Weaponlist: DamageType: Handgun Name: U_P226
[10:51:52] Trace: Weaponlist: DamageType: SMG Name: U_PP2000
[10:51:52] Trace: Weaponlist: DamageType: Nonlethal Name: U_PortableMedicpack
[10:51:52] Trace: Weaponlist: DamageType: LMG Name: U_Type88
[10:51:52] Trace: Weaponlist: DamageType: LMG Name: U_Ultimax
[10:51:52] Trace: GetGameIDfromDB Game: BF4
[10:51:52] Trace: GetGameIDfromDB GameID: 1
[10:51:52] Trace: WeaponMapping: ID: 1 <--> Weapon:DamageArea
[10:51:52] Trace: WeaponMapping: ID: 4 <--> Weapon:Death
[10:51:52] Trace: WeaponMapping: ID: 6 <--> Weapon:Melee
[10:51:52] Trace: WeaponMapping: ID: 5 <--> Weapon:RoadKill
[10:51:52] Trace: WeaponMapping: ID: 2 <--> Weapon:SoldierCollision
[10:51:52] Trace: WeaponMapping: ID: 3 <--> Weapon:Suicide
[10:51:52] Trace: WeaponMapping: ID: 8 <--> Weapon:U_870
[10:51:52] Trace: WeaponMapping: ID: 11 <--> Weapon:U_ACR
[10:51:52] Trace: WeaponMapping: ID: 12 <--> Weapon:U_AK12
[10:51:52] Trace: WeaponMapping: ID: 17 <--> Weapon:U_AK12_M320_HE
[10:51:52] Trace: WeaponMapping: ID: 13 <--> Weapon:U_AK5C
[10:51:52] Trace: WeaponMapping: ID: 26 <--> Weapon:U_C4
[10:51:52] Trace: WeaponMapping: ID: 28 <--> Weapon:U_CS-LR4
[10:51:52] Trace: WeaponMapping: ID: 18 <--> Weapon:U_FIM92
[10:51:52] Trace: WeaponMapping: ID: 9 <--> Weapon:U_M26Mass
[10:51:52] Trace: WeaponMapping: ID: 19 <--> Weapon:U_M320_HE
[10:51:52] Trace: WeaponMapping: ID: 29 <--> Weapon:U_M40A5
[10:51:52] Trace: WeaponMapping: ID: 27 <--> Weapon:U_M67
[10:51:52] Trace: WeaponMapping: ID: 30 <--> Weapon:U_M82A3_MED
[10:51:52] Trace: WeaponMapping: ID: 32 <--> Weapon:U_M9
[10:51:52] Trace: WeaponMapping: ID: 20 <--> Weapon:U_MGL
[10:51:52] Trace: WeaponMapping: ID: 31 <--> Weapon:U_MK11
[10:51:52] Trace: WeaponMapping: ID: 14 <--> Weapon:U_MX4
[10:51:52] Trace: WeaponMapping: ID: 33 <--> Weapon:U_P226
[10:51:52] Trace: WeaponMapping: ID: 35 <--> Weapon:U_PortableMedicpack
[10:51:52] Trace: WeaponMapping: ID: 34 <--> Weapon:U_PP2000
[10:51:52] Trace: WeaponMapping: ID: 10 <--> Weapon:U_QBS09
[10:51:52] Trace: WeaponMapping: ID: 7 <--> Weapon:U_Repairtool
[10:51:52] Trace: WeaponMapping: ID: 15 <--> Weapon:U_RFB
[10:51:52] Trace: WeaponMapping: ID: 21 <--> Weapon:U_RPG7
[10:51:52] Trace: WeaponMapping: ID: 16 <--> Weapon:U_SCAR-H
[10:51:52] Trace: WeaponMapping: ID: 22 <--> Weapon:U_SCAR-H_M26_Buck
[10:51:52] Trace: WeaponMapping: ID: 23 <--> Weapon:U_SCAR-H_M320_HE
[10:51:52] Trace: WeaponMapping: ID: 24 <--> Weapon:U_Starstreak
[10:51:52] Trace: WeaponMapping: ID: 36 <--> Weapon:U_Type88
[10:51:52] Trace: WeaponMapping: ID: 37 <--> Weapon:U_Ultimax
[10:51:52] Trace: WeaponMapping: ID: 25 <--> Weapon:U_XM25
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by tonnic*:

 

There are settings in the logger where you can set whether to store rank/stat information. You probably have that set to false on some of your servers.

Nope, it's definitely set as Yes... again, it has no problem at all on one of my servers, but the other seems to have issues.
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by Porthos1973*:

 

Running on my 32slot Conquest and it is running great. Is this compatible with the stats pages used in the BF3 stats? If so where do I find those files. I always had it hosted for me. Didn't realized it was this easy. Thanks for the plugin.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by exadmin*:

 

Fixed my problem by copy pasting the contents of BF4.def to BF3.def file. Seems like the plugin is still calling bf3.def even though it detected that the server is BF4.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by ColColonCleaner*:

 

Error FYI

 

[00:14:57 20] PRoCon Chat, GUID and Stats Logger Enabled

[00:14:57 20] PRoCon Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[00:15:01 22] Error in Tablebuilder:

[00:15:01 24] Message: Duplicate entry '1-U_SCAR-H_M26_Buck' for key 'unique'

[00:15:01 25] Native: -2147467259

[00:15:01 25] Source: MySql.Data

[00:15:01 25] 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.ExecuteReader( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[00:15:01 33] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by exadmin*:

 

Error FYI

 

[00:14:57 20] PRoCon Chat, GUID and Stats Logger Enabled

[00:14:57 20] PRoCon Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[00:15:01 22] Error in Tablebuilder:

[00:15:01 24] Message: Duplicate entry '1-U_SCAR-H_M26_Buck' for key 'unique'

[00:15:01 25] Native: -2147467259

[00:15:01 25] Source: MySql.Data

[00:15:01 25] 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.ExecuteReader( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[00:15:01 33] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

I fixed this by creating a new database and copy pasted all info from BF4.def to BF3.def
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by sourtimer*:

 

So I have been having some trouble with this one. It worked fine for me initially, populated the new database with the correct tables and the first couple rounds I received no errors.

 

But now at the end of every round I see these errors thrown:

 

Code:

[06:37:06 62] Error: Error in Startstreaming: 
[06:37:06 62] Message: Data too long for column 'CountryCode' at row 1
[06:37:06 62] Native: -2147467259
[06:37:06 62] Source: MySql.Data
[06:37:06 64] StackTrace:    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.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
[06:37:06 65] Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
Anyone have an idea of what is going on here ? Thanks.
* Restored post. It could be that the author is no longer active.
Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.