Igor Tandetnik wrote: > raf wrote: > >using sqlite-3.2.7 via the perl module, DBD-SQLite-1.11, > >from a cgi script via apache on linux on a local filesystem, > >i received this error: > > > > DBD::SQLite::st execute failed: unable to open database file(1) at > >dbdimp.c line 398 > > > >the database was publically writable (for use via apache) > >but its parent directory wasn't. making its parent > >directory world writable as well made the insert work > >and made the error message stop appearing. > > SQLite needs to be able to create a journal file in the same directory > as the DB, before any modifications can take place. The journal is used > to support transaction rollback. > > Igor Tandetnik
thanks for the explanation. cheers, raf
