Dick Kickem

On Non-Creating Database

7 posts in this topic

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!

Share this post


Link to post
Share on other sites

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=""

Share this post


Link to post
Share on other sites
Advertisement
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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
17 minutes ago, Dick Kickem said:

I find this on the server or on my client?

On the server yes, 

screenshot.158.thumb.jpg.50085b91583f55b

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

screenshot.159.jpg.673df54d89af43351503d

Share this post


Link to post
Share on other sites
4 hours ago, ka0s said:

On the server yes, 

screenshot.158.thumb.jpg.50085b91583f55b

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

screenshot.159.jpg.673df54d89af43351503d

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?

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.