Timber 17 Report post Posted April 30, 2016 (edited) I am having an issue with some players not being able to join. It is a fresh server and there have been 3 of us in the database for a week now, but tonight a couple f new players tried to join and they got a time out on requesting bambi character. I searched through the logs and found this. rpt file 0:03:24 "ExileServer - Starting session for '[=UWS=]DJNPHOTO' with ID 'QhRhKqdp'..." 0:03:25 Error in expression <llExtension _query); (_result select 1) select 0> 0:03:25 Error position: <select 0> 0:03:25 Error Generic error in expression 0:03:25 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16 0:03:25 Error in expression <llExtension _query); (_result select 1) select 0> 0:03:25 Error position: <select 0> 0:03:25 Error Generic error in expression 0:03:25 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16 MySQL database logs [23:36:53:237732 --3:00] [Thread 7560] extDB2: Database Type: MySQL [23:36:53:241732 --3:00] [Thread 7560] extDB2: Database Session Pool Started [23:36:53:243732 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\ExileServ2\@exileServer\extDB\sql_custom_v2\exile.ini [23:36:53:244732 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available [23:37:50:841026 --3:00] [Thread 7560] 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 (`exilenam`.`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 = ? [23:37:50:841026 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [23:37:50:841026 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198015699207:[=UWS=]DJNPHOTO [23:41:57:282122 --3:00] [Thread 7560] 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 (`exilenam`.`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 = ? [23:41:57:282122 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [23:41:57:282122 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561197961975287:Wysper [23:42:30:288010 --3:00] [Thread 7560] 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 (`exilenam`.`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 = ? [23:42:30:288010 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [23:42:30:288010 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198015699207:[=UWS=]DJNPHOTO [23:50:51:127656 --3:00] [Thread 7560] 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 (`exilenam`.`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 = ? [23:50:51:127656 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [23:50:51:127656 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561197961975287:Wysper [23:52:52:314588 --3:00] [Thread 7560] 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 (`exilenam`.`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 = ? [23:52:52:314588 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [23:52:52:314588 --3:00] [Thread 7560] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198015699207:[=UWS=]DJNPHOTO [23:55:43:179361 --3:00] [Thread 7560] extDB2: Stopping ... My guess is that the dbase cannot create the new entries, but I have no idea why not...Can anyone help? Edited April 30, 2016 by Timber Share this post Link to post Share on other sites
-= TGM =- 1 Report post Posted April 30, 2016 Hello! I have the same problem on my server. But only some of the players get this, some can join! Anyone have a solution for this? Share this post Link to post Share on other sites
Harper9690 0 Report post Posted April 30, 2016 Getting the same message with a single player, all others can join. Any help? Started randomly today. Share this post Link to post Share on other sites
Timber 17 Report post Posted May 2, 2016 (edited) I can confirm removing CBA solved my issue. I am running Joint Rails server side. You get an error with CUP crying about requiring CBA on server boot, but hit ok and everything seems to work fine with JR Seems that me and a couple of others had joined prior to adding CBA to the server. After the addition, no new players could be added to the database, however, players that existed in the dbase prior to, could still join and their progress was saved. I cant explain why..thats just what happened... Edited May 2, 2016 by Timber Share this post Link to post Share on other sites
StokesMagee 871 Report post Posted May 2, 2016 48 minutes ago, Timber said: I can confirm removing CBA solved my issue. I am running Joint Rails server side. You get an error with CUP crying about requiring CBA on server boot, but hit ok and everything seems to work fine with JR Seems that me and a couple of others had joined prior to adding CBA to the server. After the addition, no new players could be added to the database, however, players that existed in the dbase prior to, could still join and their progress was saved. I cant explain why..thats just what happened... FYI, joint rails and CBA are the exact same thing, CBA just has more functions. Share this post Link to post Share on other sites
[OMG]Slim 62 Report post Posted May 3, 2016 Lol, if you guys would use search function you would find a fix to CBA problems. And yeah you can overcome CBA isssues with GUN MODS using JR but CBA is needed for a lot more than just guns. Share this post Link to post Share on other sites