On Mon, Apr 7, 2014 at 5:47 AM, Alejandro Santos <lis...@alejolp.com> wrote:
> Hi, > > I've been using latest v3.8.4.3 to write a database file, but when I > try to open the file with my current distro's sqlite shell I get this > error: > > $ sqlite3 file.sqlite > SQLite version 3.6.20 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .schema > Error: file is encrypted or is not a database > > This works fine with the original version used to write the file: > > $ ./sqlite3 ~/tmp/pbeastidx.sqlite > SQLite version 3.8.4.3 2014-04-03 16:53:12 > Enter ".help" for usage hints. > sqlite> .schema > CREATE TABLE ... > > I see no backwards compatibility issues documented on sqlite webpage. > Is the doc behind some changes? > Version 3.6.20 does not understand "PRAGMA journal_mode=WAL". You need to run "PRAGMA journal_mode=DELETE" from a 3.7.0 or later shell. After that you should be able to read and write the database using version 3.6.20. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
