king5055

Cannot connect to server from multiple errors

4 posts in this topic

Posted (edited)

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 by king5055
Topic changed

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites
Advertisement

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

Share this post


Link to post
Share on other sites

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: 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: 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!

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.