ImportBot Posted July 24, 2010 Author Share Posted July 24, 2010 Originally Posted by Repoman1*: =BB=Insomnia, I am getting this error. Table 'ragining_bcstats.tbl_playerguid' doesn't exist. Xpkillers table is tbl_Playerguid it has an uppcase P not lower case p. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 24, 2010 Author Share Posted July 24, 2010 Originally Posted by EBassie*: =BB=Insomnia, I am getting this error. Table 'ragining_bcstats.tbl_playerguid' doesn't exist. Xpkillers table is tbl_Playerguid it has an uppcase P not lower case p.My tablename has NO uppercase... Using latest version.. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 24, 2010 Author Share Posted July 24, 2010 Originally Posted by Repoman1*: Yes I am running the latest, not sure why I am getting the error. Even created a different DB, for testing but get the same error. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 24, 2010 Author Share Posted July 24, 2010 Originally Posted by Gent*: I am running the latest; getting this error: Code: [18:10:22 05] Error in SQLQuery: System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.1.41]Table 'stats.tbl_PlayerGUID' doesn't exist at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)I have tried creating both tables tbl_playerGUID and tbl_PlayerGUID still get error even though data is going into them, none of the commands work in server /EDIT Seems to work when i manually created another table exactly the same name @ "create table tbl2 select * from tbl1" Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 24, 2010 Author Share Posted July 24, 2010 Originally Posted by XpKiller*: is the db server a linux box? and did wait one round? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 24, 2010 Author Share Posted July 24, 2010 Originally Posted by Gent*: yes linux, yes waited rounds also; freesqldatabase.com = works perfect Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 24, 2010 Author Share Posted July 24, 2010 Originally Posted by Gent*: Code: [19:57:17 20] Error in SQLQuery: System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Table 'sql01_3716noob1.tbl_playerGUID' doesn't existits still giving errors between that playerGUID and PlayerGUID Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by XpKiller*: I will review the code maybe I did an error Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by SexDrugOverclocking*: I just started testing and offering this stats logger now that there is a web script. I have one request which shouldn't be to much trouble. I would like to see REAL-TIME stats logging. Wolfy added this to WolfCon for me and since my MySQL server and Web Server are all in-house and WolfCon stats tracking is on that server it is possible for me to run that on 50+ servers. Would you be willing to code a real-time logger and let me try it out? Let me know and thanks for creating this plugin. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by BB-Insomnia*: Please post your bugs about the Stats-script for your homepage here: phogue.net/forum/viewtopic.php_f=18&t=911* otherwise it will be too confusing. The problem with linux database servers is fixed ( i hope ) in v0.95 check it out and give me feedback! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by Gent*: There is a problem with !top10, it dont work This seemed to throw the error with the lowercase p in tbl_playerGUID as well. hope this helps! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by Sp00k*: yeah my top10 didnt work either when the plugin was working at all, now i keep getting this error on map change and the stats wont update Code: Error in SQLQuery: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]User phs_pcSp00k already has more than 'max_user_connections' active connections ERROR [HY000] [MySQL][ODBC 5.1 Driver]User phs_pcSp00k already has more than 'max_user_connections' active connections at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.Odbc.OdbcConnection.Open() at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by XpKiller*: There is a problem with !top10, it dont work This seemed to throw the error with the lowercase p in tbl_playerGUID as well. hope this helps! jep you are right sorry for that im testing on windows box there it is no issue @Sp00k do you how many connections your server support atm my plugin build up two connections to the db server at the same time Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by Sp00k*: im not sure... the db is hosted by PHS which is also hosting my procon layer. I submitted the error to them but they said to report this to you. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by SexDrugOverclocking*: I have no errors with this plugin. It runs great and everything works. I just want REAL-TIME stats Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by Gent*: Code: Error in SQLQuery: System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is connecting.Code: Error in SQLQuery: System.NullReferenceException: Object reference not set to an instance of an object.new errors it lost connection to the database? database is running perfect Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by XpKiller*: Code: Error in SQLQuery: System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is connecting.Code: Error in SQLQuery: System.NullReferenceException: Object reference not set to an instance of an object.new errors it lost connection to the database? database is running perfecti know these errors the first one is a bug in the mysql odbc driver or the database iam looking for a solution of this issue. the second one is a real error i must forgot a check if the object is null Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by Gent*: Thanks for supporting the plugin anyway :mrgreen: Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by SexDrugOverclocking*: This plugin works perfect for me..... Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by Gent*: What about: [19:40:55 45] Error: System.Data.Odbc.OdbcException: ERROR [23000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Duplicate entry 'tombsm8-782e2bf87724e7f0c066f125bbd51071' for key 2 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by HelloKitty*: ...works good for me too. Well done! (WinServ2003EntEd ; xampp1.6 ; 3 bc2 servers combined in one database) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 25, 2010 Author Share Posted July 25, 2010 Originally Posted by EBassie*: There is a small bug with chatlogging. Seems you have to escape the " and / character before insert. Chatmessages with these characters will give an error when inserting in to DB Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 26, 2010 Author Share Posted July 26, 2010 Originally Posted by XpKiller*: There is a small bug with chatlogging. Seems you have to escape the " and / character before insert. Chatmessages with these characters will give an error when inserting in to DB good find will take a look this Problem is only instant chatlog related right? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 26, 2010 Author Share Posted July 26, 2010 Originally Posted by XpKiller*: What about: [19:40:55 45] Error: System.Data.Odbc.OdbcException: ERROR [23000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Duplicate entry 'tombsm8-782e2bf87724e7f0c066f125bbd51071' for key 2 how does this happens in general this error appears only if the database has been change manually when the plugin is running Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 26, 2010 Author Share Posted July 26, 2010 Originally Posted by EBassie*: There is a small bug with chatlogging. Seems you have to escape the " and / character before insert. Chatmessages with these characters will give an error when inserting in to DB good find will take a look this Problem is only instant chatlog related right? I think so yes.... Got no errors on the stats updates, only on chat updates. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 26, 2010 Author Share Posted July 26, 2010 Originally Posted by EBassie*: Got another error. Never seen this before: Code: Error: System.InvalidOperationException: The transaction is either not associated with the current connection or has been completed. at System.Data.Odbc.OdbcConnection.SetStateExecuting(String method, OdbcTransaction transaction) at System.Data.Odbc.OdbcCommand.ValidateConnectionAndTransaction(String method) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteNonQuery() at PRoConEvents.CChatGUIDStatsLogger.StartStreaming() Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 26, 2010 Author Share Posted July 26, 2010 Originally Posted by XpKiller*: Got another error. Never seen this before: Code: Error: System.InvalidOperationException: The transaction is either not associated with the current connection or has been completed. at System.Data.Odbc.OdbcConnection.SetStateExecuting(String method, OdbcTransaction transaction) at System.Data.Odbc.OdbcCommand.ValidateConnectionAndTransaction(String method) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteNonQuery() at PRoConEvents.CChatGUIDStatsLogger.StartStreaming() i never got this error but i will take a look at it. Thanks for report Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 26, 2010 Author Share Posted July 26, 2010 Originally Posted by Gent*: What about: [19:40:55 45] Error: System.Data.Odbc.OdbcException: ERROR [23000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Duplicate entry 'tombsm8-782e2bf87724e7f0c066f125bbd51071' for key 2 how does this happens in general this error appears only if the database has been change manually when the plugin is runningNo idea, the database has not been manually changed at all for sure. Its one from the www.freesqldatabase.com I might try again with my linux sql database Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 26, 2010 Author Share Posted July 26, 2010 Originally Posted by XpKiller*: *update* Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted July 27, 2010 Author Share Posted July 27, 2010 Originally Posted by EBassie*: XPkiller, is it possible to show the rank in public chat when a user uses @rank? Maybe an option in settings of the plugin? 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.
Note: Your post will require moderator approval before it will be visible.