• 0
Ghostyy

Error: Bambi Creation Timeout

Question

I have been having this problem for the past hour and can't seem to work it out. 
As the title suggests... I have checked the other threads and tried the other fixes suggested. 

I ran a server a few months ago and didn't have this issue. Everything went smooth.

RPT Log - http://pastebin.com/rqy44mJC

Mostly worried about this particular section of the RPT Log. The rest seems normal.

 8:54:04 "ExileServer - Starting session for '[FRAC]Ghostyy' with ID 'zpXvqhIf'..."
 8:54:53 Error in expression <llExtension _query);
(_result select 1) select 0>
 8:54:53   Error position: <select 0>
 8:54:53   Error Generic error in expression
 8:54:53 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16
 8:54:53 Error in expression <llExtension _query);
(_result select 1) select 0>
 8:54:53   Error position: <select 0>
 8:54:53   Error Generic error in expression
 8:54:53 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16

The above comes up every time I try to join.
So about 1min after picking a spawn location it comes up with the error.

I tried turning Strict mode off first. Didn't work. (my.ini and my_default.ini)
I made sure I was using the latest exile.ini and even replaced the whole file with the one out of the original download rar.
I am also deleting myself from the database every time this happens to make sure that isn't the issue.

Below is the latest extDB2 log file too, incase that might hold some significance.

[09:36:11:770325 +01:00] [Thread 14120] extDB2: Database Type: MySQL
[09:36:11:782084 +01:00] [Thread 14120] extDB2: Database Session Pool Started
[09:36:11:783953 +01:00] [Thread 14120] extDB2: SQL_CUSTOM_V2: Loading Template Filename: G:\Servers\ArmA3\A3Exile\@ExileServer\extDB\sql_custom_v2\exile.ini
[09:36:11:784111 +01:00] [Thread 14120] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[09:41:09:359017 +01:00] [Thread 14120] 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 = ?
[09:41:09:359475 +01:00] [Thread 14120] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[09:41:09:359500 +01:00] [Thread 14120] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198124384523:[FRAC]Ghostyy

Running on Windows with WAMP (MySQL 5.7.9) Latest version of Exile with Emergency fixes added.
Just to clarify, brand new install (No previous versions ever run on this PC.) and fresh installs of MySQL and all other components. No mods other than Infistar and Exile. Along with BEC.


Any help would be appreciated.

Regards,

Edited by Ghostyy

Share this post


Link to post
Share on other sites

3 answers to this question

  • 0

Reinstalled MySQL Element of WAMP after trying almost everything I could think of. It then defaulted the configs and found the sql_mode param in my.ini.

Removing Strict does fix the issue. Strict is used for database safety and security.

Share this post


Link to post
Share on other sites
  • 0

Error: UniqueID: 1 Input String: createPlayer:

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Removing Strict doesn't fix the issue.  Removing Strict doesn't fix the issue. Maybe i do not right? ^^ :)

Error in the structure of tables, or write permissions is not set?

 

Share this post


Link to post
Share on other sites
  • 0

In the database there are many points which are contained in the table accounts, but the request to add consists of two points.

[createAccount]
SQL1_1 = INSERT INTO account SET uid = ?, name = ?
Number Of Inputs = 2
SQL1_INPUTS = 1,2

maybe they should all add?

 

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.