Changes between Version 63 and Version 64 of PySqlite
- Timestamp:
- Jul 20, 2015, 8:32:18 AM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
PySqlite
v63 v64 1 1 = PySqlite 2 2 3 [ https://pypi.python.org/pypi/pysqlite PySqlite] is a Python binding for the [http://www.sqlite.org SQLite] light-weight database engine, which is Trac's default DatabaseBackend.3 [pypi:pysqlite PySqlite] is a Python binding for the [http://www.sqlite.org SQLite] light-weight database engine, which is Trac's default DatabaseBackend. 4 4 5 5 == Installation 6 6 === The short version 7 7 8 If you 're using Python 2.5 and up, you already have a working version of pysqlite 2, bundled as `sqlite3`.9 10 If you are using an older version of Python or you 'd like to benefit from the latest version of pysqlite, grab Windows installer or the source .tar.gz from the official [https://pypi.python.org/pypi/pysqlite pysqlite site].8 If you are using Python 2.5 and up, you already have a working version of pysqlite 2, bundled as `sqlite3`. 9 10 If you are using an older version of Python or you would like to benefit from the latest version of pysqlite, grab Windows installer or the source .tar.gz from the official [https://pypi.python.org/pypi/pysqlite pysqlite site]. 11 11 12 12 If you need to build from this .tar.gz, simply do after unpacking: … … 16 16 This will fetch the latest SQLite version and bundle it within the extension. 17 17 18 [[PageOutline(2-4 )]]18 [[PageOutline(2-4,Contents,pullout)]] 19 19 20 20 === The SQLite library … … 43 43 44 44 Detailed information about older releases: 45 * Trac 0.12.x requires a PySqlite 2.x release 45 * Trac 0.12.x requires a PySqlite 2.x release: 46 46 * version >= 2.0.5 preferred, 47 47 * 2.0.3 has been reported to cause crashes on Windows (#2688) … … 54 54 are working perfectly) 55 55 * The ''2.3.2'' version is the one which ships with Python 2.5, available there as the `sqlite3` package. Trac tries to use it if the `pysqlite2` package is installed. 56 * You need ''2.3.3''if you use Apache and `mod_cache`, see Pysqlite:#174.56 * You need the ''2.3.3'' version if you use Apache and `mod_cache`, see Pysqlite:#174. 57 57 58 58 {{{#!div style="border: 1pt dotted; margin: 1em" … … 85 85 86 86 == Upgrading SQLite 87 87 88 === Upgrading SQLite from 2.x to 3.x 88 89 … … 145 146 ==== `OperationalError: unsupported file format` 146 147 147 ''This probably is symptomatic of a mismatch between the SQLite library and the SQLite database format.'' 148 149 See Trac-ML:7540 148 This probably is symptomatic of a mismatch between the SQLite library and the SQLite database format. See Trac-ML:7540. 150 149 151 150 And this might be caused by a different version of PHP's pdo_sqlite module when you use Trac in mod_python mode. Check your pdo_sqlite module's version, or if OK, you may simply disable it, see `/etc/php.d/pdo_sqlite.ini`. Note that sqlite 3.3.x and 3.2.x are not compatible. … … 153 152 ==== `DatabaseError: file is encrypted or is not a database` 154 153 155 There are typically three situations in which this somewhat ''cryptic''error message can be seen:156 - when trying to modify the database file and the '''write''' permission is missing; fix the permissions 154 There are typically three situations in which this somewhat cryptic error message can be seen: 155 - when trying to modify the database file and the '''write''' permission is missing; fix the permissions. 157 156 - when accessing a SQLite 2.x database file with a SQLite 3.x library; see [#UpgradingSQLitefrom2.xto3.x above] for the upgrade instructions. 158 157 - 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, ie with no WAL support; upgrade your bindings to use a recent SQLite.