Programming

SQLite: bind or column index out of range

When using PHP PDO with SQLite, the error messages sometimes are not really self-explaining. Today I had an error stating "bind or column index out of range". The "column index" part made me check the tables index and data type.

"Too many SQL variables" SQLite error

When developing apps by using SQLite as a storage backend, you most likely will sometime get the error message:

Too many SQL variables

The message very clearly describes what happened: you have prepared an SQL statement like "SELECT ... WHERE id=? OR id=? OR id=?" or at least something like that, and the placeholders (in this case the question marks) are too many.