• 0
Sign in to follow this  
Followers 0
DEN

Player & Vehicle spawn underground

Question

Posted (edited)

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

Posted (edited)

@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.