Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

SQLSTATE[HY000]: General error: 26 file is encrypted or is not a database

#55

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

Reported by Matthew Turland · January 27th, 2009 @ 11:43 AM

State: open
Milestone: 0.30
Assigned to: Kris Jordan Kris Jordan

Activity

  1. Kris Jordan
    Kris Jordan
    • 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.

    February 4th, 2009 @ 05:34 PM

  2. Kris Jordan
    Kris Jordan
    • Milestone changed from 0.11.1 to 0.30

    March 30th, 2009 @ 09:51 PM

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.