search

opless / phpliteadmin

Automatically exported from code.google.com/p/phpliteadmin
0 stars 0 forks source link

Mixing SQLite version databases will cause problems #3

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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.

Original issue reported on code.google.com by daneirac...@gmail.com on 6 Mar 2011 at 7:07

GoogleCodeExporter commented 9 years ago 
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.

Original comment by daneirac...@gmail.com on 7 Mar 2011 at 12:03