MySQL Latest Topicshttps://exile.majormittens.co.uk/forum/100-mysql/MySQL Latest TopicsenDatabase wont Connect with Server (extDB3)https://exile.majormittens.co.uk/topic/27904-database-wont-connect-with-server-extdb3/ Hey Guys,

i had the idea to start a server for my friends and myselfe so i already have so knowledge over Hosting and already had a Exile server running extDB3. So i made a new Server and i dont know what to do. My Console is showing me every time the Same...

RPT: https://pastebin.com/jtbTBTYp

extDB3 logs: https://pastebin.com/VdWmQ3i2

 

 

Quote

extDB3-conf.ini

 

[Main]
Version = 1

Randomize Config File = false

Allow Reset = false

Thread = 0;

[Log]
Flush = true;

[Database1]
IP = myip
Port = 3306
Username = myname
Password =  mypassword
Database = myname

 

 

]]>27904Thu, 06 Jun 2019 18:02:33 +0000Restore Safes on a territory with a certain PINhttps://exile.majormittens.co.uk/topic/27866-restore-safes-on-a-territory-with-a-certain-pin/ Can anyone help with this? i need to restore some missing safes that had a certain pin on a certain territory from a MYSQL backup.

Does anyone have a handy Export then Import script?

Much appreciated!

]]>27866Thu, 23 May 2019 09:15:39 +0000Just my character stuck on death screen no entry in sqlhttps://exile.majormittens.co.uk/topic/27754-just-my-character-stuck-on-death-screen-no-entry-in-sql/ Hi all
Your help is much appreciated <3
TADST - Dedi server running from my own pc


Runs perfectly for other players but when i join; i don't get a spawn option, i start halfway in the ground (can't move) respawned and the count down timer just stops and no respawn.
Checked SQL (using HeidiSQL) Other players are registered and i can modify (works perfectly) but for me, it only creates an account entry and nothing else.

 

Error:
"ExileServer - Player SubSonic Gamer (UID 76561198063077705) connected!"
"ExileServer - Database Error: Error Unknown Protocol"
Error in expression <se_handleBig;
};
};
((_result select 1) select 0) select 0>
  Error position: <select 0) select 0>
  Error Generic error in expression
File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27
Error in expression <se_handleBig;
};
};
((_result select 1) select 0) select 0>
  Error position: <select 0) select 0>
  Error Generic error in expression
File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27
"default/BIS_fnc_log: HandleDisconnect : 7e48c080# 1523326: invisibleman.p3d"
Warning: Cleanup player - person 2:1816 not found
EPE manager release (48|201|0)
Number of actors in scene after release: 48
EPE manager release (0|48|0)
Unsupported language English in stringtable
Unsupported language English in stringtable
NetServer: cannot find channel #679382988, users.card=0
Message not sent - error 0, message ID = ffffffff, to 679382988 (SubSonic Gamer)

]]>27754Fri, 05 Apr 2019 14:42:09 +0000Creating server issue with starting databasehttps://exile.majormittens.co.uk/topic/27725-creating-server-issue-with-starting-database/ So im trying to set up my server again, i have the server built xammp installed and running , every time i try to go into hedi or navicat and create a new session i get "access denied for admin@localhost using password yes" if i leave password blank it lets me in but i dont feel thats right.

 

]]>27725Thu, 28 Mar 2019 14:48:49 +0000Help - Running Two MySql Data Baseshttps://exile.majormittens.co.uk/topic/27677-help-running-two-mysql-data-bases/ Hello and thanks in advance for any assistance.

So my knowledge of how XAMPP and MySQL works is very limited, if not actually non-existent. What I am trying to do is run two separate databases, for two separate functions, using two separate instances of XAMPP on the same host machine, without either database interfering with the other.

When I first noticed the problem, the new database was not filled and the programme filled my server database with this information, essentially wiping all the player data.

My question is, how can I tell one instance of XAMPP to talk to one programme and provide that data to one specific database, so I can use both programmes at the same time? I am guessing that it might be down to the username and password for both or the address and port used for both, but I'm not sure and I can't find a straight answer anywhere. 

