Help needed Cannot save structure on new planet in ded server

Discussion in 'General Discussion' started by thommezik, Aug 15, 2024.

  1. thommezik

    thommezik Ensign

    Joined:
    Aug 15, 2024
    Messages:
    2
    Likes Received:
    0
    Hello,

    I have set up and configured a dedicated server using EAH. I set the scenario to "Default Multiplayer."

    When I play on the default planet Akua, everything works fine. However, when I create a new starting planet by copying the Akua planet and set the new planet as the starting one in "EpyrionSurvivalDedicated\epyrionsurvivaldedicated_srvr\Saves\Games\DediGame\Sectors\Sectors.yaml" by changing the coordinates, the new planet is offered to me as a player, and I can start on it. But as soon as I build a base, it disappears a few minutes after disconnecting, even though my player inventory and portable constructor remain.

    I found an issue in the log related to writing to SQLite.

    Can you advise me on what to do?

    Thank you.

    Dedicated log:

    15-08:48:25.969 10_48 -LOG- {EPM} Timelog: Send to Dedi: 2/min
    15-08:48:25.969 10_48 -LOG- {EPM} Timelog: Received from Dedi: 2/min
    15-08:49:20.871 10_49 -LOG- INFO: Uptime=00h21m 60,013 2395 heap= 329MB fps=40,0 players= 1 pfs=r0/i1/a1 ticks=453505700 nwqueue=Net:0/1
    15-08:49:25.968 10_49 -LOG- {EPM} Timelog: Send to Dedi: 2/min
    15-08:49:25.969 10_49 -LOG- {EPM} Timelog: Received from Dedi: 2/min
    15-08:49:41.987 10_49 -EXC- code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
    NOT NULL constraint failed: PlayerPosHistory.pfid
    at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <d52f09e2aa2f4a7593c588778ba249ea>:0
    at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <d52f09e2aa2f4a7593c588778ba249ea>:0
    at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00174] in <d52f09e2aa2f4a7593c588778ba249ea>:0
    at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x0008e] in <d52f09e2aa2f4a7593c588778ba249ea>:0
    at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <d52f09e2aa2f4a7593c588778ba249ea>:0
    at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <d52f09e2aa2f4a7593c588778ba249ea>:0
    at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <d52f09e2aa2f4a7593c588778ba249ea>:0
    at Assembly-CSharp.ConditionHelper.DeployMenu (Assembly-CSharp.SymbolManager+ConnectionQueue ) [0x0020d] in <787d82e7460645de8ad166f65b97a925>:0
    15-08:49:41.987 10_49 -ERR- INSERT INTO PlayerPosHistory (entityid, pfid, posx, posy, posz, attentityid, gametime) VALUES (@entityid, (SELECT pfid FROM Playfields WHERE name = @pfname), @posx, @posy, @posz, @attentityid, @gametime)
    15-08:49:41.987 10_49 -ERR- Parameters:
    15-08:49:41.987 10_49 -ERR- 0=637001
    15-08:49:41.987 10_49 -ERR- 1=Heaven
    15-08:49:41.987 10_49 -ERR- 2=-281
    15-08:49:41.987 10_49 -ERR- 3=39
    15-08:49:41.987 10_49 -ERR- 4=406
    15-08:49:41.987 10_49 -ERR- 5=
    15-08:49:41.987 10_49 -ERR- 6=453506049
     
    #1
  2. Taelyn

    Taelyn Administrator Staff Member Community Manager

    • Developer
    • Administrator
    Joined:
    Oct 4, 2021
    Messages:
    871
    Likes Received:
    1,369
    You cant modify files in the save game. This corrupts the database and the SQL errors you posted here show that

    You need to start a fresh SaveGame or result to a backup that was before you made the changes
     
    #2
  3. thommezik

    thommezik Ensign

    Joined:
    Aug 15, 2024
    Messages:
    2
    Likes Received:
    0
    Ok thanks
     
    #3

Share This Page