• 0
An_A3_Player

DB Error

Question

Not 100% sure what this means but my server keeps saying Error: Bambi creation timeout and in the DB log folder it has this in the file

extDB2: Found extdb-conf.ini
extDB2: Detected 24 Cores, Setting up 10 Worker Threads


[21:17:17:868993 --7:00] [Thread 4456] extDB2: Database Type: MySQL
[21:17:17:875461 --7:00] [Thread 4456] extDB2: Database Session Pool Started
[21:17:17:878146 --7:00] [Thread 4456] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Arma3Servers\Exile\@ExileServer\extDB\sql_custom_v2\exile.ini
[21:17:17:878551 --7:00] [Thread 4456] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[21:20:34:499646 --7:00] [Thread 4456] 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 = ?
[21:20:34:499930 --7:00] [Thread 4456] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[21:20:34:499975 --7:00] [Thread 4456] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198146432597:An A3 Player

Note: This is happening before players get in the server for the first time. I followed a tutorial on here on how to set up a exile server and I am using all new server files from the download on this website.

Edited by An_A3_Player
Added something i forgot to say

Share this post


Link to post
Share on other sites

5 answers to this question

  • 0

Hi not beeing an ExtDB Expert myself,

there might be 2 issues

a) assigned items has no default value assigned to in the table schema and the sql of the script is not assigning a value to it.

b) the delete statement which normaly happens after a player died hasn't been executed because of the server crash.

You should have a look at the table player and maybe delete the entry with uid = 

76561198146432597

By the way - 24 cores - ^^wow

Edited by frobbert

Share this post


Link to post
Share on other sites
Advertisement
  • 0

@An_A3_Player,

#1 - Make 100% sure you have the 'strict mode' OFF.  Look it up if you do not know what I mean.

#2 - Make 100% sure that you ran the CORRECT SQL 'batch file' to setup the DB for Exile.

:)

 

Share this post


Link to post
Share on other sites
  • 0

Yeah I'm with Z80CPU on this one. Doesn't look like you setup your DB correctly. Either it isn't connecting to it, the DB isn't running, or you're missing something server side,

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.