You need a semicolon at the end of the `INSERT` statement within the `TRANSACTION`, not a comma. If you paste your queries into the `sqlite3` command line app, you get a syntax error when it hits `UPDATE`, since you can't use that keyword as part of an `INSERT` query.