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.