On Tue, Jun 4, 2013 at 11:59 AM, Philip Goetz <philgo...@gmail.com> wrote:
> On Tue, Jun 4, 2013 at 11:27 AM, Richard Hipp <d...@sqlite.org> wrote: > > Try adding the command: > > > > .log stdout > > > > before running the CREATE INDEX and see what errors you get back. > > sqlite> .schema > CREATE TABLE taxon (gi INTEGER, taxon INTEGER); > sqlite> .log stdout > sqlite> create index taxon_gi_index on taxon(gi); > (14) os_win.c:34063: (3) > winOpen(/var/tmp/etilqs_PIREaghry4bPES8\etilqs_02LTi9u3HO3cx0g) - The > system cannot find the path specified. > (14) cannot open file at line 34071 of [cbea02d938] > (14) statement aborts at 21: [create index taxon_gi_index on taxon(gi);] > Error: unable to open database file > > Not finding paths often has to do with windows vs. unix vs. cygwin > file specifications. The above was running sqlite from the cygwin > command prompt. > But running it from the MS DOS command prompt with > E:\data\db\SQLite>C:/bin/os/cygwin/bin/sqlite3 gi2taxonNt > gives almost the same error (just a different /var/tmp filename). > I have write permission on /var/tmp and can make files in it. > But apparently it is trying to create a file in a subdirectory. I don't quite understand that. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
