Limited Time Offer: 40% off
DB Pro
Product
Pricing
Studio
Devlog
About
Blog
Toggle theme
Download
Learn
/
SQLite
/
Errors
SQLite
SQLite Errors
Common errors with causes, solutions, and interactive examples.
Binding
column index out of range
Concurrency
SQLITE_BUSY: database is locked
SQLITE_LOCKED: table is locked
Constraint
SQLITE_CONSTRAINT: UNIQUE constraint failed
NOT NULL constraint failed
FOREIGN KEY constraint failed
CHECK constraint failed
PRIMARY KEY must be unique
Corruption
database disk image is malformed
File
SQLITE_CANTOPEN: unable to open database file
SQLITE_NOTADB: file is not a database
Function
no such function
Limit
SQLITE_TOOBIG: string or BLOB exceeds size limit
too many terms in compound SELECT
too many columns
too many SQL variables
parser stack overflow
Permission
attempt to write a readonly database
Query
ambiguous column name
misuse of aggregate function
Schema
no such table: tablename
no such column: columnname
SQLITE_SCHEMA: database schema has changed
table already exists
index already exists
circular reference in foreign key
cannot drop table: foreign key constraint
AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY
Cannot add a PRIMARY KEY column
Security
authorization denied
Storage
SQLITE_FULL: database or disk is full
Syntax
near "X": syntax error
incomplete input
unrecognized token
System
SQLITE_IOERR: disk I/O error
SQLITE_INTERRUPT: interrupted
SQLITE_NOMEM: out of memory
Transaction
cannot start a transaction within a transaction
cannot commit/rollback - no transaction is active
Type
SQLITE_MISMATCH: datatype mismatch
