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. $ ls -l /var/tmp total 4.0K drwxrwxrwt+ 1 phil None 0 Jun 4 11:56 ./ drwxr-xr-x+ 1 phil None 0 May 28 22:10 ../ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users