• 0
Kitty

MySQL Problems

Question

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 by Kitty

Share this post


Link to post
Share on other sites

3 answers to this question

  • 0

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 by ez3kiel

Share this post


Link to post
Share on other sites
  • 0

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 ...

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.