MySQL Account.uid save as DMS_PersistentVehicle

1 post in this topic

Whenever I start the server after installing a clean database, the first player to join will be inserted into the DB with DMS_PersistentVehicle for the accounts table uid and name.
EXTDB Logs show this


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

[18:39:21:579236 +11:00] [Thread 5044] extDB2: Database Type: MySQL
[18:39:21:584545 +11:00] [Thread 5044] extDB2: Database Session Pool Started
[18:39:21:586696 +11:00] [Thread 5044] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\ozzygamingservices\arma3\@ExileServer\extDB\sql_custom_v2\exile.ini
[18:39:21:586905 +11:00] [Thread 5044] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[18:43:01:210512 +11:00] [Thread 5044] 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 = ?
[18:43:01:210773 +11:00] [Thread 5044] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:43:01:210799 +11:00] [Thread 5044] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:xxxxxxxxxxxxxxxxx:RedHorizon

The Foreign key is obviously having issues because the uid is not INT(11) its DMS_PersistentVehicle.

The sqlmode is correct as seen here 428014a626.png


Any ideas as to what may be going wrong?

Edited by RedHorizon

Share this post

Link to post
Share on other sites

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.