Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Could someone explain to me what version of plugin we should use on our BF3 server ?

This or showthread....er-1-1-0-1-BF3* ?

This version. Not the other version.

[ImportBot]

Originally Posted by ACN3*:

 

[17:37:46 82] Error in Tablebuilder:

[17:37:46 82] Message: Unable to connect to any of the specified MySQL hosts.

[17:37:46 82] Native: -2147467259

[17:37:46 82] Source: MySql.Data

[17:37:46 82] StackTrace: at MySql.Data.MySqlClient.NativeDriver.Open()

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

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

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

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

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

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

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

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[17:37:46 82] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

Anybody can help-me? What i'm wrong?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Anybody can help-me? What i'm wrong?

Confirm you have the correct database url, it cannot connect to whatever address you gave it.

[ImportBot]

Originally Posted by ACN3*:

 

Confirm you have the correct database url, it cannot connect to whatever address you gave it.

Thank you for reply, the address is correct, I put localhost on port 3306, because stay in the same server.

[ImportBot]

Originally Posted by ty_ger07*:

 

Thank you for reply, the address is correct, I put localhost on port 3306, because stay in the same server.

Is it your server or a rented server? If it is a rented server, don't assume anything. It might not be localhost due to virtualized servers and load balancing. The database may be on a different machine with a different address. Check the ip address of the database in phpmyadmin.

[ImportBot]

Originally Posted by ACN3*:

 

Is it your server or a rented server? If it is a rented server, don't assume anything. It might not be localhost due to virtualized servers and load balancing. The database may be on a different machine with a different address. Check the ip address of the database in phpmyadmin.

Well, it's a rent server and database not stay in the same server. I Found the real IP and now its work!

 

Thank you for help, ty_ger07 and ColColonCleaner.

[ImportBot]

Originally Posted by st0k4*:

 

//edit : I found the problem. Have Copy & Past the login data.Entered manually

just,and its work.Overlooked blanks.

 

Hi , is this a problem with my Provider or my mistake ? Mysql login date are registered

(Provider: G-Portal ProConLayer , Server Version: 5.5.35-0+wheezy1-log - (Debian)

 

 

 

[10:25:25 05] Message: Authentication to host '1XX.XX.XXX.XXX' for user 'db_XXXXXX_X

 

' using method 'mysql_native_password' failed with message: Access denied for user 'db_XXXXXX_X

 

'@'94.XXX:XXX:XX' (using password: YES)

[10:25:25 05] Native: -2147467259

[10:25:25 05] Source: MySql.Data

[10:25:25 05] StackTrace: bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.AuthenticationFailed(Exception ex)

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)

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()

[10:25:25 05] InnerException: MySql.Data.MySqlClient.MySqlException: Access denied for user 'db_XXXXXX_X

 

'@'94.XXX:XXX:XX' (using password: YES)

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

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

[10:25:25 05] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[10:25:25 05] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Authentication to host '1XX.XX.XXX.XXX' for user 'db_XXXXXX_X

 

' using method 'mysql_native_password' failed with message: Access denied for user 'db_XXXXXX_X

 

 

 

'@'94.XXX:XXX:XX' (using password: YES) ---> MySql.Data.MySqlClient.MySqlException: Access denied for user 'db_XXXXXX_X

 

 

'@'94.XXX:XXX:XX' (using password: YES)

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

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

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

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.AuthenticationFailed(Exception ex)

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)

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.getUpdateServerI D(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by DonnyBresko*:

 

I have a problem.

 

i put in my MySQL login data and Procon give me the following Error:

 

[03:49:32] procon.plugin.onConsole -8587891330894385885 Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[03:49:32] procon.plugin.onConsole -8587891330894385885 [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Call to GetHostEntry failed after 00:00:00 while querying for hostname 'db546576412.db.1and1.com': SocketErrorCode=NoData, ErrorCode=11004, NativeErrorCode=11004. ---> System.Net.Sockets.SocketException: The requested name is valid, but no data of the requested type was found

at System.Net.Dns.GetAddrInfo(String name)

at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)

at System.Net.Dns.GetHostEntry(String hostNameOrAddress)

at MySql.Data.Common.StreamCreator.GetDnsHostEntry(St ring hostname)

--- End of inner exception stack trace ---

at MySql.Data.Common.StreamCreator.GetDnsHostEntry(St ring hostname)

at MySql.Data.Common.StreamCreator.GetHostEntry(Strin g hostname)

at MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

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

--- End of inner exception stack trace ---

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

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

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

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

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

[03:49:32] OK

[03:49:32] OK

I checked my MySQL data many times all data are correct in the plugin.

 

MySQL Version:

5.1.73-log

 

Supports:

InnoDB

MRG_MYISAM

BLACKHOLE

CSV

MEMORY

FEDERATED

ARCHIVE

MyISAM

 

 

I hope someone can solove my problem

 

 

Some Information he server has NO ENDED Round untill now The Server is brand new

[ImportBot]

Originally Posted by Breakmaster*:

 

Hi,

 

i have a new MySQL Server (Nitrado MySQL DB) and there comes for fresh install this Error:

 

[17:56:45 44] [statslogger]Error: Error in Startstreaming:

[17:56:45 44] Message: Cannot add or update a child row: a foreign key constraint fails (`ni7495_2_DB`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[17:56:45 44] Native: -2147467259

[17:56:45 44] Source: MySql.Data

[17:56:45 44] 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()

[17:56:45 91] [statslogger]Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

 

 

The tables are created, but have no content.

Whats wrong here?

Procon Layer 1.4.2.4

BF4

Provider: Nitrado

[ImportBot]

Originally Posted by bakust*:

 

Hi guys, i would want to say if i can get the total players of last 7 days, maybe via an sql query into database

 

Thanks

[ImportBot]

Originally Posted by DieElite999*:

 

[22:51:06 66] Error: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

bei System.Security.CodeAccessPermission.Demand()

bei System.Net.Sockets.Socket.CheckCacheRemote(EndPoin t& remoteEP, Boolean isOverwrite)

bei System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)

bei System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)

