extDB2 error with @Exile_Server error

[Miro 0]

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
 * exile.majormittens.co.uk
 * © 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

[Miro 0]

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!

[smelting 6]

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.

[dayzgreywolf 8]

(delete - posted in wrong topic)

Edited November 25, 2016 by dayzgreywolf