Class kDBConnection has nice method called doInsert, that allows to insert data into database. It also can work in collect-only mode, when values are collected and then inserted using single database query, like INSERT .. VALUES (...),(...),(...) to improve execution speed.
In case, when all sql errors doesn't cause fatal error (e.g. debugger is disabled), then this could happen:
- you have 2 inserts into different tables to be executed one after another
- first insert fails, since database table corruption
- second insert tries to insert values from first insert and it's own values together resulting a failure, since column mismatch occurs.