bei MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

bei MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

bei MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

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.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

Die Aktion, bei der ein Fehler aufgetreten ist:

Demand

Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:

System.Net.SocketPermission

Die Zone der Assembly, bei der ein Fehler aufgetreten ist:

MyComputer

[22:51:06 66] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[22:51:06 69] [statslogger]Error: getUpdateServerID1: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

bei System.Security.CodeAccessPermission.Demand()

bei System.Net.Sockets.Socket.CheckCacheRemote(EndPoin t& remoteEP, Boolean isOverwrite)

bei System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)

bei System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)

bei MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

bei MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

bei MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

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.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

Die Aktion, bei der ein Fehler aufgetreten ist:

Demand

Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:

System.Net.SocketPermission

Die Zone der Assembly, bei der ein Fehler aufgetreten ist:

MyComputer

[22:51:15 65] Error: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

bei System.Security.CodeAccessPermission.Demand()

bei System.Net.Sockets.Socket.CheckCacheRemote(EndPoin t& remoteEP, Boolean isOverwrite)

bei System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)

bei System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)

bei MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

bei MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

bei MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

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.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

Die Aktion, bei der ein Fehler aufgetreten ist:

Demand

Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:

System.Net.SocketPermission

Die Zone der Assembly, bei der ein Fehler aufgetreten ist:

MyComputer

[22:51:15 65] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[22:51:15 68] [statslogger]Error: getUpdateServerID1: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

bei System.Security.CodeAccessPermission.Demand()

bei System.Net.Sockets.Socket.CheckCacheRemote(EndPoin t& remoteEP, Boolean isOverwrite)

bei System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)

bei System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)

bei MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

bei MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

bei MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

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.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

Die Aktion, bei der ein Fehler aufgetreten ist:

Demand

Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:

System.Net.SocketPermission

Die Zone der Assembly, bei der ein Fehler aufgetreten ist:

MyComputer

 

kann mir da bitte einer helfen

was ist das für ein fehler ich bekomms einfach nicht hin

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Hi guys, i would want to say if i can get the total players of last 7 days, maybe via an sql query into database

 

Thanks

You mean total unique players through the server in the past 7 days?

[ImportBot]

Originally Posted by Stoertebecker*:

 

Hi, in the config I see the option "MapStats ON_". Somebody can tell me what this option for?

 

Thx in advance.

[ImportBot]

Originally Posted by berserker_ny*:

 

i just had this same problem....

 

what fixed mine had to deal with the dropdown box in the plugin settings where you put the database info

make sure you did not hit enter after your entry...if you did, just backspace until you are at the end of your entry....

 

the reason this is, i found, is that if you hit "enter" after your entry, in your config file for the plugin your entries will have "\r\n" at the end...

 

if you have access to your config file, open it up and have a look there(you can edit it here also)

[ImportBot]

Originally Posted by Stoertebecker*:

 

Morning all. I am new to this plugin, so 2 questions:

 

1. The option "MapStats ON_". Somebody can tell me what this option for?

 

2. I saw on one server at the end of the round a kind of statistic... best player.... player with most kills... player with most deaths.... Is this also part of this plugin?

[ImportBot]

Originally Posted by ty_ger07*:

 

Morning all. I am new to this plugin, so 2 questions:

 

1. The option "MapStats ON_". Somebody can tell me what this option for?

It turns map stats on.

 

You know... like how many time each map has been played and which game modes...

[ImportBot]

Originally Posted by Stoertebecker*:

 

