• 0
IGS Apex

ERROR STOPPING THE SERVER FROM RUNNING

Question

10 answers to this question

  • 0
11 minutes ago, IGS Apex said:

This is the error in the DB logs


[13:27:38:237568 --4:00] [Thread 9244] extDB2: Database Type: MySQL
[13:27:38:242876 --4:00] [Thread 9244] extDB2: Database Session Pool Started
[13:27:38:245273 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\HCG Servers Server Files\OurServers\Arma3Servers\Exile\Server 1 NGR Exile\@ExileServer\extDB\sql_custom_v2\exile.ini
[13:27:38:245515 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[13:33:08:721419 --4:00] [Thread 9244] 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 = ?
[13:33:08:721529 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[13:33:08:721552 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198145034109:Paul Mahone
[13:35:27:174968 --4:00] [Thread 9244] 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 = ?
[13:35:27:175146 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[13:35:27:175176 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198145034109:Paul Mahone

 

This is because the SQL database is set to scrict mode. To disable scrict mode do the following:
Do it via a query:

SET @@GLOBAL.sql_mode="";

However if you decide to restart your SQL server then you need to redo this query everytime, or you are gonna get these errors. 

Put this inside your my.cnf config file

under [mysqld]

sql-mode=""

Put this inside that config file then you dont need to re-run the query everytime you restart your SQL server.

Share this post


Link to post
Share on other sites
Advertisement
  • 0
43 minutes ago, IGS Apex said:

Here you go and I let it run all night and I still didn't get kicked or it still didn't crash.
RPT log: https://pastebin.com/upP3JNvb

You have a few errors

Warning Message: File mpmissions\__cur_mp.Tanoa\init.sqf, line 0: Config: .: 'e' encountered instead of '='
Warning Message: Config : some input after EndOfFile.
Mission Exile.Tanoa: Missing 'description.ext::Header'
<infiSTAR.de> 0 - infiSTAR_defines.hpp is not in your MPMission or you forgot to #include it within your description.ext

 

Share this post


Link to post
Share on other sites
  • 0

I fixed the init one but the infiSTAR one shouldn't be getting an error
 

class CfgRemoteExec
{
	#include "CfgRemoteExec.hpp"
	#include "infiSTAR_defines.hpp"
	#include "infiSTAR_AdminMenu.hpp"
	#include "infiSTAR_chat.hpp"
	#include "infiSTAR_KeyBinds.hpp"
};

 

Share this post


Link to post
Share on other sites
  • 0
14 minutes ago, IGS Apex said:

I fixed the init one but the infiSTAR one shouldn't be getting an error
 


class CfgRemoteExec
{
	#include "CfgRemoteExec.hpp"
	#include "infiSTAR_defines.hpp"
	#include "infiSTAR_AdminMenu.hpp"
	#include "infiSTAR_chat.hpp"
	#include "infiSTAR_KeyBinds.hpp"
};

 

Thats wrong

This is correct, just remove class CfgRemoteExec, brackets and the semicolon.


#include "CfgRemoteExec.hpp"
#include "infiSTAR_defines.hpp"
#include "infiSTAR_AdminMenu.hpp"
#include "infiSTAR_chat.hpp"
#include "infiSTAR_KeyBinds.hpp"

 

Share this post


Link to post
Share on other sites
  • 0

Ok so I got into the map this time and selected where to spawn and then got error Bambi creation timed out. If I'm not mistaking that's with the database.

 

Edited by IGS Apex

Share this post


Link to post
Share on other sites
  • 0

This is the error in the DB logs

[13:27:38:237568 --4:00] [Thread 9244] extDB2: Database Type: MySQL
[13:27:38:242876 --4:00] [Thread 9244] extDB2: Database Session Pool Started
[13:27:38:245273 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\HCG Servers Server Files\OurServers\Arma3Servers\Exile\Server 1 NGR Exile\@ExileServer\extDB\sql_custom_v2\exile.ini
[13:27:38:245515 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[13:33:08:721419 --4:00] [Thread 9244] 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 = ?
[13:33:08:721529 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[13:33:08:721552 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198145034109:Paul Mahone
[13:35:27:174968 --4:00] [Thread 9244] 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 = ?
[13:35:27:175146 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[13:35:27:175176 --4:00] [Thread 9244] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198145034109:Paul Mahone

 

Edited by IGS Apex

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.