Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

thx @ all...problem was fixed

 

thx @ XPKiller

ur awesome

[ImportBot]

Originally Posted by Jamesonp*:

 

[13:05:21 90] [statslogger]Error: Error in Startstreaming:

[13:05:21 90] Message: Out of range value for column 'Deaths' at row 18

[13:05:21 90] Native: -2147467259

[13:05:21 90] Source: MySql.Data

[13:05:21 90] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& 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.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

Any ideas? I'm trying to locate the "Deaths" row 18 but am having no luck. Causing a loss of stats.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Any ideas? I'm trying to locate the "Deaths" row 18 but am having no luck. Causing a loss of stats.

Deaths column in stat logger is an unsigned value so it has to be > 0, but in BF4 there is a glitch where deaths can be -1, so the query will fail. I think this is already being worked on.

[ImportBot]

Originally Posted by Jamesonp*:

 

Deaths column in stat logger is an unsigned value so it has to be > 0, but in BF4 there is a glitch where deaths can be -1, so the query will fail. I think this is already being worked on.

Thank you for the response. I'll be waiting patiently for an update.

 

[ImportBot]

Originally Posted by XpKiller*:

 

@Jamesonp

 

will be fix in the next release.

 

Workaround:

disable sessionstats

[ImportBot]

Originally Posted by ColColonCleaner*:

 

@Jamesonp

 

will be fix in the next release.

 

Workaround:

disable sessionstats

Will chat player IDs be in there too?

 

I can give you all code/queries for that if needed.

[ImportBot]

Originally Posted by terse85*:

 

@ XPKiller

@ all

 

What is ronge and what to do:

 

 

 

[01:15:03 02] Error in Tablebuilder:

[01:15:03 04] Message: Identifier name 'fk_tbl_weapons_statsServerstats_tbl_server_player Serverstats_StatsID' is too long

[01:15:03 04] Native: -2147467259

[01:15:03 05] Source: MySql.Data

[01:15:03 05] StackTrace: ved MySql.Data.MySqlClient.MySqlStream.ReadPacket()

ved MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

ved MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:03 06] Error: System.NullReferenceException: Objektreferanse er ikke satt til en objektforekomst.

ved PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:06 62] Error in Tablebuilder:

[01:15:06 62] Message: Identifier name 'fk_tbl_weapons_statsServerstats_tbl_server_player Serverstats_StatsID' is too long

[01:15:06 62] Native: -2147467259

[01:15:06 62] Source: MySql.Data

[01:15:06 63] StackTrace: ved MySql.Data.MySqlClient.MySqlStream.ReadPacket()

ved MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

ved MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:06 63] Error: System.NullReferenceException: Objektreferanse er ikke satt til en objektforekomst.

ved PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:10 54] Error in Tablebuilder:

[01:15:10 54] Message: Identifier name 'fk_tbl_weapons_statsServerstats_tbl_server_player Serverstats_StatsID' is too long

[01:15:10 55] Native: -2147467259

[01:15:10 55] Source: MySql.Data

[01:15:10 55] StackTrace: ved MySql.Data.MySqlClient.MySqlStream.ReadPacket()

ved MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

ved MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:10 55] Error: System.NullReferenceException: Objektreferanse er ikke satt til en objektforekomst.

ved PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:14 44] Error in Tablebuilder:

[01:15:14 45] Message: Identifier name 'fk_tbl_weapons_statsServerstats_tbl_server_player Serverstats_StatsID' is too long

[01:15:14 46] Native: -2147467259

[01:15:14 46] Source: MySql.Data

[01:15:14 47] StackTrace: ved MySql.Data.MySqlClient.MySqlStream.ReadPacket()

ved MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

ved MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:14 48] Error: System.NullReferenceException: Objektreferanse er ikke satt til en objektforekomst.

ved PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:18 19] Error in Tablebuilder:

[01:15:18 20] Message: Identifier name 'fk_tbl_weapons_statsServerstats_tbl_server_player Serverstats_StatsID' is too long

[01:15:18 20] Native: -2147467259

[01:15:18 21] Source: MySql.Data

[01:15:18 23] StackTrace: ved MySql.Data.MySqlClient.MySqlStream.ReadPacket()

ved MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

ved MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:18 24] Error: System.NullReferenceException: Objektreferanse er ikke satt til en objektforekomst.

ved PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:21 83] Error in Tablebuilder:

[01:15:21 83] Message: Identifier name 'fk_tbl_weapons_statsServerstats_tbl_server_player Serverstats_StatsID' is too long

