In normal circumstances, I don’t have such problems.
Our major problem is unreliable electricity.

Any precauation you can take before ?

What you can do is:
1. Find error in code.
2. Make one backup table. Every time when you save a record save it in one more table.

Regards