Mixing SQLite version databases will cause problems

[Dane Iracleous]

Originally reported on Google Code with ID 3 ``` If you have pre-existing SQLite databases that are not all the same version (for example, if you have an SQLite2 database called "db1.db" and an SQLite3 database called "db2.db"), and you include them all in the array of databases at the top of the phpLiteAdmin.php file, the application will use the latest version of SQLite installed on your server, which will cause the SQLite3 databases to work fine but will cause errors for the SQLite2 databases.

For the time being, make sure that if you are able to use SQLite3, use it. Do not mix SQLite versions. SQLite2 is outdated and much slower than SQLite3 anyway, so it is in your best interest to stick with SQLite3 if your installation of PHP allows it.

In a future release, there may be an option to choose whether you want your databases treated as SQLite3 or SQLite2.

```

Reported by `diracleo` on 2011-03-06 19:07:52

[Dane Iracleous]

``` This issue has been fixed in v1.3. Each database in the array must now include a version field specifying which version of SQLite it is. Because of this, different versions can be mixed without problems. ```

Reported by `diracleo` on 2011-03-07 00:03:37 - Status changed: `Fixed`

[phpLiteAdmin]

Issue #337 was marked as a duplicate of this issue.