Full Screen Error Message every month

Hiya,

Every month that passes, I now have this error message:

SQL Error: NOT NULL constraint failed: Balance.Balance
Stack Track:
Stack Traceback

(1) Lua global ‘GetCompleteStackTrace’ at file ‘scripts/client/start scripts/debugger.lua:50’
(2) Lua global ‘ExecuteStmt’ at file ‘scripts/shared/functional/COMMON/CDatabase_Main.lua:42’
Local variables:
stmts = table: 0x0257a5e9c6c0 {1:sqlite virtual machine (Update Balance SET Balance= Balance + :Balance WHERE CUID=:CUID;) (more…)}
bindNames = table: 0x0257bc5aed00 {Balance:-44235292.383818, CUID:D4F84EBF4E2116D69198EC9F296C1AD7}
db = sqlite database (0000025785B94F30)
(for generator) = C function: next
(for state) = table: 0x0257a5e9c6c0 {1:sqlite virtual machine (Update Balance SET Balance= Balance + :Balance WHERE CUID=:CUID;) (more…)}
(for control) = userdata: 0x7fff00000002
_ = number: 1
stmt = sqlite virtual machine (Update Balance SET Balance= Balance + :Balance WHERE CUID=:CUID;)
result = number: 19
_ = nil
(*temporary) = C function: 0x02574ddc05e0
(*temporary) = nil
(*temporary) = string: “LuaSQLUpdateErrorTitle”
(*temporary) = string: “LuaSQLUpdateErrorDesc”
(*temporary) = C function: builtin#89
(*temporary) = sqlite virtual machine (Update Balance SET Balance= Balance + :Balance WHERE CUID=:CUID;)
(*temporary) = string: “SQL Error: %s
Stack Track: %s”
(*temporary) = string: “NOT NULL constraint failed: Balance.Balance”
(3) Lua method ‘ChangeBalance’ at file ‘scripts/shared/functional/COMMON/CFinances.lua:360’
Local variables:
self = table: 0x0257a5e7f940 {DB:sqlite database (0000025785B94F30), StmtHolder:table: 0x0257a5e9d540 (more…)}
balance = number: -4.42353e+07
(4) Lua field ‘Func’ at file ‘scripts/shared/functional/COMMON/CFinances.lua:1039’
Local variables:
self = table: 0x0257a5e7f940 {DB:sqlite database (0000025785B94F30), StmtHolder:table: 0x0257a5e9d540 (more…)}
time = table: 0x0257a6057000 {SpeedMultiplier:1, Held:table: 0x0257ce6da7c0, Speed:30, Paused:false, Game:table: 0x0257a6b8aac0 (more…)}
selectSQL = string: “SELECT Amount FROM Finances WHERE InternalDays <= 23701 AND Completed == 0;”
updateSQL = string: “UPDATE Finances SET Completed = 1 WHERE InternalDays <= 23701 AND Completed == 0;”
changeInBalance = number: -4.42353e+07
result = number: 0
(5) Lua method ‘DoCallbacks’ at file ‘scripts/shared/functional/CEventTime.lua:159’
Local variables:
self = table: 0x0257a6057000 {SpeedMultiplier:1, Held:table: 0x0257ce6da7c0, Speed:30, Paused:false, Game:table: 0x0257a6b8aac0 (more…)}
interval = string: “Month”
delta = number: 30
(for generator) = C function: next
(for state) = table: 0x0257a6056d00 {1:table: 0x0257a5e7fbc0, 2:table: 0x025793ce7080}
(for control) = userdata: 0x7fff00000002
_ = number: 1
callback = table: 0x0257a5e7fbc0 {Func:function: 0x02577b060670, Obj:table: 0x0257a5e7f940, ID:table: 0x0257a5e7f940 (more…)}
(6) Lua method ‘Tick’ at file ‘scripts/shared/functional/CEventTime.lua:67’
Local variables:
self = table: 0x0257a6057000 {SpeedMultiplier:1, Held:table: 0x0257ce6da7c0, Speed:30, Paused:false, Game:table: 0x0257a6b8aac0 (more…)}
oldTime = table: 0x0257bbbf8340 {Date:table: 0x0257bbbf5480}
(7) Lua method ‘Update’ at file ‘scripts/shared/functional/CEventTime.lua:286’
Local variables:
self = table: 0x0257a6057000 {SpeedMultiplier:1, Held:table: 0x0257ce6da7c0, Speed:30, Paused:false, Game:table: 0x0257a6b8aac0 (more…)}
dT = number: 0.0165794
(for index) = number: 30
(for limit) = number: 30
(for step) = number: 1
i = number: 30
(8) Lua method ‘PollThreads’ at file ‘scripts/shared/functional/CAMPAIGN_DATA/CGame_Main.lua:278’
Local variables:
self = table: 0x0257a6b8aac0 {GameTime:251.04507446289, Time:table: 0x0257a6057000, EngineFactories:table: 0x025707322e80 (more…)}
deltaTime = number: 0.0165794
currentTime = number: 251.045
dt = number: 0.0165794
(9) Lua function ‘?’ at file ‘scripts/ue4/init.lua:10’ (best guess)
Local variables:
DeltaTime = number: 0.0165794

BP Stack Trace

Unable to display Script Callstack. Compile with DO_BLUEPRINT_GUARD=1

Apologies, I meant to add, does anyone know the cause and potential fix for this?

Somehow your database has corrupted.

The error "“NOT NULL constraint failed: Balance.Balance” may be fixable if you edit your database with a tool like DBBrowser and set the Balance field of the Balance table back to a number again. This may have either been caused by something like a power outage, a faulty disk drive, or a very confused calculation resulting in an invalid number.