sqlite: CommitTransaction: cannot commit - no transaction is active
Describe the bug
I am doing a simple db.execute DELETE FROM table; in the browser and got this since a few release (cannot tell since when, sry). Any idea what could cause this? I do a PRAGMA foreign_keys = OFF; before (to easier wipe all data in that case). All other SQL execute just fine before.
Execute Error Error: Execute: ExecuteSQL: ExecuteSQL: CommitTransaction: cannot commit - no transaction is active : RollbackTransaction: cannot rollback - no transaction is active
To Reproduce Steps to reproduce the behavior:
- Simple delete from
Expected behavior More detailed errors…
Screenshots If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
- OS: macOS
- Browser: Brave
- Version: latest
Smartphone (please complete the following information):
- Device: [e.g. iPhone6]
- OS: [e.g. iOS8.1]
- Browser [e.g. stock browser, safari]
- Version [e.g. 22]
Additional context Add any other context about the problem here.
About this issue
- Original URL
- State: closed
- Created a year ago
- Comments: 27 (13 by maintainers)
@muuvmuuv the idea of setting transaction to false on any execute, executeSet and run was made for the use with typeOrm. it also can be use to able a developer to manage itself the transaction through the BEGIN TRANSACTION, COMMIT TRANSACTION & ROLLBACK TRANSACTION through execute method