• 0
Miro

extDB2 error with @Exile_Server error

Question

Hello,

i got these errors:

extDB log:

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


[10:31:15:959232 +02:00] [Thread 2820] extDB2: Database Type: MySQL
[10:31:16:053049 +02:00] [Thread 2820] extDB2: Database Session Pool Started
[10:31:16:069598 +02:00] [Thread 2820] extDB2: SQL_CUSTOM_V2: Loading Template Filename: D:\ArmA3\A3Master\@exileserver\extDB\sql_custom_v2\exile.ini
[10:31:16:069740 +02:00] [Thread 2820] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[10:32:48:157662 +02:00] [Thread 2820] 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 = ?
[10:32:48:157745 +02:00] [Thread 2820] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:32:48:157768 +02:00] [Thread 2820] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198214395468:[A] Steve Peters

RPT log:

10:31:49 "ExileServer - Starting session for '[A] Steve Peters' with ID 'lLGmWOuz'..."
10:32:48 Error in expression <llExtension _query);
(_result select 1) select 0>
10:32:48   Error position: <select 0>
10:32:48   Error Generic error in expression
10:32:48 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16
10:32:48 Error in expression <llExtension _query);
(_result select 1) select 0>
10:32:48   Error position: <select 0>
10:32:48   Error Generic error in expression
10:32:48 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16
10:33:28 Client: Remote object 3:0 not found
10:33:28 Warning: Cleanup player - person 2:706 not found
10:36:41 Deinitialized shape [Class: "Exile_Unit_GhostPlayer"; Shape: "a3\characters_f\common\invisibleman.p3d";]
10:36:41 Deinitialized shape [Class: "Exile_Unit_Player"; Shape: "a3\characters_f\common\coveralls.p3d";]
10:36:41 c:\w\stable\futura\lib\network\networkserver.cpp ClearNetServer:NOT IMPLEMENTED - briefing!
10:36:42 Extensions:
10:36:42   extDB2 (D:\ArmA3\A3Master\@exileserver\extDB2.dll) [70.0.0.0] [70.0.0.0]

My Exile Server never worked. Tried two tutorials. Database Connection running, exile.sql used and than update 0.9 [...].sql

File exile_server\code\ExileServer_system_database_query_insertSingle.sqf:

/**
 * ExileServer_system_database_query_insertSingle
 *
 * Exile Mod
 * www.exilemod.com
 * © 2015 Exile Mod Team
 *
 * This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License. 
 * To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-nd/4.0/.
 */
 
private["_parameters","_query","_result"];
_parameters = _this;
_query = [0, ExileServerDatabaseSessionId, _parameters] joinString ":";
_result = call compile ("extDB2" callExtension _query);
(_result select 1) select 0

I dont know how to fix :(

Share this post


Link to post
Share on other sites

3 answers to this question

  • -1

This Community is not good. Even the developers.

Solution:

turn your mysql mode to strict. I got Windows Server and you need to change it in two folders, because i did first only in one. But now everything works perfect! :)

Share this post


Link to post
Share on other sites
  • 0
6 hours ago, Miro said:

This Community is not good. Even the developers.

Solution:

turn your mysql mode to strict. I got Windows Server and you need to change it in two folders, because i did first only in one. But now everything works perfect! :)

That's harsh bro..

Also, you need to disable strict mode on sql, not enable it. 

All you need to do is modify your my.ini and find the line that says:

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

And then replace this with:

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

Restart your sql server and then you'll be good.

1 person likes this

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.