ImportBot Posted October 20, 2010 Author Share Posted October 20, 2010 Originally Posted by XpKiller*: Looks like a Problem with the MySQl Server. Probably this has to do with the connections of the Plugin. The Server close the Connection because of timeout and the Procon throw an Error. I will maybe build something which close the when the Server is empty. BTW: I recommend to use a MySQL Server with Version 5.1.x your Server is 5.0.x. If possible you could update your sqlserver Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 20, 2010 Author Share Posted October 20, 2010 Originally Posted by slekkas*: Looks like a Problem with the MySQl Server. Probably this has to do with the connections of the Plugin. The Server close the Connection because of timeout and the Procon throw an Error. I will maybe build something which close the when the Server is empty. BTW: I recommend to use a MySQL Server with Version 5.1.x your Server is 5.0.x. If possible you could update your sqlserver I'm contacting my hosting provider to see if they can upgrade. They told me that they cant do yet. Could you please try to fix it? I will donate to procon as well since i'm a computer tech and i hate working for free:-) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 20, 2010 Author Share Posted October 20, 2010 Originally Posted by EBassie*: XpKiller, I was moving my 2 stats databases to 1 database instead of 2, using the prefix (dm? & rush_) option. After conversion, I got this error-message: Error in LogChat: System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-4.1.14-standard]Table 'statsdb.tbl_chatlogdm?' doesn't existSeems the prefix has become a postfix. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 20, 2010 Author Share Posted October 20, 2010 Originally Posted by slekkas*: XpKiller, I was moving my 2 stats databases to 1 database instead of 2, using the prefix (dm? & rush_) option. After conversion, I got this error-message: Error in LogChat: System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-4.1.14-standard]Table 'statsdb.tbl_chatlogdm?' doesn't existSeems the prefix has become a postfix. What exactly does that mean_? What can I do to fix it? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 20, 2010 Author Share Posted October 20, 2010 Originally Posted by EBassie*: What exactly does that mean_? What can I do to fix it?This is only a problem if you have 2 or more servers in Procon and they all have the stats plugin enabled.If you do not have this error, you do not have to fix anything. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 20, 2010 Author Share Posted October 20, 2010 Originally Posted by XpKiller*: XpKiller, I was moving my 2 stats databases to 1 database instead of 2, using the prefix (dm? & rush_) option. After conversion, I got this error-message: Error in LogChat: System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-4.1.14-standard]Table 'statsdb.tbl_chatlogdm?' doesn't existSeems the prefix has become a postfix. Ahh Sry wrong translation your are right it is a postfix Use _dm instead of dm? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 21, 2010 Author Share Posted October 21, 2010 Originally Posted by slekkas*: XpKiller, I was moving my 2 stats databases to 1 database instead of 2, using the prefix (dm? & rush_) option. After conversion, I got this error-message: Error in LogChat: System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-4.1.14-standard]Table 'statsdb.tbl_chatlogdm?' doesn't existSeems the prefix has become a postfix. Ahh Sry wrong translation your are right it is a postfix Use _dm instead of dm? How can i do this? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 21, 2010 Author Share Posted October 21, 2010 Originally Posted by slekkas*: Now i have a new issue. When i have the plugin enabled at the end of the round procon stop responding and crashes. I really love this plugin and it drives me crazy that its so diffucult to make it work nice and stable. Any ideas? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 21, 2010 Author Share Posted October 21, 2010 Originally Posted by XpKiller*: do you use MySQL Version 5.1.x? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 21, 2010 Author Share Posted October 21, 2010 Originally Posted by slekkas*: do you use MySQL Version 5.1.x?My host provider can only use mysql 5.0 at the moment. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 22, 2010 Author Share Posted October 22, 2010 Originally Posted by XpKiller*: Than pls check if your connection data are correct and your procon has ODBC enabled and configured. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 22, 2010 Author Share Posted October 22, 2010 Originally Posted by slekkas*: Than pls check if your connection data are correct and your procon has ODBC enabled and configured.The settings are fine. I do the system DSN test and it's successfully. The chat log gets written but at the end of each round procon crashes. I went through hell to install mysql 5.1, apache, php and phpmyadmin on my computer to make this work. Now everything works fine but since my pc is not meant to be a server the webstats are really slow. I really need to use mysql 5.0 that is on my domain host. You can try to see how slow it is www.leagueofkarpathos.gr/server Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 22, 2010 Author Share Posted October 22, 2010 Originally Posted by XpKiller*: I'm not why it doesn't work on 5.0 maybe your database provider Innodb disabled. anyway it would take a complete recode of the mysql codesections to get this Problem solved. Maybe it has nothing to do with my coding just with odbc driver than i can do nothing. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 22, 2010 Author Share Posted October 22, 2010 Originally Posted by slekkas*: One good way to test if it's my provider would be to use another mysql 5.0 database of another host. Do you know any free database hosts that others use and they have no problem? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 23, 2010 Author Share Posted October 23, 2010 Originally Posted by TimSad*: How can I go about changing the kills required for the Killstreak message as well as for the deathstreak one? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 24, 2010 Author Share Posted October 24, 2010 Originally Posted by XpKiller*: wrong Thread? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 24, 2010 Author Share Posted October 24, 2010 Originally Posted by TimSad*: wrong Thread?Oh shit! How embarrassing! I totally forgot that I had enabled the built in Killstreak plugin and was thinking the whole time that it was part of your plugin. Sorry! :| Thanks for helping me realize that though, heh... BTW, thanks for this very useful plugin. Glad your first official program in C# could be one that benefits us. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 31, 2010 Author Share Posted October 31, 2010 Originally Posted by slekkas*: I've posted about this issue before but it didn't get solved. I installed your plug-in and created a db at my host. it seemed to be working but at the end of each round when the plug-in sends the data to the db procon would crash. I tried a few things without success so i decided to install mysql, Apache and php locally on the PC were I'm running procon. problem solved, the data goes to the db and procon does not crash. Since i did this another problem occurred. I'm running BfBC2 Chat GUID and Stats Logger Webstats v0.98 and it became reallyyyyy slow. You can try at www.leagueofkarpathos.gr/server. when running on my host page opens in a sec. When hosting on my pc really slow. I posted at BfBC2 Chat GUID and Stats Logger Webstats v0.98 topic and they told me that they use www.freemysqldatabase.com to host their database and i should use this for better performance. I created a db there and ass soon as i changed the db setting to point there procon started crashing again at the end of each round. Can you help me with this? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 31, 2010 Author Share Posted October 31, 2010 Originally Posted by HelloKitty*: look in procons "tools" -> "options" -> "plugins" If you have "allow all outgoing odbc connections" enabled. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 31, 2010 Author Share Posted October 31, 2010 Originally Posted by slekkas*: look in procons "tools" -> "options" -> "plugins" If you have "allow all outgoing odbc connections" enabled.I do have "allow all outgoing odbc connections" enabled. Here is a screenshot of the plugins settings Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 31, 2010 Author Share Posted October 31, 2010 Originally Posted by HelloKitty*: Do you have any errormessages in the logs or in the "plugins" tab? It must be a connection problem. do you have the sqldriver installed? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 31, 2010 Author Share Posted October 31, 2010 Originally Posted by slekkas*: Do you have any errormessages in the logs or in the "plugins" tab? It must be a connection problem. do you have the sqldriver installed?Yes the mysql odbc driver is installed and when i do the test it is successful. Procon crashes so i cannot view the log. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 31, 2010 Author Share Posted October 31, 2010 Originally Posted by Legate*: May be is a stupid cuestion but it is possible to show stats, top10 , etc. every X seconds without type the command? (like when the player connect to server). Legate. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted October 31, 2010 Author Share Posted October 31, 2010 Originally Posted by HelloKitty*: let the spambot say "!top10" . Stats make not much sense....cuz they are indivdual for every player. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 1, 2010 Author Share Posted November 1, 2010 Originally Posted by XpKiller*: Did you see Welcomestats function? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 1, 2010 Author Share Posted November 1, 2010 Originally Posted by Legate*: Did you see Welcomestats function?Yes but is the only moment that the player see his stats without type. I think that in the end of the round is an excelent moment to show again stats or top10 or whatever. P.D.: thanks for this plug-in Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 2, 2010 Author Share Posted November 2, 2010 Originally Posted by XpKiller*: hmm endround statsmessage should be possible. maybe i implement it soon. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 2, 2010 Author Share Posted November 2, 2010 Originally Posted by Flyswamper*: I've just setup a free database at freesql.org and I'm trying to get the plugin working. Parent-layer is hosted at Primarytarget.com Whenever I hit the "run next round" button in procon to force the table building event/code...I get this message and my client copy of ProCon immediately disconnects from the parent-layer. I can reconnect to the parentlayer right away...but it still disconnects consistently/repeatedly. Here is the error message from the parent-layer console... 09:25:07 74] EoPl: 2 [09:25:11 59] OnLoadingLevel: Levels/MP_009GR Round: 2/2 [09:25:11 59] update sql server [09:25:11 62] Start tablebuilder [09:25:12 87] INSERT INTO tbl_mapstats28180 (TimeMapLoad, TimeRoundStarted, TimeRoundEnd, MapName, Gamemode, Roundcount, NumberofRounds, MinPlayers, AvgPlayers, MaxPlayers, PlayersJoinedServer, PlayersLeftServer) VALUES (_,_,_,_,_,_,_,_,_,_,_,_) [09:25:13 21] Error: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.16-standard-log]Got error -1 from storage engine at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteNonQuery() at PRoConEvents.CChatGUIDStatsLogger.StartStreaming() I'll go have a look at the logs on the parent layer and report back if I find anything instructive.... but I'd love to hear thoughts on where to look and what to do next.... Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 2, 2010 Author Share Posted November 2, 2010 Originally Posted by XpKiller*: http://tech.amikelive.com/node-36/mysql ... -database/ Also you mysql Version is quite old there are bugs with innodb which causes this bug too. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 3, 2010 Author Share Posted November 3, 2010 Originally Posted by Flyswamper*: http://tech.amikelive.com/node-36/mysql-50-recovering-crashedcorrupted-innodb-database/ Also you mysql Version is quite old there are bugs with innodb which causes this bug too. I'll do a bit more reading of that link when I get some time, but it sounds like this is an issue with the setup over at freesql.org...... Which I have no control over.... Perhaps a case of getting what I'm paying for I suppose. If that is the case, then everyone using freesql.org (or attempting to use it) would seem to face the same issue? 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.