Re: [sqlite] "database is locked" on clean install, empty database?

On Mon, Mar 3, 2008 at 12:59 PM, Andreas Kupries <[EMAIL PROTECTED]> wrote: > Is the database file by chance in a NFS mounted directory ? That was it. Thanks! Sean -- "Humanity has advanced, when it has advanced, not because it has been sober, responsible, and cautious, but because it has

Re: [sqlite] "database is locked" on clean install, empty database?

Sean Rhea wrote: > sqlite> create table foo (node_id, timestamp, tput); > SQL error: database is locked > > What am I doing wrong? > Sean, Ensure that you have write privileges for the database file and the directory it is in. SQLite needs to create a journal file in the same directory for

Re: [sqlite] "database is locked" on clean install, empty database?

> > I must be missing something: > > $ sudo apt-get install sqlite3 > ... > Selecting previously deselected package sqlite3. > ... > Setting up sqlite3 (3.3.8-1.1) ... > $ ls -l test.db > ls: test.db: No such file or directory > $ sqlite3 test.db > SQLite version 3.3.8 > Enter ".help" for

[sqlite] "database is locked" on clean install, empty database?

I must be missing something: $ sudo apt-get install sqlite3 ... Selecting previously deselected package sqlite3. ... Setting up sqlite3 (3.3.8-1.1) ... $ ls -l test.db ls: test.db: No such file or directory $ sqlite3 test.db SQLite version 3.3.8 Enter ".help" for instructions sqlite> create table