Thanks again, for any help. 

]]>27677Fri, 08 Mar 2019 18:30:22 +0000Update insert id from backup damp ON DUPLICATE KEY UPDATE LAST_INSERT_IDhttps://exile.majormittens.co.uk/topic/27551-update-insert-id-from-backup-damp-on-duplicate-key-update-last_insert_id/ Hi, i have any errors when i try update deleted terrytory from backup damp
Error Code: 1062. Duplicate entry '241786' for key 'PRIMARY'

I call to datebase

Spoiler

INSERT INTO `construction` (`id`,`class`,`account_uid`,`spawned_at`,`position_x`,`position_y`,`position_z`,`direction_x`,`direction_y`,`direction_z`,`up_x`,`up_y`,`up_z`,`is_locked`,`pin_code`,`damage`,`territory_id`,`last_updated_at`,`deleted_at`) VALUES
(241786,'Exile_Construction_WoodGate_Static','76561198048299857','2018-03-13 19:25:02',13794.481445,6825.724609,-500,0.448578,0.893744,0,0,0,1,0,'000000',0,0,'2018-03-13 19:25:02',NULL) 

 ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id + 1);

please help me)

]]>27551Tue, 22 Jan 2019 22:36:17 +0000Removal of RHS equipment and vehicles from databasehttps://exile.majormittens.co.uk/topic/27515-removal-of-rhs-equipment-and-vehicles-from-database/ Hi,

I have removed RHS for my server and obviously, there are a lot of players with RHS weapons, ammo and vehicles etc. 
Would anyone help me with a query to remove anything starting with RHS. I don't know if you can use wildcards with database queries and have zero experience so would obviously make a backup and would prefer to test of one player first.

 

Thanks

]]>27515Sat, 12 Jan 2019 01:31:22 +0000SOLUTION // Setting MYSQL to strict_modehttps://exile.majormittens.co.uk/topic/11026-solution-setting-mysql-to-strict_mode/ Hey whatsupp together.
At first, i'm trying to help you, if it doesn't work. Tell me and i'm trying to find some solution!

Today i'm gone show you, how we can easy fix a MYSQL-Server bug. My bug was looking like this:
 

Spoiler

[20:04:58:695402 +02:00] [Thread 2412] extDB2: Database Type: MySQL
[20:04:58:741503 +02:00] [Thread 2412] extDB2: Database Session Pool Started
[20:04:58:746836 +02:00] [Thread 2412] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Arma3\A3Master\extDB\sql_custom_v2\exile.ini
[20:04:58:747097 +02:00] [Thread 2412] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[20:05:56:886654 +02:00] [Thread 2412] 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 = ?

Sounds terrible i know. But it isn't. Here are my solutions.

It exist 2 Way's. Which you choose, i dont care.

Way 1
-For the first problem you need a Console for your Database like MYSQL Workbench.
If you opened. You need to go to your exile Databse with a doubleclick. If exile is open and you can see al your tables (if not, you need to setup your databse correctly).

-Next you go write a new SQL command with these button with the + in the Paper.
-*First you write 

SELECT @@GLOBAL.sql_mode;

- And start the command with the lightning.

-it opens a formular with sql_mode: (and some Text),

-Next you write a new command with: 

SET @@GLOBAL.sql_mode= '';

- And start it with the lightning

-You go to the step with the '*' back. And write the command with SELECT  again. If the modes are gone and there is just sql_mode: ' '.

-Now we gonne need to Set the strict mode. 

SET @@GLOBAL.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

- And start it with the lightning

-Now we go to make sure, it activate it. with the SELECT  command again (the step with the '*')

- If it looks like this: (on the Picture)
-you win. And it shoud work!

Way 2
- You need to aviable to see all folders. Then you go to the path C >>ProgramData >> MYSQL >> MYSQL Server 5.7 >> my.ini and minimze it!

- WIth win + R you, then you write ' services.msc '. You search MYSQL57, then you stop it with rightclick!

-You go back to the file we opened (my.ini). Search sql-mode:

-Edit the line to

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

-you save it and close it.

-go back to the services.msc, and start the mysql again!
-You win, the server should work!

 

If it doesn't work. Let me know.
If it work. Let me know also.

//Guess BlugDeg
 

1.png

]]>11026Thu, 04 Feb 2016 08:52:59 +0000one player saved with the uid from another playerhttps://exile.majormittens.co.uk/topic/27335-one-player-saved-with-the-uid-from-another-player/ Ahoj Exiles,

as the topic says there happend a strange behavior with the exile mod.
yesterday my character was saved in the DB with the uid from another player in the "player" table and the other player was gone.
(we have disconected from the game at the same minute.)

table `account` 

('765************51', NULL, 'Mav****', 4818, 0, 24, 10000, '2018-11-08 19:42:51', '2018-11-19 21:13:51', '2018-11-20 01:01:48', 45),
('765************19', NULL, 'Edd***', 4621, 0, 12, 9994, '2018-11-08 21:26:21', '2018-11-19 21:09:27', '2018-11-20 01:01:11', 19),
('DMS_PersistentVehicle', NULL, 'DMS_PersistentVehicle', 0, 0, 0, 0, '2018-11-08 20:12:42', '2018-11-08 20:12:42', NULL, 1);

table `player` 

(0, 'Mav****', '765************19', 350, 0, 67.262352, 91.952095, 0, 37, 0, 1, 0, '[["face_hub",0],["neck",0],["head",0],["pelvis",0],["spine1",0],["spine2",0],["spine3",0],["body",0],["arms",0],["hands",0],["legs",0],["body",0]]', 25.153753, 18622.505859, 14391.791992, 0.00157928, '2018-11-20 00:29:54', '["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio","ItemGPS","O_NVGoggles_urb_F","Rangefinder"]', 'B_Bergen_mcamo_F', '[]', '[]', '[]', '', 'G_Tactical_Black', '["muzzle_snds_L","","",""]', 'hgun_Rook40_F', 'H_HelmetSpecB_paint1', 'Rangefinder', '[["arifle_MXM_Black_F","30Rnd_65x39_caseless_mag",13,"arifle_MXM_Black_F"],["hgun_Rook40_F","16Rnd_9x21_Mag",16,"hgun_Rook40_F"]]', 'arifle_MXM_Black_F', '["muzzle_snds_H_MG","","optic_Hamr_khk_F","bipod_01_F_snd"]', '', '["","","",""]', 'U_B_CombatUniform_mcam_vest', '[]', '[["30Rnd_65x39_caseless_mag",29],["30Rnd_65x39_caseless_mag_Tracer",30],["30Rnd_65x39_caseless_mag_Tracer",30],["30Rnd_65x39_caseless_mag_Tracer",30]]', '[]', 'V_PlateCarrier1_rgr', '[["optic_SOS",1]]', '[["Exile_Item_Noodles",1],["Exile_Item_ChocolateMilk",1],["Exile_Item_InstaDoc",1]]', '[]', '2018-11-20 01:01:48');

how could this happen?

Mod:
Exile1.0.4
Adds:
dms
exile_occupation
all newest version from Github

]]>27335Tue, 20 Nov 2018 14:55:20 +0000Help please. Automatic family when first joining the serverhttps://exile.majormittens.co.uk/topic/21526-help-please-automatic-family-when-first-joining-the-server/ Hi,

 

I am looking for some help. I would like to make it so that when a new player joins the server they are automatically placed into a starting family. They can leave after and start their own but it would just be a starting point for new players and a chance for single players to make groups meet other players etc.

I am thinking that this could be done with the data base.

 

Thanks.

]]>21526Sat, 25 Feb 2017 13:51:43 +0000Removing Delete At dates to NULLhttps://exile.majormittens.co.uk/topic/27271-removing-delete-at-dates-to-null/ Hey all I just moved from ExAd to Vanilla Virtual garage, I had everything working as it should but its just come to my attention that Vehicles within the Virtual Garage are being delete after 2 days which I have set for the server.

Now I have no knowledge of SQL queries and what not, I had a look and made my brain hurt...

Im looking for a SQL query which will reset all vehicles within a virtual garage deleted at to NULL.

Any help on this? 

]]>27271Wed, 31 Oct 2018 13:26:50 +0000Please HELPhttps://exile.majormittens.co.uk/topic/27021-please-help/ Hi i have this on my DB log please help with this and thanks 

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 12 Cores, Setting up 6 Worker Threads


[12:45:37:951716 +02:00] [Thread 17780] extDB2: Database Type: MySQL
[12:45:37:954716 +02:00] [Thread 17780] extDB2: Database Session Pool Started
[12:45:37:955716 +02:00] [Thread 17780] extDB2: SQL_CUSTOM_V2: Loading Template Filename: c:\hlserver\27568\@ExileServer\extDB\sql_custom_v2\exile.ini
[12:45:37:956716 +02:00] [Thread 17780] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[12:45:37:958716 +02:00] [Thread 17780] extDB2: SQL_CUSTOM_V2: Loading Template Filename: c:\hlserver\27568\@ExileServer\extDB\sql_custom_v2\avs.ini
[12:45:37:958716 +02:00] [Thread 17780] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[13:00:05:412332 +02:00] [Thread 13604] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198140193503:GuangKuo:16652:15086.5:0.00148773:4::::any
[13:00:05:412332 +02:00] [Thread 13604] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10
[13:02:06:176239 +02:00] [Thread 9156] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198140193503:GuangKuo:6922.69:7701.78:13.5098:1:76561198140193503:::any
[13:02:06:176239 +02:00] [Thread 9156] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10
[13:10:29:103005 +02:00] [Thread 13604] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198140193503:GuangKuo:6946:7615.09:0.00143862:0::::any
[13:10:29:103005 +02:00] [Thread 13604] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10
[13:37:22:665295 +02:00] [Thread 17232] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198140193503:GuangKuo:4815.46:14609.8:2.22287:1:76561198140193503:::any
[13:37:22:665295 +02:00] [Thread 17232] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10
[13:41:12:223425 +02:00] [Thread 9156] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198140193503:GuangKuo:6307.65:8601.07:0.00180817:0::::any
[13:41:12:223425 +02:00] [Thread 9156] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10
[13:50:44:409152 +02:00] [Thread 8660] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198140193503:GuangKuo:2722.16:11954.2:0.000762939:1:76561198140193503:::any
[13:50:44:409152 +02:00] [Thread 8660] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10
[13:51:35:104052 +02:00] [Thread 9156] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198268262757:Survik:5658.16:17456.5:12.0833:0::::any
[13:51:35:104052 +02:00] [Thread 9156] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10
[13:57:44:289168 +02:00] [Thread 17232] extDB2: SQL_CUSTOM_V2: Error No Custom Call Not Found: Input String updateInfection:0.01:0:76561198268262757
[13:57:44:289168 +02:00] [Thread 17232] extDB2: SQL_CUSTOM_V2: Error No Custom Call Not Found: Callname updateInfection
[14:01:53:762437 +02:00] [Thread 8660] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198140193503:GuangKuo:12442.4:12112.6:0.00161743:4::::any
[14:01:53:762437 +02:00] [Thread 8660] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10
[14:07:50:700853 +02:00] [Thread 3272] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198216852960:Doyd:3891.73:12110.6:2.05283:4::::any
[14:07:50:700853 +02:00] [Thread 3272] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10
[14:08:34:461356 +02:00] [Thread 3272] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198140193503:GuangKuo:13237.1:15100.5:-7.17835:1:76561198140193503:::any
[14:08:34:461356 +02:00] [Thread 3272] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10
[14:19:13:108884 +02:00] [Thread 8660] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Input String insertPlayerHistory:76561198140193503:GuangKuo:12908.6:16507.3:0.00166321:4::::any
[14:19:13:108884 +02:00] [Thread 8660] extDB2: SQL_CUSTOM_V2: Incorrect Number of Inputs: Expected: 5 Got: 10

 

]]>27021Wed, 29 Aug 2018 12:43:18 +0000[Solved]Request Creation bambi errorhttps://exile.majormittens.co.uk/topic/26885-solvedrequest-creation-bambi-error/ Please help with this and big help for solve this. 

extDB2: Found extdb-conf.ini
extDB2: Detected 4 Cores, Setting up 4 Worker Threads


[18:54:30:934200 +02:00] [Thread 4732] extDB2: Database Type: MySQL
[18:54:31:032200 +02:00] [Thread 4732] extDB2: Database Session Pool Started
[18:54:31:067200 +02:00] [Thread 4732] extDB2: SQL_CUSTOM_V2: Loading Template Filename: D:\ArmaServer\Server\@ExileServer\extDB\sql_custom_v2\exile.ini
[18:54:31:067200 +02:00] [Thread 4732] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[18:54:31:069200 +02:00] [Thread 4732] extDB2: SQL_CUSTOM_V2: Loading Template Filename: D:\ArmaServer\Server\@ExileServer\extDB\sql_custom_v2\avs.ini
[18:54:31:069200 +02:00] [Thread 4732] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[19:42:42:760200 +02:00] [Thread 4732] 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 = ?
[19:42:42:785200 +02:00] [Thread 4732] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:42:42:785200 +02:00] [Thread 4732] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198112335155:josef
[19:44:03:553200 +02:00] [Thread 4732] 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 = ?
[19:44:03:553200 +02:00] [Thread 4732] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:44:03:553200 +02:00] [Thread 4732] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198112335155:josef
[19:47:13:956200 +02:00] [Thread 4732] 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 = ?
[19:47:13:956200 +02:00] [Thread 4732] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:47:13:956200 +02:00] [Thread 4732] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561198112335155:josef
[19:53:24:951200 +02:00] [Thread 6736] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Can't connect to MySQL server on '127.0.0.1' (10061)	[mysql_stmt_errno]: 2003	[mysql_stmt_sqlstate]: HY000	[statemnt]: UPDATE player SET name = ?, damage  = ?, hunger = ?, thirst = ?, alcohol = ?, oxygen_remaining  = ?, bleeding_remaining = ?, hitpoints = ?, direction = ?, position_x = ?, position_y = ?, position_z = ?, assigned_items = ?, backpack = ?, backpack_items = ?, backpack_magazines = ?, backpack_weapons = ?, current_weapon = ?, goggles = ?, handgun_items = ?, handgun_weapon = ?, headgear = ?, binocular = ?, loaded_magazines = ?, primary_weapon = ?, primary_weapon_items = ?, secondary_weapon = ?, secondary_weapon_items = ?, uniform = ?, uniform_items = ?, uniform_magazines = ?, uniform_weapons = ?, vest = ?, vest_items = ?, vest_magazines = ?, vest_weapons = ?, temperature = ?, wetness = ? WHERE id = ?

 

]]>26885Sat, 04 Aug 2018 17:49:18 +0000Unable to join serverhttps://exile.majormittens.co.uk/topic/26825-unable-to-join-server/ Hello,

I've spend over 20 hr's trying to fix this issue.

Please someone help me

Quote

21:13:24 Client: Remote object 3:0 not found
21:13:24 "TCAGame/BIS_fnc_log: HandleDisconnect : R Alpha 1-1:1"

1. I already attempted re-installing my database from scratch.

2. disable BE

3. Re-install some of my mods and double check

]]>26825Thu, 26 Jul 2018 04:09:20 +0000Fix for Death Loop Bug/Spawnhttps://exile.majormittens.co.uk/topic/17774-fix-for-death-loop-bugspawn/ I find this easier than having to manually delete these in the database plus your players wont get stuck in the loop and leave!

1. Stop the SQL service

2. Edit my.ini in C:\ProgramData\MySQL\MySQL Server 5.7 or C:\ProgramData\MySQL\MySQL Server 5.6 depends on which one you have installed probably hidden file.

Add event_scheduler=ON to the bottom, save it then go to properties of my.ini and check read only, double check strict mode is off this saves you issues down the road with bambi creation timeouts.

3. Open up your SQL editor I.E. HeidiSQL and right click on the exile database scroll down to Create New and select event

Under setting just name it, I named mine Damaged Player under comments I put in Damaged 1

Under execution body delete everything and paste DELETE FROM `player` WHERE damage = 1

Under Timing this depends if you have revive setup, if you do every 5 mins should be fine if you dont then 1 min would be good as well.

Click save and start your SQL service back up

I do not foresee a huge performance impact on the database running every 1 or 5 mins.

]]>17774Sat, 27 Aug 2016 00:42:30 +0000Do I need to write my own "scoreboard" type server messages?https://exile.majormittens.co.uk/topic/26568-do-i-need-to-write-my-own-scoreboard-type-server-messages/ Hey all, quick question- Im not that great at finding the right topics in forums, so sorry if this is in the wrong spot.

OK, so I want a scoreboard to pop up every hour in the chat to shot the top players.

kills, respect, deaths, play time, that kinda thing. Ive seen a similar one on my old Dayz server clan doolittle.

 

my question, is ive done searches here and google, and cant find what im looking for. I've done some sql and understand how to make strings in arma's language, but i dont want to spend 5+ hours writing a scoreboard from scratch if someone else knows of one. so, please PLEASE! someone hook me up with a link, or direction? please? if none exist, then i'll go ahead and write it, and post it here when im done, so there is one for future learning admins.

 

thanks.

]]>26568Sat, 09 Jun 2018 03:54:18 +0000Containers and Vehicles not updatinghttps://exile.majormittens.co.uk/topic/23231-containers-and-vehicles-not-updating/ I seem to be having the issue where containers and vehicles don't update to the MySQL database after their initial creation. Bases, characters, currency, and everything else updates and works fine; it's only these two things.

For instance if I clear a DMS mission and load the unclaimed vehicle with loot, drive it back to base, and put a lock on it it is then immediately saved to the database in it's current state; position, inventory, and all. I then make a container and it is also saved to the database. I now unload the vehicle into the container and drive the vehicle away, get out, place a wall on my base, and log off. After the server restarts the vehicle is back where I put the lock on with its inventory back as if I didn't take anything out, the container is empty, the base wall is there, and my character is where I logged off.

I have no idea what is causing this. My extDB logs have no errors, and my RPT has no relevant errors to my knowledge that I can find. If anybody can help me I'd greatly appreciate it and if you need anything more than what I've provided here please ask. I really need this fixed.

Last Server Restart RPT https://pastebin.com/1KFvTKBn

Last extDB Log (They all look like this)  https://pastebin.com/CgZf1Qrj

My exile.ini https://pastebin.com/BNaMNq0M

]]>23231Fri, 02 Jun 2017 03:46:12 +0000Players don't save to Account Tablehttps://exile.majormittens.co.uk/topic/17021-players-dont-save-to-account-table/ I have an issue where players don't save to the account table in my exile database, they show up in players and recent players but if they disconnect and reconnect they have the whole "spawning as a rabbit" business where they are at feet level on the map and cant move around etc. if they commit suicide and try to re-spawn the game kicks them saying error character request timed out.

MySQL is not in strict mode either lol, any suggestions? if you need more info I'd be happy to provide, just let me know what you need.

currently the server is running Exile and CBA with DMS missions

]]>17021Tue, 26 Jul 2016 03:05:10 +0000[FIX]Bambi Creation Timeouthttps://exile.majormittens.co.uk/topic/26449-fixbambi-creation-timeout/ Hello guys, i search much time to find this fucking Problem with "Mysql 5.7" and "Bambi Creation Timeout"

 

Heres The Fix.

 

PHPMYADMIN: 

Klick First on "SQL"

and run this Code (set global SQL_MODE="ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER") without ()

Screenshots:
InkedXOZsTlW_LI.jpg

]]>26449Tue, 22 May 2018 01:05:03 +0000"ExileServer - Database Error: Error Unknown Protocol"https://exile.majormittens.co.uk/topic/26434-exileserver-database-error-error-unknown-protocol/ Cheers,

Since today i got this error...just loaded up a new File ( should actually work fine ) just change some parts in Config.cpp then this appears :

( but loaded up yet my backup ) but the same i cannot connect.

  

10:39:33 "cfg/BIS_fnc_log: [BIS_fnc_addStackedEventHandler] Stack as been updated with ID (PVPMMonPartCall) for Event (onplayerdisconnected), Replaced: (false)"
10:39:51 "cfg/BIS_fnc_log: [BIS_fnc_preload] ----- Scripts initialized at 21629 ms -----"
10:40:24 Loading movesType CfgMovesBird
10:40:24 Creating action map cache
10:40:33 [PVPMM]: Disabled because of player count (0) is not enough players
10:40:35 Client: Object 2:891 (type Type_127) not found.
10:40:35 "ExileServer - Player Kuchenplatte (UID 76561198066801550) connected!"
10:40:35 "ExileServer - Database Error: Error Unknown Protocol"
10:40:35 Error in expression <se_handleBig;
};
};
((_result select 1) select 0) select 0>
10:40:35   Error position: <select 0) select 0>
10:40:35   Error Generic error in expression
10:40:35 File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27
10:40:35 Error in expression <se_handleBig;
};
};
((_result select 1) select 0) select 0>
10:40:35   Error position: <select 0) select 0>
10:40:35   Error Generic error in expression
10:40:35 File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27
10:40:35  Mission id: 9f8c2c5894be4e9bd6359504c4324010ab99a111
10:40:35 Client: Object 2:893 (type Type_115) not found.
10:40:35 Client: Object 2:891 (type Type_437) not found.
10:40:35 Client: Object 2:891 (type Type_455) not found.
10:40:35 Client: Object 2:891 (type Type_456) not found.
10:40:35 Client: Object 2:893 (type Type_114) not found.
10:40:35 Client: Object 2:891 (type Type_128) not found.
10:40:35 Client: Object 2:891 (type Type_128) not found.
10:40:35 Client: Object 2:891 (type Type_437) not found.
10:40:35 Client: Object 2:891 (type Type_455) not found.
10:40:35 Client: Object 2:891 (type Type_456) not found.
10:40:37 Client: Object 2:891 (type Type_128) not found.
10:40:38 Client: Object 2:891 (type Type_128) not found.
10:40:41 "ExileServer - Starting session for 'Kuchenplatte' with ID 'uuflsvtq'..."
10:40:41 "ExileServer - Dispatching hasPlayerRequest for session 'uuflsvtq'..."
10:40:41 "ExileServer - Database Error: Error Unknown Protocol"
10:40:41 Error in expression <se_handleBig;
};
};
((_result select 1) select 0) select 0>
10:40:41   Error position: <select 0) select 0>
10:40:41   Error Generic error in expression
10:40:41 File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27
10:40:41 Error in expression <se_handleBig;
};
};
((_result select 1) select 0) select 0>
10:40:41   Error position: <select 0) select 0>
10:40:41   Error Generic error in expression
10:40:41 File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27
10:40:45 [PVPMM]: Disabled because of player count (0) is not enough players
10:40:55 Client: Object 2:891 (type Type_128) not found.
10:41:03 [PVPMM]: Disabled because of player count (0) is not enough players
10:41:10 Client: Object 2:891 (type Type_128) not found.
10:41:16 Client: Object 2:891 (type Type_127) not found.
10:41:22 [PVPMM]: Marker removed for Kuchenplatte (disconnected)
10:41:22 Client: Remote object 2:891 not found
10:41:22 Client: Remote object 2:893 not found
10:41:22 "cfg/BIS_fnc_log: HandleDisconnect : 3f8b4080# 1675074: invisibleman.p3d"
10:41:22 Warning: Cleanup player - person 2:895 not found
10:41:22 Warning: Cleanup player - person 2:895 not found

Someone can Help? :)

Thanks

]]>26434Sun, 20 May 2018 08:35:17 +0000New Table (Player Tracker)https://exile.majormittens.co.uk/topic/26373-new-table-player-tracker/ So I have the need to create a new table, a combination of 2 other tables and their features. I need to create a table that increments like the "player_history", yet contains more information like "players". Here is what I have so far, yet it keeps throwing a "undefined variable" error? Anyone care to point out my obvious failure!

code added to exile.ini

Spoiler

[insertPlayerTracker]
SQL1_1 = INSERT INTO player_tracker SET account_uid = ?, name = ?, position_x = ?, position_y = ?, position_z = ?, locker = ?, money = ?, score = ?, current_weapon = ?, uniform = ?, backpack = ?, vest = ?
Number Of Inputs = 12
SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12

content of the playertracker.sqf located in the mission file. called in init.sqf - [] execVM "addons\playertracker.sqf";                             // send player updates to DB

Spoiler

if hasInterface then
{
    if isMultiplayer then
    {
        waitUntil { if ( not ( isNull ( findDisplay 46 ) ) AND ( ( typeOf player ) isEqualTo "Exile_Unit_Player" ) ) then { true } else { uiSleep 0.5; false } };
        
        private ["_uid","_name","_pos","_lockerMoney","_playerMoney","_playerScore","_current_weapon","_uniform","_backpack","_vest"];
        
        while {true} do
        {
            diag_log format ["PlayerTracker - Found player %1, adding entry to DB", player];

            _uid = getPlayerUID player;
            _name = name player;
            _pos = getPos player;

            _lockerMoney = player getVariable ["ExileLocker",0];
            _playerMoney = player getVariable ["ExileMoney",0];
            _playerScore = player getVariable ["ExileScore",0];

            _current_weapon = currentWeapon player;
            _uniform = uniform player;
            _backpack = backpack player;
            _vest = vest player;

            format["insertPlayerTracker:%1:%2:%3:%4:%5:%6:%7:%8:%9:%10:%11:%12", _uid, _name, _pos select 0, _pos select 1, _pos select 2, _lockerMoney, _playerMoney, _playerScore, _current_weapon, _uniform, _backpack, _vest] call ExileServer_system_database_query_fireAndForget;
            uisleep 300;
        };
    };
};

Thanks.

]]>26373Thu, 10 May 2018 00:41:43 +0000InfiSTAR Access thru MySQL - is it possablehttps://exile.majormittens.co.uk/topic/26404-infistar-access-thru-mysql-is-it-possable/ Is it possible to make infistar admin access thru a MySQL database? So you don't have to restart server just to add a players UID to the admin list, and to give individual access to some privileges. I have uploaded a picture of the EXILE_AHAT_CONFIG file that might help with what I am trying to incorporate. I have already looked at all topics, you-tube videos and website. The only thing close is Arma life witch might grand access to a police officer. Any help would be greatly appreciated.

PS. I am also trying to incorporate MCC into Exile, but with no success. If anyone know where I might fine the conflict or the starting point, please chime in.

EXILE_AHAT_CONFIG.png

]]>26404Tue, 15 May 2018 04:05:44 +0000How interact with exile DataBasehttps://exile.majormittens.co.uk/topic/26202-how-interact-with-exile-database/ Hi, I would like to make sure that when a player enters a zone it changes a value in a column ("testlevel") in the "player" table. 

So I started by adding the column in question in the database with this:  

ALTER TABLE account ADD testlevel int(11) DEFAULT '0'

 

I think it worked. But I am stuck at this step. Some help ?

Thx

]]>26202Sat, 14 Apr 2018 01:08:46 +0000Our database issuehttps://exile.majormittens.co.uk/topic/16282-our-database-issue/ (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.

]]>16282Tue, 12 Jul 2016 11:48:35 +0000How does one create a second database/MYSQL connection so the tables process with the sql file?https://exile.majormittens.co.uk/topic/2127-how-does-one-create-a-second-databasemysql-connection-so-the-tables-process-with-the-sql-file/Im using MYSQL and Navicat, I cannot get a second database working for a new map i want to run on dedicated test server from same client PC. the execute exile. sql file wont inject the data into the tables of a new database.

what is the procedure in creating a second database with exile mission? Do i create a new connection or just add a new database to my working exile data base connection?  Do i need a different port to use another database , besides 3306?

I' ve been trying to run Esseker exile dedicated server, having a hell of time, getting "receiving server" hang, but server runs,game started.

thanks

]]>2127Sat, 26 Sep 2015 17:16:48 +0000