Jump to content
IL-2 Series Forum

Sorties are never saved on the current build - one stray column name in an INSERT


Recommended Posts

Arrow_1974
Posted (edited)
@Akephal
Build: Steam buildid 25605106 (29 September 2026)

Summary
-------
No sortie row is written to any career database on this build. The INSERT
for the sortie table names 18 columns and supplies 17 values, so SQLite
rejects every one. This affects new and existing careers alike. Missions,
awards and pilot counters all save normally, so nothing looks wrong in
game - only the per-sortie record is missing.

The statement
-------------
(missionId, pilotId, planeId, rankId, isPlayer, date, status, health,
 score, planeStatus, planeHealth, killStats, assistCount, flightTime,
 fkill, escapedJail, eventFlags, returnTime)                    <- 18
VALUES(%d,%d,%d,%d,%d,'%s',%d,%d,%d,%d,%d,'%s',%d,%d,%d,%d,%d)  <- 17

The previous build listed 15 columns and 15 values. This build added three
names to the list - escapedJail, eventFlags, returnTime - and two values.

escapedJail also does not exist as a column: it is absent from the sortie
table in a career created new on this build, and updateScripts still ends
at 20260921_01.sql. Nothing reads or writes it anywhere else. The sibling
UPDATE statement has 17 assignments, does not mention escapedJail, and its
field order matches those 17 values exactly.

Removing escapedJail from the column list therefore leaves 17 columns
matching the 17 values, in the UPDATE's own order.

Evidence
--------
Career created fresh on this build, squadron flown, not touched otherwise:

  missions                 2
  sortie rows              0
  pilot counters           1 each, sortie table empty
  escapedJail column       absent

An existing career, three missions, 8 aircraft each:

  mission 40, 41, 42       exist, correct dates
  sortie rows              0, 0, 0
  pilot counter            25 sorties / 76872 flight time
  sortie table             23 sorties / 74983 flight time

data\_career.log, one line per pilot per mission:

  [SQL ERROR] sqlSave; 1; table sortie has no column named escapedJail

Awards earned in those same missions saved correctly.

Repro
-----
Create a career, let the squadron fly one day, then check data\_career.log
and SELECT COUNT(*) FROM sortie.

Disclosure: I run a small awards mod - an edited scg\2\awards.cfg plus
locale and texture files. It replaces data files only, no binaries, and
does not touch sortie handling.
Edited by Arrow_1974
New insights

AMD Ryzen 7 9800X3D; MSI MPG X870E CARBON WIFI Motherboard; ASRock Taichi Radeon RX 9070 XT 16GB; CORSAIR Vengeance RGB 64GB (2 x 32GB) DDR5 6000; 2x SK Hynix Platinum P41 M2 SSD 2TB; CORSAIR RMx Series RM850x ATX Power Supply; Arctic Liquid Freezer III Pro 360 A-RGB AIO; MONTECH KING 95 PRO Dual-Chamber ATX Mid-Tower, LG - UltraGear 45" OLED Dual Mode (5K2K WUHD 165Hz, WFHD 330Hz)

  • Arrow_1974 changed the title to Sorties are never saved on the current build - one stray column name in an INSERT

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
×
×
  • Create New...