ImportBot Posted November 12, 2013 Share Posted November 12, 2013 Originally Posted by sourtimer*: 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.Are you completely overwriting the existing contents of BF3.DEF with BF4.DEF's data ? Or are you adding the data from BF4.DEF to BF3.DEF leaving what was already in BF3.DEF alone ? Thanks Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 12, 2013 Share Posted November 12, 2013 Originally Posted by exadmin*: Are you completely overwriting the existing contents of BF3.DEF with BF4.DEF's data ? Or are you adding the data from BF4.DEF to BF3.DEF leaving what was already in BF3.DEF alone ? Thanks deleted all the contents of bf3.def and copy pasted the data from the bf4.def and restart your procon after. I'm using the procon client btw, not on a layer. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 12, 2013 Share Posted November 12, 2013 Originally Posted by sourtimer*: deleted all the contents of bf3.def and copy pasted the data from the bf4.def and restart your procon after. I'm using the procon client btw, not on a layer.Alrighty thanks. I am doing the same. Running Procon locally with the mySQL database running on the same machine. Just run it all off my fileserver in the basement. Hopefully this fixes it for me. Thanks Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 12, 2013 Share Posted November 12, 2013 Originally Posted by sourtimer*: Crap. No dice. I still get this error at the end of every round and stats don't seem to be saving or working apart from the tables being created Code: [07:46:34 76] Error: Error in Startstreaming: [07:46:34 77] Message: Data too long for column 'CountryCode' at row 1 [07:46:34 77] Native: -2147467259 [07:46:34 77] Source: MySql.Data [07:46:34 81] 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() [07:47:04 71] 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() Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 12, 2013 Share Posted November 12, 2013 Originally Posted by jaczart*: In MOHW With new database table creation error 'Data to long for column Fullname' Make a change in CChatGUIDStatsLogger.inc in line 5281 to remove the error //New Weapon table change from `Fullname` varchar(45) DEFAULT NULL, to `Fullname` varchar(150) DEFAULT NULL, Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 12, 2013 Share Posted November 12, 2013 Originally Posted by ColColonCleaner*: Crap. No dice. I still get this error at the end of every round and stats don't seem to be saving or working apart from the tables being created Code: [07:46:34 76] Error: Error in Startstreaming: [07:46:34 77] Message: Data too long for column 'CountryCode' at row 1 [07:46:34 77] Native: -2147467259 [07:46:34 77] Source: MySql.Data [07:46:34 81] 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() [07:47:04 71] 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() This is from the CountryCode column not being long enough to store a player's country. Country codes are supposed to be 2 chars, but apparently someone has a 3+ char country code. Try this: ALTER TABLE `tbl_playerdata` CHANGE COLUMN `CountryCode` `CountryCode` VARCHAR(3) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL; Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 12, 2013 Share Posted November 12, 2013 Originally Posted by sourtimer*: This is from the CountryCode column not being long enough to store a player's country. Country codes are supposed to be 2 chars, but apparently someone has a 3+ char country code. Try this: ALTER TABLE `tbl_playerdata` CHANGE COLUMN `CountryCode` `CountryCode` VARCHAR(3) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL; Thanks for the help. This is a bit out of my knowledge base though. I am guessing that I need to make this amendment in MySQL, but I am not certain how or where in mySQL I would apply that ? My guess is that I run this command against the database I created somehow, I'm not quite certain how to do that though. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 12, 2013 Share Posted November 12, 2013 Originally Posted by EBassie*: Hey XP, I was wondering of you could add the option of NOT to use the weapon stats. I only want to use the round statistics for a simple leaderboard and am not really interested in the weapon stats. Keep up the good work and buy some beers PS: I'm also interested in a migration script for my current BF3 stats DB. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 12, 2013 Share Posted November 12, 2013 Originally Posted by ColColonCleaner*: Thanks for the help. This is a bit out of my knowledge base though. I am guessing that I need to make this amendment in MySQL, but I am not certain how or where in mySQL I would apply that ? My guess is that I run this command against the database I created somehow, I'm not quite certain how to do that though.Just run it at a script/query, there should be a place in your database control panel where you can paste this and run it. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by CptChaos*: Hey XP, I was wondering of you could add the option of NOT to use the weapon stats. I only want to use the round statistics for a simple leaderboard and am not really interested in the weapon stats. Keep up the good work and buy some beers PS: I'm also interested in a migration script for my current BF3 stats DB. The trackers at gametracker.com have such a feature. I wouldn't install a plugin for it. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by Mandizzy*: GT is external, this plug-in can show rank within game on your server. BTW, this is exactly what I want, don't care about weapon stats for individual players etc. Just simple player rankings and perhaps time well wasted on my servers ;-) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by XpKiller*: 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 Your bf4.def file dont contain the all weapons of bf4 yet. 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.The plugin is not calling the bf3.def file. It call a buildin procon fuction to get all weapons known by procon. Those weapons definitions are saved in those *.def files.There is absolutly no need to copy stuff from the bf4.def to bf4.def file. I STRONGLY NOT recommend to do this. You will not solve that problem an might get new ones as well. You need an updated bf4.def file. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by KennyR*: Works awesome! Example: http://www.teamfrostbite.com/servers/ (admin remove link if not allowed, sorry) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by tonnic*: Works awesome! Example: http://www.teamfrostbite.com/servers/ (admin remove link if not allowed, sorry) which plugin are you using for that? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by tonnic*: 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.Could my issue be because both the old plugin and new plugin are showing in my plugins? PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.0 BF3 Chat, GUID, Stats and Map Logger - 1.1.0.1 ONLY the "PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.0" is enabled. Again to recap my issue. I have 2 servers on my PRoCon layer. One of the servers seems to be working 100%, but the other... not so much... player data saved, but the tbl_playerrank has a whole bunch of 0's in it. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by KennyR*: Could my issue be because both the old plugin and new plugin are showing in my plugins? PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.0 BF3 Chat, GUID, Stats and Map Logger - 1.1.0.1 ONLY the "PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.0" is enabled. Again to recap my issue. I have 2 servers on my PRoCon layer. One of the servers seems to be working 100%, but the other... not so much... player data saved, but the tbl_playerrank has a whole bunch of 0's in it. I use this plugin to put everything in the database, then i just made a page where i read out all the stuff. Answer on your question: do you have both servers in the same servergroup? Should not be if you want seperate stats for both servers. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by tonnic*: I use this plugin to put everything in the database, then i just made a page where i read out all the stuff. Answer on your question: do you have both servers in the same servergroup? Should not be if you want seperate stats for both servers. No I don't and they are actually on different databases too...should I be only using 1 database__? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by tonnic*: I use this plugin to put everything in the database, then i just made a page where i read out all the stuff. Answer on your question: do you have both servers in the same servergroup? Should not be if you want seperate stats for both servers. Oh so you coded a script for the output yourself? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by Athlon*: Oh so you coded a script for the output yourself?It's a web page that reads the stats from his database live. Here's mine: http://ecbiz122.inmotionhosting.com/...ayer_stats.php Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by KennyR*: Oh so you coded a script for the output yourself?Yes i did. When you have everything in a database the rest is easy, if you have knowlegde of basic programming. It's a web page that reads the stats from his database live. Here's mine: http://ecbiz122.inmotionhosting.com/...ayer_stats.php Nice! Is there a way to get the current ticket count from the server? You can see live player kills, but not live server stats? edit; nevermind, i was blind..will be here later. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by tonnic*: Yes i did. When you have everything in a database the rest is easy, if you have knowlegde of basic programming. Nice! Is there a way to get the current ticket count from the server? You can see live player kills, but not live server stats? edit; nevermind, i was blind..will be here later. Ugh I don't want to code a page... was hoping there was a joomla plugin somewhere . Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by tonnic*: It's a web page that reads the stats from his database live. Here's mine: http://ecbiz122.inmotionhosting.com/...ayer_stats.php Cool stats... I am running a joomla site that I'd love that stuff in... you developed everything there yourself? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by sourtimer*: This is from the CountryCode column not being long enough to store a player's country. Country codes are supposed to be 2 chars, but apparently someone has a 3+ char country code. Try this: ALTER TABLE `tbl_playerdata` CHANGE COLUMN `CountryCode` `CountryCode` VARCHAR(3) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL; I just made this change and it still throws this error at the end of every round Code: [07:46:34 76] Error: Error in Startstreaming: [07:46:34 77] Message: Data too long for column 'CountryCode' at row 1 [07:46:34 77] Native: -2147467259 [07:46:34 77] Source: MySql.Data [07:46:34 81] 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() [07:47:04 71] 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()Very strange. I've tried recreating the database several times as well. It has no issue populating it with the tables, but starts to stop deploying the stats into the database. I'll try installing this on another machine and see if there is something funky on the PC I've been doing this with that is interfering with it. I guess no one else is getting this error ? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by Kinsman*: Anyone willing to share their display scripts for the more program challenged? I don't have the skills to update our old ones. Perhaps you could post them in the Plugin Enhancements Forum. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by XpKiller*: I just made this change and it still throws this error at the end of every round Code: [07:46:34 76] Error: Error in Startstreaming: [07:46:34 77] Message: Data too long for column 'CountryCode' at row 1 [07:46:34 77] Native: -2147467259 [07:46:34 77] Source: MySql.Data [07:46:34 81] 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() [07:47:04 71] 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()Very strange. I've tried recreating the database several times as well. It has no issue populating it with the tables, but starts to stop deploying the stats into the database. I'll try installing this on another machine and see if there is something funky on the PC I've been doing this with that is interfering with it. I guess no one else is getting this error ? I running tests right now to debug this issue. In the meantime you could try make the field even larger: ALTER TABLE `tbl_playerdata` CHANGE COLUMN `CountryCode` `CountryCode` VARCHAR(10) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL; Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by XpKiller*: I use this plugin to put everything in the database, then i just made a page where i read out all the stuff. Answer on your question: do you have both servers in the same servergroup? Should not be if you want seperate stats for both servers. The stats are always separated. The servergroup is only relevant for calculating rankings over multiply servers. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by Athlon*: Cool stats... I am running a joomla site that I'd love that stuff in... you developed everything there yourself?It's heavily modified by me from the original page created by ty_ger07 and posted here: myrcon.net/.../bf4-stats-page-for-bf4-procon-chat-guid-stats-and-mapstats-logger You would need to know php and mysql coding to make it your own. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by Ralphvd*: It's a web page that reads the stats from his database live. Here's mine: http://ecbiz122.inmotionhosting.com/...ayer_stats.php Do you share it It looks awesome!!!! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by KennyR*: Anyone willing to share their display scripts for the more program challenged? I don't have the skills to update our old ones. Perhaps you could post them in the Plugin Enhancements Forum.I'm still working on my and will make it public later when it is finished. @ Athlon. How can i get the total score from a player? I only seem to see rankscore, but that doesn't give the total score by that player. Im trying to get a top 10. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 13, 2013 Share Posted November 13, 2013 Originally Posted by XpKiller*: @KennyR for all Servers, a servergroup or just one server? Btw: myrcon.net/.../advanced-in-game-admin-and-ban-enforcer-adkats Quote * Restored post. It could be that the author is no longer active. Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.