On Mon, Apr 7, 2014 at 11: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:
>

For some reason I can see Richard Hipp answer on the Web but not on my
Gmail account.

Changing the journal_mode does not solve my issue :(

$ ./sqlite3 -header ~/tmp/file.sqlite
SQLite version 3.8.4.3 2014-04-03 16:53:12
Enter ".help" for usage hints.
sqlite> PRAGMA journal_mode=DELETE;
journal_mode
delete
sqlite>

$ ./sqlite3 -header ~/tmp/file.sqlite
SQLite version 3.8.4.3 2014-04-03 16:53:12
Enter ".help" for usage hints.
sqlite> PRAGMA journal_mode;
journal_mode
delete
sqlite>

$ sqlite3 -header ~/tmp/file.sqlite
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> PRAGMA journal_mode;
journal_mode
delete
sqlite> .schema
Error: file is encrypted or is not a database

Thank you,

-- 
Alejandro Santos
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to