sqlite3 runs INSERT and UPDATE queries fine first time, but second time returns error.

Answer 1

It would help if you would show the 'assert error' and maybe a stacktrace to see what call actually fails.

Also, note that even though you are checking for errors, you are not doing it correctly. Even if an error happens, you continue to exeute sqlite functions. That is a recipe for disaster.