Cannot connect to server from multiple errors

[king5055 0]

Hey I was recently making an exile server and came across an error when making the database, "foreign key constraint", in MySQL workbench. The error also came up for extDB2 when I started the server (check spoiler). If someone knows how I can fix this, it would be great!

Some details that may come in handy:

Server hosted on a dedicated server

MySQL server is hosted by XAMPP

Hosted using windows server 2012 R2

Spoiler

extDB2: Version: 70

extDB2: https://github.com/Torndeco/extDB2

extDB2: Windows Version

Message: All development for extDB2 is done on a Linux Dedicated Server

Message: If you would like to Donate to extDB2 Development

Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2

Message: Also leave a message if there is any particular feature you would like to see added.

Message: Thanks for all the people that have donated.

Message: Torndeco: 20/02/15

 

 

extDB2: Found extdb-conf.ini

extDB2: Detected 8 Cores, Setting up 6 Worker Threads

 

 

[14:02:53:791370 +00:-1] [Thread 6128] extDB2: Database Type: MySQL

[14:02:53:802425 +00:-1] [Thread 6128] extDB2: Database Session Pool Started

[14:02:53:804921 +00:-1] [Thread 6128] extDB2: SQL_CUSTOM_V2: Loading Template Filename: D:\ARMA3\[s2]exile\@ExileServer\extDB\sql_custom_v2\exile.ini

[14:02:53:805188 +00:-1] [Thread 6128] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available

[14:51:23:303460 +00:-1] [Thread 6128] 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 = ?

[14:51:23:303609 +00:-1] [Thread 6128] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session

[14:51:23:303655 +00:-1] [Thread 6128] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198050581713:Arran

any help is greatly appreciated!

Edited June 5, 2016 by king5055
Topic changed

[king5055 0]

Update on the situation, after many changes it is still not working. I changed from XAMPP to MySQL Community Server and that seems to have fixed the foreign key constraint when creating the database. However, I get the error when I truncate the database (what for now is not the number 1 priority to fix as I can drop and recreate the tables for now) and I have a new extDB2 error (check spoiler).

Spoiler

extDB2: Version: 70
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15

extDB2: Found extdb-conf.ini
extDB2: Detected 8 Cores, Setting up 6 Worker Threads

[18:43:58:337176 +00:-1] [Thread 6628] extDB2: Database Type: MySQL
[18:43:58:342965 +00:-1] [Thread 6628] extDB2: Database Session Pool Started
[18:43:58:346936 +00:-1] [Thread 6628] extDB2: SQL_CUSTOM_V2: Loading Template Filename: D:\ARMA3\[s2]exile\@ExileServer\extDB\sql_custom_v2\exile.ini
[18:43:58:347373 +00:-1] [Thread 6628] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[18:44:29:819614 +00:-1] [Thread 6628] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error    [mysql_stmt_error]: Field 'assigned_items' doesn't have a default value    [mysql_stmt_errno]: 1364    [mysql_stmt_sqlstate]: HY000    [statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[18:44:29:819773 +00:-1] [Thread 6628] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:44:29:819812 +00:-1] [Thread 6628] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198050581713:Arran
[18:44:32:413675 +00:-1] [Thread 6628] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error    [mysql_stmt_error]: Field 'assigned_items' doesn't have a default value    [mysql_stmt_errno]: 1364    [mysql_stmt_sqlstate]: HY000    [statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[18:44:32:413827 +00:-1] [Thread 6628] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:44:32:413863 +00:-1] [Thread 6628] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198123812333:BALLY[FR]

 

Any help is greatly appreciated and welcomed!

[king5055 0]

Just an update the server will sometimes allow 1 player to join but no one else as it won't allow them to create their character

[king5055 0]

Just another update on the situation, seems to be extDB2 that is the problem and it communiating with the database: http://pastebin.com/2LhdLjBD

 

Spoiler

extDB2: Version: 70

extDB2: https://github.com/Torndeco/extDB2

extDB2: Windows Version

Message: All development for extDB2 is done on a Linux Dedicated Server

Message: If you would like to Donate to extDB2 Development

Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2

Message: Also leave a message if there is any particular feature you would like to see added.

Message: Thanks for all the people that have donated.

Message: Torndeco: 20/02/15

 

 

extDB2: Found extdb-conf.ini

extDB2: Detected 8 Cores, Setting up 6 Worker Threads

 

 

[19:39:46:704798 +00:-1] [Thread 3696] extDB2: Database Type: MySQL

[19:39:46:715396 +00:-1] [Thread 3696] extDB2: Database Session Pool Started

[19:39:46:716229 +00:-1] [Thread 3696] extDB2: SQL_CUSTOM_V2: Loading Template Filename: D:\ARMA3\[s2]exile\@ExileServer\extDB\sql_custom_v2\exile.ini

[19:39:46:716316 +00:-1] [Thread 3696] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available

[19:40:31:376607 +00:-1] [Thread 3696] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Field 'assigned_items' doesn't have a default value [mysql_stmt_errno]: 1364    [mysql_stmt_sqlstate]: HY000    [statemnt]: INSERT INTO player SET account_uid = ?, name = ?

[19:40:31:376759 +00:-1] [Thread 3696] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session

[19:40:31:376796 +00:-1] [Thread 3696] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198050581713:Arran

[19:40:51:238708 +00:-1] [Thread 3696] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Field 'assigned_items' doesn't have a default value [mysql_stmt_errno]: 1364    [mysql_stmt_sqlstate]: HY000    [statemnt]: INSERT INTO player SET account_uid = ?, name = ?

[19:40:51:238824 +00:-1] [Thread 3696] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session

[19:40:51:238854 +00:-1] [Thread 3696] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198123812333:BALLY[FR]

Any help is greatly appreciated and welcomed!