ImportBot Posted February 1, 2016 Share Posted February 1, 2016 Originally Posted by sirex*: Hi I tested your changes and remains the same problem. This link has a folder with the prints of the test performed http://index.ruinzao.com.br/downloads/procon/ Thanks for testing. But in your screens i didn't see warning message. And in my example i change tbl_teamscores table, but in screen i see different table. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 1, 2016 Share Posted February 1, 2016 Originally Posted by ruinzaO*: Thanks for testing. But in your screens i didn't see warning message. And in my example i change tbl_teamscores table, but in screen i see different table. Truth in procon not appear any warning.In table tbl_teamscores did not show error, if you need screens Table I send you. Now tbl_mapstats table remains filled wrong, instead of filling the newly finished map it fills with the map that is coming, as the prints. Sorry I use google translator Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 1, 2016 Share Posted February 1, 2016 Originally Posted by ty_ger07*: As i see in code, variable get value directly during function execution. Anyway if you can test my solution and share result it will be great.Oh? I thought it was getting one or more null members of the class CServerInfo which is being passed to it by Procon. [statslooger]Error: getUpdateServerID1: System.NullReferenceException: Object reference not set to an instance of an object ProconEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo) I don't have access to testing, debug abilities, or trace messages. Why are you so certain that it is a null TeamID issue with the SQL insert command? It would be nice if you are correct and it is so easy. I just don't see why it would be bothered by a null value in the SQL command so late in the function. It is perfectly valid to insert null values into a table. Even if it was a primary key, prior to MySQL version 5.7.3 m13 (and certainly the majority of users here are using pre-5.7.3 m13 MySQL version), it was still perfectly valid. If you are correct, this should be where it is catching the exception: Code: catch (Exception c) { this.DebugInfo("Error", "getUpdateServerID1: " + c); try { Tx.Rollback(); } catch { } }But I think it is catching the exception here:Code: catch (Exception c) { this.DebugInfo("Error", "getUpdateServerID1: " + c); }Maybe change the text "getUpdateServerID1:" so that they aren't written identically in the two different areas; and then we will know for sure which part of the code is complaining when viewing the error message. Or, get better trace messages of the original error. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 1, 2016 Share Posted February 1, 2016 Originally Posted by ruinzaO*: Oh? I thought it was getting one or more null members of the class CServerInfo which is being passed to it by Procon. I don't have access to testing, debug abilities, or trace messages. Why are you so certain that it is a null TeamID issue with the SQL insert command? It would be nice if you are correct and it is so easy. I just don't see why it would be bothered by a null value in the SQL command so late in the function. It is perfectly valid to insert null values into a table. Even if it was a primary key, prior to MySQL version 5.7.3 m13 (and certainly the majority of users here are using pre-5.7.3 m13 MySQL version), it was still perfectly valid. If you are correct, this should be where it is catching the exception: Code: catch (Exception c) { this.DebugInfo("Error", "getUpdateServerID1: " + c); try { Tx.Rollback(); } catch { } }But I think it is catching the exception here:Code: catch (Exception c) { this.DebugInfo("Error", "getUpdateServerID1: " + c); }Maybe change the text "getUpdateServerID1:" so that they aren't written identically in the two different areas; and then we will know for sure which part of the code is complaining when viewing the error message. Or, get better trace messages of the original error.ty_ger07You want me to do some more testing? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 1, 2016 Share Posted February 1, 2016 Originally Posted by Nerd-Girl*: I have my data base set up and its recording stats, but how to get access to that information in like a speadsheet or something. I'm hitting road blocks on every attempt. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 1, 2016 Share Posted February 1, 2016 Originally Posted by ruinzaO*: I have my data base set up and its recording stats, but how to get access to that information in like a speadsheet or something. I'm hitting road blocks on every attempt. bf3? ... bf4? ...? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 1, 2016 Share Posted February 1, 2016 Originally Posted by ty_ger07*: I have my data base set up and its recording stats, but how to get access to that information in like a speadsheet or something. I'm hitting road blocks on every attempt.You have to log into the database and view it with a database viewing application of one form or another. The database viewing application connects to the database and then asks the database for general information such as which tables does it contain and what are the table's names. With that information, the application can ask more detailed information about specific contents and values of those tables. The database is asked specific questions and responds in specific ways which the database viewing application interprets. The database can't just dump all of its guts. The guts are a very huge mess which you can't understand just by looking at them. The database is part of a database server (either on your local machine or on a web server somewhere) and is comprised of many, many files. You can't just open a file with a program. If the database is on a web server somewhere, phpMyAdmin is the most common application used to view the database; since it is a web interface which is usually provided by the database hoster and easily accessible. Example view of a stats database in phpMyAdmin: Capture.PNG If the database is on your local computer and you are using a package such as WAMP or XAMPP, you can use whichever method is recommended and provided with the package. phpMyAdmin is still common to use on a local installation. All the information you will ever need: https://www.youtube.com/watch_v=KgiC...BC9C878BA72085 It is a playlist. Go as far as you want to go. Stay in the shallow end, or keep watching it and go all the way to the deep end. Specifically regarding SQL and how to access the data: https://youtu.be/KgiCxe-ZW8o_t=6m20s Regarding phpMyAdmin: https://youtu.be/qgdKbmxR--w_t=3m43s Maybe you will like web stats to organize your stats information: showthread....ted-1-21-2015)* Demo: http://open-web-community.com/bf4sta...tats/index.php You will see that the stats webpage essentially just gathers the information the same way you would with phpMyAdmin but presents it in a more organized and appealing manner. Web stats view: Capture1.PNG phpMyAdmin view: Capture2.PNG Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 2, 2016 Share Posted February 2, 2016 Originally Posted by ruinzaO*: Thanks for testing. But in your screens i didn't see warning message. And in my example i change tbl_teamscores table, but in screen i see different table. testing plugin with your changesfollowing error print in procon and print the tables in the database procon_error.pngtbl_teamscores.pngtbl_teamscores2.png Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 3, 2016 Share Posted February 3, 2016 Originally Posted by ty_ger07*: testing plugin with your changes following error print in procon and print the tables in the database procon_error.png If you change the debug mode in the plugin from "Error" to "Trace", it would make tracking the issue down much easier. Just having a random error message every now and then without any additional context makes things difficult. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 3, 2016 Share Posted February 3, 2016 Originally Posted by ruinzaO*: If you change the debug mode in the plugin from "Error" to "Trace", it would make tracking the issue down much easier. Just having a random error message every now and then without any additional context makes things difficult.Code: [15:48:41] [Statslogger]Trace: OnRoundOver: TeamId -> 2 [15:48:41] [Statslogger]Trace: OnRoundOverPlayers Event [15:48:41] AdaptiveTicketCount: INFO -> Round ended. [15:48:41] UltimateMapManager: INFO -> Round ended. Rounds run on this map list: 8 [15:48:47] [Statslogger]Trace: playerLeftServer: Marine_Cneira [15:48:47] [Statslogger]Trace: Score: 27730 Playtime: 3553 [15:48:47] [Statslogger]Trace: Adding Session of Player Marine_Cneira to passed sessions [15:48:56] [Statslogger]Trace: playerLeftServer: --SiiiiiiiiD-- EAGUID: edited [15:48:56] [Statslogger]Trace: Score: 18153 Playtime: 4056 [15:48:56] [Statslogger]Trace: Adding Session of Player --SiiiiiiiiD-- to passed sessions [15:49:01] [Statslogger]Trace: getUpdateServerID [15:49:01] [Statslogger]Trace: DB returns ServerID = 1 [15:49:14] [Statslogger]Trace: playerLeftServer: MasterGamesFPS [15:49:14] [Statslogger]Trace: Score: 30656 Playtime: 3344 [15:49:14] [Statslogger]Trace: Adding Session of Player MasterGamesFPS to passed sessions [15:49:24] [Statslogger]Trace: thecrazyballs Rank: 5113 [15:49:26] [Statslogger]Trace: LcsMax Rank: 3214 [15:49:31] [Statslogger]Trace: UpdateCurrentPlayerTable [15:49:32] [Statslogger]Trace: playerLeftServer: ShinSig [15:49:32] [Statslogger]Trace: Score: 0 Playtime: 559 [15:49:36] AdaptiveTicketCount: WORK -> 23 players; Ticket count: 167% (501/501 actual tickets) [15:49:36] AdaptiveTicketCount: WORK -> 23 players; Ticket count: 167% (501/501 actual tickets) [15:49:55] [Statslogger]Trace: Ric4rdo-Gamer Rank: 8 [15:50:02] [Statslogger]Trace: getUpdateServerID [15:50:02] [Statslogger]Trace: DB returns ServerID = 1 [15:50:02] [Statslogger]Error: getUpdateServerID1: System.NullReferenceException: Object reference not set to an instance of an object. at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo) [15:50:02] [Statslogger]Trace: playerLeftServer: AndreFalbo [15:50:02] [Statslogger]Trace: Score: 3880 Playtime: 1039 [15:50:02] [Statslogger]Trace: Adding Session of Player AndreFalbo to passed sessions [15:50:04] AdaptiveTicketCount: INFO -> Level loaded. [15:50:04] [Statslogger]Info: OnLevelLoaded: MP_012 Gamemode: ConquestLarge0 Round: 1/1 [15:50:04] [Statslogger]Info: update sql server [15:50:04] UltimateMapManager: INFO -> Level loaded. [15:50:04] [Statslogger]Info: Started streaming to the DB-Server [15:50:04] [Statslogger]Trace: Mapstats Write querys [15:50:04] [Statslogger]Trace: PlayerStats Write querysif you need something else, please tell me Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 4, 2016 Share Posted February 4, 2016 Originally Posted by Level*: I have this error! [22:24:06 88] [statslogger]Error: Error in UpdateCurrentPlayerTable: Maximum number of 3 transaction retrys exceeded (Transaction delete und Insert) [22:24:06 88] [statslogger]Error: Error in UpdateCurrentPlayerTable: [22:24:06 88] Message: Lock wait timeout exceeded; try restarting transaction [22:24:06 88] Native: -2147467259 [22:24:06 88] Source: MySql.Data [22:24:06 88] 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.ExecuteNonQuer y() bei PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPla yerTable(List`1 lstPlayers) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 4, 2016 Share Posted February 4, 2016 Originally Posted by ty_ger07*: I have this error! [22:24:06 88] [statslogger]Error: Error in UpdateCurrentPlayerTable: Maximum number of 3 transaction retrys exceeded (Transaction delete und Insert) [22:24:06 88] [statslogger]Error: Error in UpdateCurrentPlayerTable: [22:24:06 88] Message: Lock wait timeout exceeded; try restarting transaction [22:24:06 88] Native: -2147467259 [22:24:06 88] Source: MySql.Data [22:24:06 88] 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.ExecuteNonQuer y() bei PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPla yerTable(List`1 lstPlayers) I don't think that there is anything you can do other than get a faster database or get rid of old unused data in the database. How big is the database? How many players are logged in the database? How many servers are in the database? Are all the servers in the database still alive? The database simply took too long to finish the process and therefore timed out. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 5, 2016 Share Posted February 5, 2016 Originally Posted by Level*: Hello, the problem was with g-portal in the database. THX Lev@l Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 10, 2016 Share Posted February 10, 2016 Originally Posted by dumaster*: Please XpKiller , ColColonCleaner and friends of MyRcon , I have some doubts, I would like to know if you have a guide to help with the rank reset operations, other doubt is the kills applied by admins in yourself and other players in the scoreboard those kills not appear, because the rank counts these kills? thanks for attention !!! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 15, 2016 Share Posted February 15, 2016 Originally Posted by GitSum*: We used to have 4 servers (Server ID 1,2,3,4) - now we are down to 1 Can I just go into "tbl_server" and delete 1,2 &4 and just keep Server ID 3 the way it is? Will this have any effect on Adkats? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 16, 2016 Share Posted February 16, 2016 Originally Posted by Prophet731*: We used to have 4 servers (Server ID 1,2,3,4) - now we are down to 1 Can I just go into "tbl_server" and delete 1,2 &4 and just keep Server ID 3 the way it is? Will this have any effect on Adkats? Deleting those servers won't break anything. As long as you don't change the server id for #3 you should be fine. Modifying the IDs manually is not recommended as it can break a lot of things. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 16, 2016 Share Posted February 16, 2016 Originally Posted by GitSum*: Deleting those servers won't break anything. As long as you don't change the server id for #3 you should be fine. Modifying the IDs manually is not recommended as it can break a lot of things.Thanks Prophet - better safe than sorry Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 26, 2016 Share Posted February 26, 2016 Originally Posted by RedentorKane*: Hello I want see weapon stats in game chat, that is posible? I have installed Chat, GUID, Stats and Mapstats Logger[1.0.0.2], but when I type in chat !stats knife, admin say: No stats are aviable for this weapon; and I type !stats rpg, admin say: Specific weapon not found!! Can helpme for do make works it_? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 26, 2016 Share Posted February 26, 2016 Originally Posted by ColColonCleaner*: Hello I want see weapon stats in game chat, that is posible? I have installed Chat, GUID, Stats and Mapstats Logger[1.0.0.2], but when I type in chat !stats knife, admin say: No stats are aviable for this weapon; and I type !stats rpg, admin say: Specific weapon not found!! Can helpme for do make works it_? You have it all set up with the database and it's been running for several rounds? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 26, 2016 Share Posted February 26, 2016 Originally Posted by RedentorKane*: You have it all set up with the database and it's been running for several rounds?Yes is conected with database! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 27, 2016 Share Posted February 27, 2016 Originally Posted by ColColonCleaner*: Yes is conected with database!How long has it been connected and running? How many rounds have passed? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 27, 2016 Share Posted February 27, 2016 Originally Posted by RedentorKane*: How long has it been connected and running? How many rounds have passed?1 Month Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 27, 2016 Share Posted February 27, 2016 Originally Posted by ColColonCleaner*: 1 MonthHmm. There are some settings that enable/disable storing weapon stats and map stats, please make sure those options are on. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 27, 2016 Share Posted February 27, 2016 Originally Posted by RedentorKane*: Hmm. There are some settings that enable/disable storing weapon stats and map stats, please make sure those options are on.Here caps:https://gyazo.com/bc0944ef4889b6ddc8cf59aba73648eb https://gyazo.com/402a86bf996288ea5ea8fe956a69be14 https://gyazo.com/818769dd1c16916e90cb978e9ebdfb37 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted February 27, 2016 Share Posted February 27, 2016 Originally Posted by ColColonCleaner*: Here caps: https://gyazo.com/bc0944ef4889b6ddc8cf59aba73648eb https://gyazo.com/402a86bf996288ea5ea8fe956a69be14 https://gyazo.com/818769dd1c16916e90cb978e9ebdfb37 Those settings look correct. If you want me to look at your DB send me creds for it in a PM and I'll look at it. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted March 4, 2016 Share Posted March 4, 2016 Originally Posted by bfgamer*: Hi I am trying to set up for the first time. I have installed mysql and added xpskiller plugin in procon. When I turned the xpkiller's plugin on, i get an error message for mysql Code: [18:12:23 35] Error in Tablebuilder: [18:12:23 35] Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead [18:12:23 35] Native: -2147467259 [18:12:23 35] Source: MySql.Data [18:12:23 35] 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.tablebuilder() [18:12:23 35] Error: System.NullReferenceException: Object reference not set to an instance of an object. at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException) at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()Please advise. I have no experience with mysql. It is installed on my local server. Any help will be appreciated. Thanks Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted March 4, 2016 Share Posted March 4, 2016 Originally Posted by ty_ger07*: Hi I am trying to set up for the first time. I have installed mysql and added xpskiller plugin in procon. When I turned the xpkiller's plugin on, i get an error message for mysql Code: [18:12:23 35] Error in Tablebuilder: [18:12:23 35] Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead [18:12:23 35] Native: -2147467259 [18:12:23 35] Source: MySql.Data [18:12:23 35] 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.tablebuilder() [18:12:23 35] Error: System.NullReferenceException: Object reference not set to an instance of an object. at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException) at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()Please advise. I have no experience with mysql. It is installed on my local server. Any help will be appreciated. Thanks Hello! Please download and use the unofficial version I posted here: myrcon.net/...chat-guid-stats-and-mapstats-logger#entry46242 The unofficial version solves an incompatibility issue with using using newer MySQL versions (MySQL version 5.7.3 m13 and newer). You must stop the layer server, upload the above unofficial version of the plugin overwritting the old plugin version you already have on the layer (or delete the other version first), delete all tables and data from the stats database, and start the layer again. Enjoy! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted March 4, 2016 Share Posted March 4, 2016 Originally Posted by kcuestag*: Having an issue with in-game stats. If I type !rank, it shows: Code: Score: 3000 0 Kills 0 HS 0 Deaths K/D: 0 Your Serverrank is: 51089 of 66154Which is completely off, if I check the stats via web, you can see me here: http://oaksclan.clanservers.com/playerstat.php_pid=74 Any idea as to what may be causing this? We are also running AdKats, not sure if it can be related. PS: If it helps, the database is around 532MB big. Edit: I have not tried your unofficial updated version, I'll try it now. Edit2: Still not working properly in-game, weird because it works fine via website. Any idea? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted March 5, 2016 Share Posted March 5, 2016 Originally Posted by bfgamer*: Hello! Please download and use the unofficial version I posted here: myrcon.net/...chat-guid-stats-and-mapstats-logger#entry46242 The unofficial version solves an incompatibility issue with using using newer MySQL versions (MySQL version 5.7.3 m13 and newer). You must stop the layer server, upload the above unofficial version of the plugin overwritting the old plugin version you already have on the layer (or delete the other version first), delete all tables and data from the stats database, and start the layer again. Enjoy! Hey it seems to be working now. However, I have another issue when i enable adkat plugin and got this error message that caused procon.exe to crash and i think this error is related to stats logger. maybe you can help me figure this out. I have already posted about this on another thread under adlats advanced in game admin because i originally thought it may be adkats' issue but more likely it is something with xpkiller's plugin because the error messge popped up with statslogger. let me know what you think and heres the error message prior procon.exe crashed Code: [02:42:12 78] [Statslogger]Error: Error in UpdateCurrentPlayerTable: [02:42:12 79] Message: Incorrect string value: '' for function inet_aton [02:42:12 79] Native: -2147467259 [02:42:12 79] Source: MySql.Data [02:42:12 79] 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.UpdateCurrentPlayerTable(List`1 lstPlayers)Thanks again for your help Edit 2: I enabled stats logger and it seems to work but it takes several hours before the error message came back again instead of few minutes. here is the error message log - Code: [15:14:33 43] [Statslogger]Error: Error in UpdateCurrentPlayerTable: [15:14:33 44] Message: Incorrect string value: '' for function inet_aton [15:14:33 44] Native: -2147467259 [15:14:33 44] Source: MySql.Data [15:14:33 44] 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.UpdateCurrentPlayerTable(List`1 lstPlayers) [15:33:45 84] [Statslogger]Error: Error in UpdateCurrentPlayerTable: [15:33:45 84] Message: Incorrect string value: '' for function inet_aton [15:33:45 84] Native: -2147467259 [15:33:45 84] Source: MySql.Data [15:33:45 84] 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.UpdateCurrentPlayerTab Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted March 6, 2016 Share Posted March 6, 2016 Originally Posted by kcuestag*: Having an issue with in-game stats. If I type !rank, it shows: Code: Score: 3000 0 Kills 0 HS 0 Deaths K/D: 0 Your Serverrank is: 51089 of 66154Which is completely off, if I check the stats via web, you can see me here: http://oaksclan.clanservers.com/playerstat.php_pid=74 Any idea as to what may be causing this? We are also running AdKats, not sure if it can be related. PS: If it helps, the database is around 532MB big. Edit: I have not tried your unofficial updated version, I'll try it now. Edit2: Still not working properly in-game, weird because it works fine via website. Any idea? Anyone? Can't figure it out. 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.