[01:15:21 84] Native: -2147467259

[01:15:21 85] Source: MySql.Data

[01:15:21 86] StackTrace: ved MySql.Data.MySqlClient.MySqlStream.ReadPacket()

ved MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

ved MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[01:15:21 87] Error: System.NullReferenceException: Objektreferanse er ikke satt til en objektforekomst.

ved PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

ved PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[ImportBot]

Originally Posted by 24Flat*:

 

Im getting this error "Error in Tablebuilder: Duplicate entry '1-U_Scout' for key 'unique' ?

[ImportBot]

Originally Posted by Jamesonp*:

 

Im getting this error "Error in Tablebuilder: Duplicate entry '1-U_Scout' for key 'unique' ?

Using your old database from BF3?

[ImportBot]

Originally Posted by ZeroKooL*:

 

Thank you for this, quick question tho.. I have 3 server all using this plugin, what would be the best way to reset the stats for just 1 on those servers.

 

Regards

Zero

[ImportBot]

Originally Posted by XpKiller*:

 

@terse85

 

dont use a table suffix Should fix that problem. Delete all created tables before.

 

@24Flat

Please update to the latest version.

[ImportBot]

Originally Posted by Snowy-Leopard*:

 

Thank you for this, quick question tho.. I have 3 server all using this plugin, what would be the best way to reset the stats for just 1 on those servers.

 

Regards

Zero

I would like to know this too

[ImportBot]

Originally Posted by XpKiller*:

 

ZeroKooL

 

Thank you for this, quick question tho.. I have 3 server all using this plugin, what would be the best way to reset the stats for just 1 on those servers.

I would like to know this too

All in the same database?

 

The following statement will delete all stats entries of a single server.

 

DO A BACKUP BEFORE EXECUTE THIS STATEMENT:

Code:

set @ServerID = 1;

DELETE tps FROM tbl_playerstats tps
INNER JOIN tbl_server_player tsp ON tps.StatsID = tsp.StatsID
WHERE tsp.ServerID = @ServerID;

DELETE tws FROM tbl_weapons_stats tws
INNER JOIN tbl_server_player tsp ON tws.StatsID = tsp.StatsID
WHERE tsp.ServerID = @ServerID;

DELETE ts FROM tbl_sessions ts
INNER JOIN tbl_server_player tsp  ON ts.StatsID = tsp.StatsID
WHERE tsp.ServerID = @ServerID;

DELETE tdt FROM tbl_dogtags tdt
INNER JOIN tbl_server_player tsp  ON tdt.KillerID = tsp.StatsID
WHERE tsp.ServerID = @ServerID;

[ImportBot]

Originally Posted by ty_ger07*:

 

All in the same database?

 

The following statement will delete all stats entries of a single server.

 

DO A BACKUP BEFORE EXECUTE THIS STATEMENT:

Code:

set @ServerID = 1;

DELETE tps FROM tbl_playerstats tps
INNER JOIN tbl_server_player tsp ON tps.StatsID = tsp.StatsID
WHERE tsp.ServerID = @ServerID;

DELETE tws FROM tbl_weapons_stats tws
INNER JOIN tbl_server_player tsp ON tws.StatsID = tsp.StatsID
WHERE tsp.ServerID = @ServerID;

DELETE ts FROM tbl_sessions ts
INNER JOIN tbl_server_player tsp  ON ts.StatsID = tsp.StatsID
WHERE tsp.ServerID = @ServerID;

DELETE tdt FROM tbl_dogtags tdt
INNER JOIN tbl_server_player tsp  ON tdt.KillerID = tsp.StatsID
WHERE tsp.ServerID = @ServerID;

Maybe I read wrong, but I thought he asked how to reset the stats for just one player in a server, not all stats for one server.

[ImportBot]

Originally Posted by terse85*:

 

@terse85

 

dont use a table suffix Should fix that problem. Delete all created tables before.

 

@24Flat

Please update to the latest version.

and now i get [19:03:53 24] [statslogger]Error: Error in Startstreaming:

