Arrow_1974 Posted September 29 Posted September 29 (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 September 29 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)
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now