SQLSTATE[HY000]: General error: 26 file is encrypted or is not a database
Reported by Matthew Turland | January 27th, 2009 @ 11:43 AM | in 0.30
The underlying library used by the pdo_sqlite adapter can vary depending on whether or not the standalone SQLite extension (as opposed to the newer SQLite3 extension) is installed. If the SQLite extension is not installed, pdo_sqlite will fall back to using the SQLite3 library. This causes the error cited in the title of this ticket when the extension is used to access a database created with a SQLite2 client library because SQLite3 clients are not backward-compatible.
This situation can be confirmed by checking the first X bytes of the SQLite database file being accessed. If they are equal to the string shown below then the file was created with a SQLite2 client. If this error occurs, a more friendly error message further explaining the situation should be displayed.
This file contains an SQLite 2.1 database
Comments and changes to this ticket
-
Kris Jordan February 4th, 2009 @ 05:34 PM
- State changed from “new” to “open”
Appreciate this very useful tip on how to determine the version of an SQLite database. Will use this method for the fix.
Currently this ticket remains open.
-
Kris Jordan March 30th, 2009 @ 09:51 PM
- Milestone changed from “0.11.1” to “0.30”
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
The Recess PHP Framework is an open source, full stack, RESTful PHP framework.
http://www.recessframework.org/
Kris Jordan