[19:03:53 24] Message: Cannot add or update a child row: a foreign key constraint fails (`DATABASENAME`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[19:03:53 25] Native: -2147467259

[19:03:53 26] Source: MySql.Data

[19:03:53 26] StackTrace: ved MySql.Data.MySqlClient.MySqlStream.ReadPacket()

ved MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

ved MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

ved PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

[19:03:53 92] [statslogger]Error: Error in Startstreaming OuterException: System.NullReferenceException: Objektreferanse er ikke satt til en objektforekomst.

ved PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

ved PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

 

what now?

[ImportBot]

Originally Posted by ZeroKooL*:

 

Maybe I read wrong, but I thought he asked how to reset the stats for just one player in a server, not all stats for one server.

Nope, want to reset the server stats and after a week the player with the most points wins premium.

 

Thanks again XpKiller.

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

and now i get [19:03:53 24] [statslogger]Error: Error in Startstreaming:

[19:03:53 24] Message: Cannot add or update a child row: a foreign key constraint fails (`DATABASENAME`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[19:03:53 25] Native: -2147467259

[19:03:53 26] Source: MySql.Data

[19:03:53 26] StackTrace: ved MySql.Data.MySqlClient.MySqlStream.ReadPacket()

ved MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

ved MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

ved MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

ved MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

ved PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

[19:03:53 92] [statslogger]Error: Error in Startstreaming OuterException: System.NullReferenceException: Objektreferanse er ikke satt til en objektforekomst.

ved PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

ved PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

 

what now?

Same here xpkiller

 

as you told me i deleted the session tbl...without fixing it

then i installed all db new....didnt fix it

does it effect something or can i just ignore it?

 

[01:46:15 77] Message: Cannot add or update a child row: a foreign key constraint fails (`admin_bf4other2`.`tbl_sessions`, CONSTRAINT `fk_tbl_sessions_tbl_server_player` FOREIGN KEY (`StatsID`) REFERENCES `tbl_server_player` (`StatsID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[01:46:15 77] Native: -2147467259

[01:46:15 77] Source: MySql.Data

[01:46:15 77] 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.StartStreaming()

[ImportBot]

Originally Posted by Jamesonp*:

 

[18:32:57 38] [statslogger]Warning: PrepareKeywordDic: Mainkey SV98 not found!

[18:32:57 38] [statslogger]Warning: PrepareKeywordDic: Mainkey SVD not found!

[18:32:57 38] [statslogger]Warning: PrepareKeywordDic: Mainkey Steyr AUG not found!

[18:32:57 38] [statslogger]Warning: PrepareKeywordDic: Mainkey Taurus .44 not found!

[18:32:57 38] [statslogger]Warning: PrepareKeywordDic: Mainkey Type88 not found!

[18:32:57 38] [statslogger]Warning: PrepareKeywordDic: Mainkey USAS-12 not found!

[18:32:57 38] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/A91/A91 not found!

[18:32:57 38] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/AK74M/AK74 not found!

[18:32:57 38] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G36C/G36C not found!

[18:32:57 38] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G3A3/G3A3 not found!

I'm seeing this. Did I miss a step?

[ImportBot]

Originally Posted by XpKiller*:

 

@www.battleplay4u.com

 

Are there any other errors before that one?

[ImportBot]

Originally Posted by Belligerent*:

 

Hey,

 

Is there some way we can use the database that was created with the BF3 plugin with the new version?

 

I read way back that there would be a script?

 

Im having the issue with the "Unknown column GameID in field list"(also with AdKats)

 

Cheers.

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

hmmm ... yes one...buts thats a known bug with no effect i guess

(hmmm...ja einer...aber diese Nachricht/dieser Bug ist bekannt und soll keine Auswirkungen haben)

 

error2.png

 

at the end its only that one allone

(unterm strich ist es nur der eine)

[ImportBot]

Originally Posted by victory-Gamerz*:

 

Im sorry im total noob at this I created a database and a user for that database however what do i use for host name and port? I created the new database in the website with cpanel. where did i mes up?

[ImportBot]

Originally Posted by rbtmarshall*:

 

Im sorry im total noob at this I created a database and a user for that database however what do i use for host name and port? I created the new database in the website with cpanel. where did i mes up?

Use the Ip address for your hosting. when you log into cpanel the ip address should be in the address bar, or it shows in cpanel.

 

and the sql default port is 3306

[ImportBot]

Originally Posted by Kinsman*:

 

its also likely that localhost will work for the hostname, depending on your provider.

[ImportBot]

Originally Posted by Scheibes*:

 

Hallo,

 

ich hoffe hier gibts auch Deutschen Support.

 

Hab das Plugin installiert und die SQL Datenbank Logins eingetragen.

Bekomme aber folgende Fehlermeldung wenn ich das Plugin starte.

 

-----

[12:31:17 63] Error: System.TimeoutException: Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat ---> System.IO.IOException: Von der Übertragungsverbindung können keine Daten gelesen werden: Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat. ---> System.Net.Sockets.SocketException: Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat

bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

--- Ende der internen Ausnahmestapelüberwachung ---

bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

bei MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.Common.MyNetworkStream.HandleOrRethrowE xception(Exception e)

bei MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

bei MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)

bei System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)

bei MySql.Data.MySqlClient.MySqlStream.ReadFully(Strea m stream, Byte[] buffer, Int32 offset, Int32 count)

bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()

bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bei MySql.Data.MySqlClient.NativeDriver.Open()

bei MySql.Data.MySqlClient.Driver.Open()

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

bei MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

bei MySql.Data.MySqlClient.MySqlPool.GetConnection()

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[12:31:17 64] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[12:31:17 63] Error: System.TimeoutException: Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat ---> System.IO.IOException: Von der Übertragungsverbindung können keine Daten gelesen werden: Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat. ---> System.Net.Sockets.SocketException: Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat

bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

--- Ende der internen Ausnahmestapelüberwachung ---

bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

bei MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.Common.MyNetworkStream.HandleOrRethrowE xception(Exception e)

bei MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

bei MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)

bei System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)

bei MySql.Data.MySqlClient.MySqlStream.ReadFully(Strea m stream, Byte[] buffer, Int32 offset, Int32 count)

bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()

bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bei MySql.Data.MySqlClient.NativeDriver.Open()

bei MySql.Data.MySqlClient.Driver.Open()

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

bei MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

bei MySql.Data.MySqlClient.MySqlPool.GetConnection()

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[12:31:17 64] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()[12:31:17 63] Error: System.TimeoutException: Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat ---> System.IO.IOException: Von der Übertragungsverbindung können keine Daten gelesen werden: Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat. ---> System.Net.Sockets.SocketException: Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat

bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

--- Ende der internen Ausnahmestapelüberwachung ---

bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

bei MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.Common.MyNetworkStream.HandleOrRethrowE xception(Exception e)

bei MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

bei MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)

bei System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)

bei MySql.Data.MySqlClient.MySqlStream.ReadFully(Strea m stream, Byte[] buffer, Int32 offset, Int32 count)

bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()

bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bei MySql.Data.MySqlClient.NativeDriver.Open()

bei MySql.Data.MySqlClient.Driver.Open()

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

bei MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

bei MySql.Data.MySqlClient.MySqlPool.GetConnection()

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[12:31:17 64] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

------

 

 

Bitte um Hilfe!

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

Hi Scheibes,

 

bitte poste mal deinen Provider und oder deinen Tarif bei dem Provider, da es so scheint als ob deine Datenbank keinen Zugriff von außen erlaubt

[ImportBot]

Originally Posted by XpKiller*:

 

Same here xpkiller

 

as you told me i deleted the session tbl...without fixing it

then i installed all db new....didnt fix it

does it effect something or can i just ignore it?

 

[01:46:15 77] Message: Cannot add or update a child row: a foreign key constraint fails (`admin_bf4other2`.`tbl_sessions`, CONSTRAINT `fk_tbl_sessions_tbl_server_player` FOREIGN KEY (`StatsID`) REFERENCES `tbl_server_player` (`StatsID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[01:46:15 77] Native: -2147467259

[01:46:15 77] Source: MySql.Data

[01:46:15 77] 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.StartStreaming()

I found the problem what trigger that error. It will be fixed in the next version i release today.

[ImportBot]

Originally Posted by Scheibes*:

 

Mein Provider ist "webhoster.de"

 

Über diesen kleinen Provider betreibe ich eine Internetseite inkl MySQL Datenbank.

Habe nun für BF4 extra eine neue Datenbank inkl neuen Zugangsdaten angelegt.

 

Nur zum Verständnis, unter "Host" im Plugin muss der Zugang zu meinem Provider eingetragen werden, oder reicht hier "localhost" als Zugang für die Datenbank?

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

I found the problem what trigger that error. It will be fixed in the next version i release today.

saugeil^^

 

thx!

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

Mein Provider ist "webhoster.de"

 

Über diesen kleinen Provider betreibe ich eine Internetseite inkl MySQL Datenbank.

Habe nun für BF4 extra eine neue Datenbank inkl neuen Zugangsdaten angelegt.

 

Nur zum Verständnis, unter "Host" im Plugin muss der Zugang zu meinem Provider eingetragen werden, oder reicht hier "localhost" als Zugang für die Datenbank?

wenn du die starter hast wird das nicht funktionieren da ein zugriff von extern nicht unterstützt wird (INNODB)

 

Es ist entweder eine IP oder ein "Name" wie z.B statsdb.battleplay4u.com