Posted by: Zook
« on: December 23, 2021, 12:13:27 PM »For others with the same problem: I got rid of these issue several times now.
- Download DB Browser for SQLite
- Save Aurora game, exit Aurora
- Make a backup of your Aurora DB!
- Start DB Browser, load DB
- Find table FCT_Increment. If you're stuck with 2-hour turns, you'll see a lot of 7200 second increments at the end of the table. Choose one that is several increments before the last and copy the timestamp (e.g. "2135824235.0").
- In the SQL command tab enter (with the timestamp from the step above):
SELECT * FROM FCT_FleetHistory
WHERE GameTime > 2135824235.0;
- Run it (click the Play button). You'll get the last couple of actions of all fleets. That should tell you which ones are misbehaving by jumping back and forth.
- Find these fleets in FCT_Fleet. There's a field called Xcor, the x-coordinate of the fleet. Change it by adding a large number. For example, if it reads "-1628493155.80953", change it to "-991628493155.80953". That should teleport the fleet many billions of km away from the jump point.
- Save changes. Done.
That fleet will spend several weeks or months moving back to the jump point. By that time, the reason for going back and forth (most likely an enemy fleet) might have disappeared. If not, rinse and repeat.
Disclaimer: Resist the urge to muck around with too many things in the DB. If you screw up your database, it's your problem. But then you made a backup, didn't you?
- Download DB Browser for SQLite
- Save Aurora game, exit Aurora
- Make a backup of your Aurora DB!
- Start DB Browser, load DB
- Find table FCT_Increment. If you're stuck with 2-hour turns, you'll see a lot of 7200 second increments at the end of the table. Choose one that is several increments before the last and copy the timestamp (e.g. "2135824235.0").
- In the SQL command tab enter (with the timestamp from the step above):
SELECT * FROM FCT_FleetHistory
WHERE GameTime > 2135824235.0;
- Run it (click the Play button). You'll get the last couple of actions of all fleets. That should tell you which ones are misbehaving by jumping back and forth.
- Find these fleets in FCT_Fleet. There's a field called Xcor, the x-coordinate of the fleet. Change it by adding a large number. For example, if it reads "-1628493155.80953", change it to "-991628493155.80953". That should teleport the fleet many billions of km away from the jump point.
- Save changes. Done.
That fleet will spend several weeks or months moving back to the jump point. By that time, the reason for going back and forth (most likely an enemy fleet) might have disappeared. If not, rinse and repeat.
Disclaimer: Resist the urge to muck around with too many things in the DB. If you screw up your database, it's your problem. But then you made a backup, didn't you?