Ok.. thx. Regarding the 2nd point. Is there any possibility to show at round end a statistic in the chat with best player, most kills, most deaths, etc...?

[ImportBot]

Originally Posted by ty_ger07*:

 

Ok.. thx. Regarding the 2nd point. Is there any possibility to show at round end a statistic in the chat with best player, most kills, most deaths, etc...?

I am not sure what you are asking.

 

The best player of... that round? that day? that week? best ever?

 

There are other plugins for showing end of round stats.

[ImportBot]

Originally Posted by durangod*:

 

here is what i get..

 

[17:38:52 79] Source: MySql.Data

[17:38:52 79] StackTrace: at MySql.Data.MySqlClient.NativeDriver.Open()

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

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

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

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

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

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

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[17:38:52 79] InnerException: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 108.170.3.19:3306

at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

at MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

at MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

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

[17:38:52 79] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

do i need to allow 3306 in my configserv firewall

 

3306 tcp is already open

[ImportBot]

Originally Posted by m1ndw4lker*:

 

Ok.. thx. Regarding the 2nd point. Is there any possibility to show at round end a statistic in the chat with best player, most kills, most deaths, etc...?

this can be done with ProconRulz for example, see following link:

 

myrcon.net/.../proconrulz-end-of-round-stats-v10

[ImportBot]

Originally Posted by ssalghazal*:

 

can someone help all my stats are gone but stats for all other players and server seems to fine. what is the issue?

[ImportBot]

Originally Posted by durangod*:

 

If your having issues with setting this up for GS (gameservers.com), i hope this will help you.

 

post 25 and 26

 

showthread....l=1#post110199*

[ImportBot]

Originally Posted by ssalghazal*:

 

If your having issues with setting this up for GS (gameservers.com), i hope this will help you.

 

post 25 and 26

 

showthread....l=1#post110199*

Thanks but that didnt help i dont have issues with gameserver.com connection to my layer, the plugin works fine but i dont know why for some players the stats get rest or deleted. I found some duplicate names for some players though in my database i don't know if that is the issue. maybe the plugin creates a new stats for some players instead of using the previous ones.

[ImportBot]

Originally Posted by durangod*:

 

@ssal sorry i was not replying to yours, i was making a general comment to help others as i went thru this myself. That is the best time to make notes. Sorry for the confusion

[ImportBot]

Originally Posted by leibhold*:

 

The duplicate names did they have the same GUID for PB and EA ?

[ImportBot]

Originally Posted by durangod*:

 

Finally i got my deal going. After adding everyip i knew with the servers to the mysql remote whitelist, still didnt work. So then i added those ips to my configserver serverfirewall exception list and WHAMMO got it going... whoo hooo. ADKats here i come lol

[ImportBot]

Originally Posted by bakust*:

 

Guys, i have a problem to copy the database from one provider to another, all are PhpMyAdmin but when i try to upload the zip with the database, i got this error:

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

 

So i tried to manually add the database to the new server: first i copied the structure of the table and then i filled one table at once, but when i try to fill tbl_player_stats (and another 3 tables) i got an error that tell me that the foreign key ecc ecc

 

How can i solve this problem?

[ImportBot]

Originally Posted by ty_ger07*:

 

Guys, i have a problem to copy the database from one provider to another, all are PhpMyAdmin but when i try to upload the zip with the database, i got this error:

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

 

So i tried to manually add the database to the new server: first i copied the structure of the table and then i filled one table at once, but when i try to fill tbl_player_stats (and another 3 tables) i got an error that tell me that the foreign key ecc ecc

 

How can i solve this problem?

Contact your server provider. It sounds like their phpmyadmin installation is messed up or is being overloaded by your large database.

 

Importing one complete table one at a time will be very problematic for you due to foreign key constraints linking to tables which have not yet been imported. Can you give your server host a copy of your database and have them do it directly for you on their end?

 

Otherwise, you could try importing something like 500 rows of all tables, then import the next 500, and so on.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

hi , we migrated BB to dedicated server and started having this error , but its connecting looks like

 

[17:42:38 09] [statslogger]Error: LogChat:

[17:42:38 09] Message: The user specified as a definer ('decojobs'@'localhost') does not exist

[17:42:38 09] Native: -2147467259

[17:42:38 09] Source: MySql.Data

[17:42:38 09] 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.LogChat(String strSpeaker, String strMessage, String strType)

[17:42:38 09] [statslogger]Error: LogChat_2: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.LogChat(String strSpeaker, String strMessage, String strType)

plz help

[ImportBot]

Originally Posted by ty_ger07*:

 

hi , we migrated BB to dedicated server and started having this error , but its connecting looks like

 

 

 

plz help

Either your database user name is not 'decojobs' or your database location is not 'localhost'.