On Non-Creating Database

[Dick Kickem 2]

Hello again.

I am having ANOTHER problem with my database. (Old news, right?)

I'm getting this error in my RPT:

Quote

1:31:25 "ExileServer - Starting session for 'bluebart' with ID 'BRRpPjFJ'..."
 1:31:28 Error in expression <llExtension _query);
(_result select 1) select 0>
 1:31:28   Error position: <select 0>
 1:31:28   Error Generic error in expression
 1:31:28 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16
 1:31:28 Error in expression <llExtension _query);
(_result select 1) select 0>
 1:31:28   Error position: <select 0>
 1:31:28   Error Generic error in expression
 1:31:28 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16
 

My extDB log:

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 16 Cores, Setting up 6 Worker Threads

[23:25:26:526794 --4:00] [Thread 4332] extDB2: Database Type: MySQL
[23:25:26:538794 --4:00] [Thread 4332] extDB2: Database Session Pool Started
[23:25:26:542795 --4:00] [Thread 4332] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\TCAFiles\Users\RyanB\105\@ExileServer\extDB\sql_custom_v2\exile.ini
[23:25:26:542795 --4:00] [Thread 4332] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[23:45:32:650780 --4:00] [Thread 4332] 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 (`ryanb2362exile`.`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:45:32:650780 --4:00] [Thread 4332] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:45:32:650780 --4:00] [Thread 4332] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198002569124:Maj Mancock
[23:46:32:236188 --4:00] [Thread 4332] 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 (`ryanb2362exile`.`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:46:32:236188 --4:00] [Thread 4332] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:46:32:236188 --4:00] [Thread 4332] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198002569124:Maj Mancock
[23:46:34:686328 --4:00] [Thread 4332] 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 (`ryanb2362exile`.`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:46:34:686328 --4:00] [Thread 4332] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:46:34:686328 --4:00] [Thread 4332] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561197980076345:Extreme
[01:31:28:948340 --4:00] [Thread 4332] 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 (`ryanb2362exile`.`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 = ?
[01:31:28:948340 --4:00] [Thread 4332] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[01:31:28:948340 --4:00] [Thread 4332] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561197983891785:bluebart

Any help would be apprecitated!

Thanks!

[yellow|avdieking 40]

maybe do this 

FROM
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
TO
# Set the SQL mode to strict
sql-mode=""

[Dick Kickem 2]

3 hours ago, yellow|avdieking said:

maybe do this 

FROM
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
TO
# Set the SQL mode to strict
sql-mode=""

Where is this?

[TheRedAfro 0]

The file you are looking for to find that parameter (?) is located in your ProgramData\MySQL\MySQL Server 5.7 directory and is labeled my(dot)ini; if you have trouble getting the file to save after making the change and if using notepad++, notepad++ may ask if you want to open up a session as an administrator; if so, yes; if not, do so by right clicking notepad++ and running as admin, then open file, make change and save; one last option if that is not available is to change the user settings of my(dot)ini via the properties, security tab, under group or user names, edit, highlight Users (YOURMACHINENAME\Users), check all the boxes under allow, apply, make change to the file, save and revert user settings back in the realm of 'putting things back the way we found them'; that's kind of rushed but read it a couple of times and it'll will hoepfully click;

Granted, this is just to get the change mentioned and if that's the culprit. If not, that's all my bag of tricks has at the moment.

best of luck

[Dick Kickem 2]

17 hours ago, TheRedAfro said:

The file you are looking for to find that parameter (?) is located in your ProgramData\MySQL\MySQL Server 5.7 directory and is labeled my(dot)ini; if you have trouble getting the file to save after making the change and if using notepad++, notepad++ may ask if you want to open up a session as an administrator; if so, yes; if not, do so by right clicking notepad++ and running as admin, then open file, make change and save; one last option if that is not available is to change the user settings of my(dot)ini via the properties, security tab, under group or user names, edit, highlight Users (YOURMACHINENAME\Users), check all the boxes under allow, apply, make change to the file, save and revert user settings back in the realm of 'putting things back the way we found them'; that's kind of rushed but read it a couple of times and it'll will hoepfully click;

Granted, this is just to get the change mentioned and if that's the culprit. If not, that's all my bag of tricks has at the moment.

best of luck

I find this on the server or on my client?

[ka0s 457]

17 minutes ago, Dick Kickem said:

I find this on the server or on my client?

On the server yes, 

Inside my.ini search for "strict" then you'll find it, change it so it looks like this: 

[Dick Kickem 2]

4 hours ago, ka0s said:

On the server yes, 

Inside my.ini search for "strict" then you'll find it, change it so it looks like this: 

I run my server through a provider...is there any other way? I can't access these files. Maybe I should take it up with the provider?