MySQL Problems

[Kitty 4]

hello after day long working i give up now i need help about the MySQL uptade.

Error log

 

[03:56:06:761300 +02:00] [Thread 1944] extDB2: Database Type: MySQL
[03:56:06:772300 +02:00] [Thread 1944] extDB2: Database Session Pool Started
[03:56:06:774300 +02:00] [Thread 1944] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Arma 3\arma3\@ExileServer\extDB\sql_custom_v2\exile.ini
[03:56:06:774300 +02:00] [Thread 1944] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[03:57:06:366709 +02:00] [Thread 1944] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exile`.`player`, CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)	[mysql_stmt_errno]: 1452	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[03:57:06:367709 +02:00] [Thread 1944] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[03:57:06:367709 +02:00] [Thread 1944] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:************:*******

 

the strict mode is alredy deactive (this say the guy that deactive it) i hope for qick help and yes call me a dummy im not in the SQL thinks

 

btw sorry for my bad eng

Edited January 10, 2016 by Kitty

[ez3kiel 3]

i have the same problems atm. i cannot remember that i changed something related ...

[11:05:39:650098 +02:00] [Thread 13520] extDB2: SQL_CUSTOM_V2: Loading Template Filename: D:\TCAFiles\Users\ThomasM\969\@exileserver\extDB\sql_custom_v2\exile.ini
[11:05:39:650344 +02:00] [Thread 13520] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[11:10:39:453806 +02:00] [Thread 13520] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error[mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exile_db`.`player`, CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)[mysql_stmt_errno]: 1452[mysql_stmt_sqlstate]: 23000[statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[11:10:39:453949 +02:00] [Thread 13520] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:10:39:453980 +02:00] [Thread 13520] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:************************

 

Edited January 10, 2016 by ez3kiel

[ez3kiel 3]

ok the following solved this for me:

- i disabled @cba_a3 serverside
- i put @asdg_JR instead of it serverside

clients can now have cba_a3 because it has asdg_JR in it. a little dirty, but works ...

[Kitty 4]

ohwow if this works.. i try now