Edgewall Software

Changes between Version 55 and Version 56 of PySqlite


Ignore:
Timestamp:
Feb 24, 2011, 11:27:32 AM (13 years ago)
Author:
Christian Boos
Comment:

Clarify the 3 possible causes for file is encrypted... error

Legend:

Unmodified
Added
Removed
Modified
  • PySqlite

    v55 v56  
    228228==== `DatabaseError: file is encrypted or is not a database` ====
    229229
    230 This somewhat ''cryptic'' error message happens when trying to modify the database file and the '''write''' permission is missing.
    231 
    232 Otherwise, this is also a typical error seen when accessing a SQLite 2.x database file with a SQLite 3.x library. This error also happen when accessing a database that has been created in or explicitly converted to WAL mode, using a version of SQLite older than 3.7.0 (i.e. with no WAL support).
    233 
    234 See [#UpgradingSQLitefrom2.xto3.x above] for the upgrade instructions.
     230There are typically three situations in which this somewhat ''cryptic'' error message can be seen:
     231 - when trying to modify the database file and the '''write''' permission is missing; fix the permissions
     232 - when accessing a SQLite 2.x database file with a SQLite 3.x library; see [#UpgradingSQLitefrom2.xto3.x above] for the upgrade instructions.
     233 - when accessing a database that has been created in or explicitly converted to WAL mode, using a version of SQLite older than 3.7.0 (i.e. with no WAL support); upgrade your bindings to use a recent SQLite
     234
    235235
    236236==== `OperationalError: SQL logic error or missing database` ====