Our database issue

[Desto 0]

(format>
12:50:23   Error position: <_result select 0) do
{
case 0:
{
(format>
12:50:23   Error Undefined variable in expression: _result
12:50:23 File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
12:50:23 Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
12:50:23   Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
12:50:23   Error Undefined variable in expression: _clanids
12:50:23 File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
12:50:23 Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{

 

This error we keep getting from the database and we donno how to fix it any clues?

 

when we loaded the new database it gave us 4 errors but donno whats wrong its a new server so we can easy put in a working one if any one have.

[Desto 0]

8 minutes ago, Desto said:

(format>
12:50:23   Error position: <_result select 0) do
{
case 0:
{
(format>
12:50:23   Error Undefined variable in expression: _result
12:50:23 File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
12:50:23 Error in expression <uery_selectFull;
_numberOfClans = count _clanIDs;
if (_numberOfClans > 0) then 
>
12:50:23   Error position: <_clanIDs;
if (_numberOfClans > 0) then 
>
12:50:23   Error Undefined variable in expression: _clanids
12:50:23 File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20
12:50:23 Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{

 

This error we keep getting from the database and we donno how to fix it any clues?

 

when we loaded the new database it gave us 4 errors but donno whats wrong its a new server so we can easy put in a working one if any one have.

/**
 * ExileServer_world_loadAllClans
 *
 * 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["_continueLoading","_page","_pageSize","_clanIDs","_numberOfClans","_i"];
"Loading families from database..." call ExileServer_util_log;
_continueLoading = true;
_page = 0;
_pageSize = 100;
while {_continueLoading} do 
{
	_clanIDs = format ["loadClansIdPage:%1:%2", _page * _pageSize, _pageSize] call ExileServer_system_database_query_selectFull;
	_numberOfClans = count _clanIDs;
	if (_numberOfClans > 0) then 
	{
		for "_i" from 0 to _numberOfClans - 1 do 
		{
			((_clanIDs select _i) select 0) call ExileServer_system_clan_database_load;
		};
	};
	_page = _page + 1;
	if (_numberOfClans < 100) then
	{
		_continueLoading = false;
	};
};
"Done loading families!" call ExileServer_util_log;
true

/**
 * ExileServer_system_database_query_selectFull
 *
 * 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);
switch (_result select 0) do
{
	case 0:
	{
		(format["Database Error: %1", (_result select 1)]) call ExileServer_util_log;
	};
	case 2:
	{
		_result = (_result select 1) call ExileServer_system_database_handleBig;
	};
};
_result select 1

 

Those 2 files it says theres an error within.

[DEADPOOL_ZA 17]

Hey man i have the same issue any luck?

[Desto 0]

13 minutes ago, DEADPOOL_ZA said:

Hey man i have the same issue any luck?

sorry trying to find why its doing this a guy i know say that i can still use old Database but cant even get an old database to work so this starting to get ennoying

 

[Kobayashi 86]

If you're using the scripts that come with the server install, it explicitly has a command at the top to use a database called "exile". If your database has a different name, using that script will end up creating a new database named "exile". Either take that part of the script out, or change the name. I had the same problem and couldn't figure out wtf until I looked at it after a few hours of beating my head against the desk lol

[DEADPOOL_ZA 17]

hey man can you explain more in detail i am a bit of a noob

 

[Kobayashi 86]

Look in the extdb2_config.ini (I think that's the name of the file). In there it has parameters for connecting to your database, one is database name or something like that. If it doesn't say "exile" then you are using a different database name than the one at the very beginning of the sql script that creates the database. You'll see up at the top of the script something that says "use exile;" - that's the database the whole script will execute in. Either change that to the name of your database (in extdb2_config.ini) or just remove that line (and the "create database exile;"). 

[DEADPOOL_ZA 17]

hey man this is my extdb2 file please check here:

 

Spoiler

[Main]
Version = 5
;Threads = 0  
; Default Value is the number of CPU Cores Detected (max value is 6, min value is 2)
Randomize Config File = false
;This is a legacy option to randomize config file for Arma2 Servers. Only for Windows Builds

[Rcon]
;; This is functional, should be working fine. Just needs abit of testing on a $
;; Allow for changing Address for those running server in a VM environment.
IP = 127.0.0.1
Port = 2302

;; Rcon Password i.e Battleye/beserver.cfg
Password = G3NAdmin@@##$$%%

;; Bad Player Name Checks
;;        This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON
Bad Playername Enable = true
Bad Playername Kick Message = Bad Player Name

;; By default : is a bad character (used as seperator for extDB2 Calls (this is hardcoded in)
Bad Playername Strings = (:):{:}
;;Bad Playername Regex_1 = [:alnum:]
;;Bad Playername Regex_2 = [:alnum:]
;;Bad Playername Regex_3 = [:alnum:]

;; Whitelisting / Reserve Slots
;;        This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON
Whitelist Enable = false
Whitelist Kick Message = Only Reserved Slots Left
Whitelist Public Slots = 999

;; Database settings to use (Optional)
Whitelist Database = MySQL_Example
Whitelist SQL Prepared Statement = SELECT CASE WHEN EXISTS(SELECT UID FROM PlayerInfo WHERE BattlEyeGUID=? AND Whitelisted=1) THEN 1 ELSE 0 END
Whitelist Kick on SQL Query Failed = false

;; Hardcoded BEGuids for whitelisted players
;Whitelist BEGuids = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx : yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy

[Steam]
;; This is for VAC Protocol for VAC Bans + Steam Friends.
;; https://steamcommunity.com/dev/apikey
API Key = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

[VAC]
;; This feature requires Steam + Rcon to be enabled.
;; Also this feature is called via SQF Code atm, i.e it doesn't auto detect players joining server yet....
Auto Ban = false

;; For Player to get banned ( their total VAC Bans => NumberOfVACBans)  AND ( Days Since their Last Ban was <= DaysSinceLastBan)
;; This is also used extDB Protocol VAC:VACBanned returned results

NumberOfVACBans = 1
DaysSinceLastBan = 999999999
BanDuration = 1
;; 0 = Forever, otherwise its x Minutes
BanMessage = Steam VAC Banned

[Log]
;; Flush Logs after each write, more work on Harddrive
Flush = true

[exile]
Type = MySQL
Name = exile
Username = root
Password = G3NAdmin@@##$$%%
IP = 127.0.0.1
Port = 3306
minSessions = 2
idleTime = 60
; Really should only use this if MySQL server is external. Also only for MySQL
compress = false
; Recommend you turn this on http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth
Secure Auth = true

[SQLite_Example]
Type = SQLite
Name = sqlite.db

minSessions = 1
; minSession Default Value = 1

;maxSessions = 4
; maxSession Default Value = number of Main->Threads
;     You really should leave this value alone
idleTime = 60
; idleTime no Default Value yet, needs to be defined.
;     idleTime is the time before a database session is stopped if not used. 
;    If Database Sessions are greater than minSessions

 

[Kobayashi 86]

You created the database from scratch when you upgraded to the new version of exile?

[DEADPOOL_ZA 17]

yes