Page 184 of 184 FirstFirst ... 84134174182183184
Results 1,831 to 1,834 of 1834
  1. #1831
    hi have this plug in and it was working fine until yesterday have spoke to my provider and the keep telling me to speak with you guys so here is the error message I'm getting

    15:03:20 75] [Statslogger]Error: SQLQuery:
    [15:03:20 75] Message: Unknown column 'tsp.PlayerID' in 'on clause'
    [15:03:20 75] Native: -2147467259
    [15:03:20 75] Source: MySql.Data
    [15:03:20 75] 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.ExecuteDbDataR eader(CommandBehavior behavior)
    bei System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)
    bei System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
    bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
    bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)
    [15:03:20 75] [Statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
    bei PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)
    bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)
    [15:03:23 52] [AdKats] EXCEPTION-7010-D-FetchPlayer-PlayerListing11: [Error while fetching player.][MySql.Data.MySqlClient.MySqlException: Unknown column 'tbl_server_player.PlayerID' in 'where clause'
    bei PRoConEvents.AdKats.SafeExecuteReader(MySqlCommand command)


    if any one could point me in the right direction I wold be grateful

  2. #1832
    Community Contributor
    Join Date
    Nov 2011
    Posts
    3,026
    A PlayerID column is missing from a table? That's bad. It sounds like a corruption issue. Do you have a recent backup you can fall back on? Or, have you attempted CHECK TABLE or REPAIR TABLE SQL query commands against the database using phpMyAdmin or some similar SQL utility environment?

  3. #1833
    Quote Originally Posted by bonster View Post
    hi have this plug in and it was working fine until yesterday have spoke to my provider and the keep telling me to speak with you guys so here is the error message I'm getting

    15:03:20 75] [Statslogger]Error: SQLQuery:
    [15:03:20 75] Message: Unknown column 'tsp.PlayerID' in 'on clause'
    [15:03:20 75] Native: -2147467259
    [15:03:20 75] Source: MySql.Data
    [15:03:20 75] 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.ExecuteDbDataR eader(CommandBehavior behavior)
    bei System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)
    bei System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
    bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
    bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)
    [15:03:20 75] [Statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
    bei PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)
    bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)
    [15:03:23 52] [AdKats] EXCEPTION-7010-D-FetchPlayer-PlayerListing11: [Error while fetching player.][MySql.Data.MySqlClient.MySqlException: Unknown column 'tbl_server_player.PlayerID' in 'where clause'
    bei PRoConEvents.AdKats.SafeExecuteReader(MySqlCommand command)


    if any one could point me in the right direction I wold be grateful
    Also, if you are just setting this up for the first time i would suggest NOT modifying the names of the tables from their defaults. It can cause some compatibility issues with other plugins if you ever install them and they are expecting to interface with stat logger.
    ____

  4. #1834
    Hi, I installed this plugin on the game server Bad Company 2, connected the mysql database. tbl_currentplayers filled. But tbl_weapons_stats is not filled.
    plugin1.jpg
    plugin2.jpg
    BFBC2.def file with all the weapons.
    Why tbl_weapons_stats is not filled?
    Last edited by Devis; 12-09-2018 at 04:13.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •