• 0
Sign in to follow this  
Followers 0
DEN

Player & Vehicle spawn underground

Question

This problem happen after server restart.
All player spawn underground at center of map (Altis). 
Sometime vehicle move underground after restart.
Player can move around.


>> Mod

- TRYK

- NATO Vehicle, Weapon

- Exile 1.0.0

>> Script
- Infistar
- a3_dms
- ZCP
- Virtual garage

20160720150442_1.jpg

20160720150526_1.jpg

Edited by DEN

Share this post


Link to post
Share on other sites

6 answers to this question

  • 0

its not a player, its a ghost who spawns on default position. (hc) if u have this issu u have a database problem 

Share this post


Link to post
Share on other sites
  • 0
37 minutes ago, Warsheep said:

its not a player, its a ghost who spawns on default position. (hc) if u have this issu u have a database problem 

I will check database. When this problem happen I try restart again it work but I dont know why sometime happen this problem.
 

Share this post


Link to post
Share on other sites
Advertisement
  • 0

i know 4 admins with this problem, all have dms installed

1 person likes this

Share this post


Link to post
Share on other sites
  • 0
10 hours ago, Warsheep said:

i know 4 admins with this problem, all have dms installed

I check my DB is ok. I will remove DMS for check this

Share this post


Link to post
Share on other sites
  • 0

@Warsheep Now I  know some cause of this bug
Case 1: Happen some player 
If DB table player have 2 row in 1 UID that make this bug.
Case 2 : Happen all player
This case in DB table player have only 1 row : 1 UID

*** I think this problem happen from SQL when player logon. ***
RTP Log This happen with player [Live]HowToNow(76561198147304740)

20/07/2016
15:31:53	InfiSTAR.de_CONNECTLOG	#1 Connected: [Live]HowToNow(76561198147304740) ID: 26 SteamName: 12:15PM[TH] [UpTime: 0h 41min 48s | - ServerFPS: 49.6894]
20/07/2016
15:31:52	Info	ExileServer - Player [Live]HowToNow (UID 76561198147304740) connected!
20/07/2016
15:31:52	InfiSTAR.de_CONNECTLOG	#0 Connected: [Live]HowToNow(76561198147304740) ID: 26 SteamName: 12:15PM[TH]
20/07/2016
15:31:32	InfiSTAR.de_CONNECTLOG	#2 Disconnected: [Live]HowToNow(76561198147304740) ID: 25 SteamName: 12:15PM[TH]
20/07/2016
15:29:16	InfiSTAR.de_CONNECTLOG	#0 Connected: [Live]HowToNow(76561198147304740) ID: 25 SteamName: 12:15PM[TH]
20/07/2016
15:29:16	Info	ExileServer - Player [Live]HowToNow (UID 76561198147304740) connected!
20/07/2016
15:28:55	InfiSTAR.de_CONNECTLOG	#2 Disconnected: [Live]HowToNow(76561198147304740) ID: 23 SteamName: 12:15PM[TH]
20/07/2016
15:27:56	InfiSTAR.de_ADMINLOG	DEN [Plus+](76561198086423482) | Teleport - Me To Target - [Live]HowToNow(76561198147304740)
20/07/2016
15:25:53	InfiSTAR.de_CONNECTLOG	#1 Connected: [Live]HowToNow(76561198147304740) ID: 23 SteamName: 12:15PM[TH] [UpTime: 0h 35min 48s | - ServerFPS: 48.6322]
20/07/2016
15:25:52	Info	ExileServer - Player [Live]HowToNow (UID 76561198147304740) connected!
20/07/2016
15:25:52	InfiSTAR.de_CONNECTLOG	#0 Connected: [Live]HowToNow(76561198147304740) ID: 23 SteamName: 12:15PM[TH]
20/07/2016
15:25:31	InfiSTAR.de_CONNECTLOG	#2 Disconnected: [Live]HowToNow(76561198147304740) ID: 21 SteamName: 12:15PM[TH]
20/07/2016
15:22:22	InfiSTAR.de_CONNECTLOG	#1 Connected: [Live]HowToNow(76561198147304740) ID: 21 SteamName: 12:15PM[TH] [UpTime: 0h 32min 17s | - ServerFPS: 49.0798]
20/07/2016
15:22:17	Info	ExileServer - Player [Live]HowToNow (UID 76561198147304740) connected!
20/07/2016
15:22:17	InfiSTAR.de_CONNECTLOG	#0 Connected: [Live]HowToNow(76561198147304740) ID: 21 SteamName: 12:15PM[TH]
20/07/2016
15:07:45	InfiSTAR.de_CONNECTLOG	#2 Disconnected: [Live]HowToNow(76561198147304740) ID: 18 SteamName: 12:15PM[TH]
20/07/2016
15:04:17	InfiSTAR.de_CONNECTLOG	#1 Connected: [Live]HowToNow(76561198147304740) ID: 18 SteamName: 12:15PM[TH] [UpTime: 0h 14min 13s | - ServerFPS: 49.8442]
20/07/2016
15:04:16	Info	ExileServer - Player [Live]HowToNow (UID 76561198147304740) connected!
20/07/2016
15:04:16	InfiSTAR.de_CONNECTLOG	#0 Connected: [Live]HowToNow(76561198147304740) ID: 18 SteamName: 12:15PM[TH]
20/07/2016
15:03:56	InfiSTAR.de_CONNECTLOG	#2 Disconnected: [Live]HowToNow(76561198147304740) ID: 16 SteamName: 12:15PM[TH]
20/07/2016
15:01:46	Info	ExileServer - Player [Live]HowToNow (UID 76561198147304740) connected!
20/07/2016
15:01:46	InfiSTAR.de_CONNECTLOG	#0 Connected: [Live]HowToNow(76561198147304740) ID: 16 SteamName: 12:15PM[TH]
20/07/2016
15:01:46	InfiSTAR.de_CONNECTLOG	#1 Connected: [Live]HowToNow(76561198147304740) ID: 16 SteamName: 12:15PM[TH] [UpTime: 0h 11min 42s | - ServerFPS: 49.6894]
20/07/2016
14:59:25	InfiSTAR.de_CONNECTLOG	#2 Disconnected: [Live]HowToNow(76561198147304740) ID: 11 SteamName: 12:15PM[TH]
20/07/2016
14:51:02	InfiSTAR.de_CONNECTLOG	#1 Connected: [Live]HowToNow(76561198147304740) ID: 11 SteamName: 12:15PM[TH] [UpTime: 0h 0min 58s | - ServerFPS: 50]
20/07/2016
14:50:52	Info	ExileServer - Player [Live]HowToNow (UID 76561198147304740) connected!
20/07/2016
14:50:52	InfiSTAR.de_CONNECTLOG	#0 Connected: [Live]HowToNow(76561198147304740) ID: 11
20/07/2016
14:50:52	InfiSTAR.de_TOKENLOG	TOKEN [si5xnwio7oycjqoqf] FOR [Live]HowToNow(76561198147304740) - 11
20/07/2016
14:43:26	InfiSTAR.de_CONNECTLOG	#2 Disconnected: [Live]HowToNow(76561198147304740) ID: 49 SteamName: 12:15PM[TH]
20/07/2016
14:41:45	InfiSTAR.de_SURVEILLANCELOG	[Live]HowToNow(76561198147304740) | 2h 51min 43s | Player changed Steam Accounts! old PlayerUID: 76561198155177894
20/07/2016
14:41:45	InfiSTAR.de_CONNECTLOG	#1 Connected: [Live]HowToNow(76561198147304740) ID: 49 SteamName: 12:15PM[TH] [UpTime: 2h 51min 43s | - ServerFPS: 32.4544]
20/07/2016
14:41:42	Info	ExileServer - Player [Live]HowToNow (UID 76561198147304740) connected!
20/07/2016
14:41:42	InfiSTAR.de_CONNECTLOG	#0 Connected: [Live]HowToNow(76561198147304740) ID: 49
20/07/2016
14:41:42	InfiSTAR.de_TOKENLOG	TOKEN [uwb6p0qlbw2rtg1] FOR [Live]HowToNow(76561198147304740) - 49

ExtDB Log  

extDB2: Version: 71
extDB2: https://github.com/Torndeco/extDB2
extDB2: Linux 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 8 Cores, Setting up 6 Worker Threads


[11:49:54 +07:00] [Thread 7341] extDB2: Database Type: MySQL
[11:49:54 +07:00] [Thread 7341] extDB2: Database Session Pool Started
[11:49:54 +07:00] [Thread 7341] extDB2: SQL_CUSTOM_V2: Loading Template Filename: /home/dell18120/steamcmd/arma3/@exileserver/extDB/sql_custom_v2/exile.ini
[11:49:54 +07:00] [Thread 7341] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[14:42:08 +07:00] [Thread 7341] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exile`.`vehicle`, CONSTRAINT `vehicle_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)	[mysql_stmt_errno]: 1452	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO vehicle SET class = ?, account_uid = ?, is_locked = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, pin_code = ?
[14:42:08 +07:00] [Thread 7341] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[14:42:08 +07:00] [Thread 7341] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: insertVehicle:::-1:0:0:0:0:0:0:0:0:0:
[14:42:57 +07:00] [Thread 7341] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exile`.`vehicle`, CONSTRAINT `vehicle_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)	[mysql_stmt_errno]: 1452	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO vehicle SET class = ?, account_uid = ?, is_locked = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, pin_code = ?
[14:42:57 +07:00] [Thread 7341] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[14:42:57 +07:00] [Thread 7341] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: insertVehicle:::-1:0:0:0:0:0:0:0:0:0:

 

Edited by DEN

Share this post


Link to post
Share on other sites
  • 0

ik 2 cases of this, 
1. the ghost player can kill hisself and respawn normal this was on my server and its happend 1 time,

2. player cant kill hisself , reconnect ec dosnt helped either. i deletet the activ player database entry ,after this he can spawn normal.this was on a friends server . i helped him with this problem. 

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
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.