Re: [sqlite] Problem writing to database using PHP under OS X

2008-07-15 Thread Tim Streater
At 15:39 14/07/2008, John LeSueur wrote:
>On Mon, Jul 14, 2008 at 4:28 AM, Tim Streater <[EMAIL PROTECTED]>
>wrote:
>
> > I have a small script which shows this problem: if I run it from the
> > command line I can read from and write to the database. If I run it in a
> > browser it fails at the write with "General error: 14 unable to open
> > database file" (having done the read OK
> > first).
> >
> > The database has permissions ugo+rwx which ought to mean anyone can read or
> > write it. This is under OS X 10.5.4.
> >
> > Suggestions welcome - thanks,
> >
> > -- Tim
> >
>
>what about the directory the database is in? sqlite needs to write journal
>files

Yes. Eventually I googled for the entire error message and found some useful 
message threads.

Thanks,

-- Tim

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Problem writing to database using PHP under OS X

2008-07-14 Thread John LeSueur
On Mon, Jul 14, 2008 at 4:28 AM, Tim Streater <[EMAIL PROTECTED]>
wrote:

> I have a small script which shows this problem: if I run it from the
> command line I can read from and write to the database. If I run it in a
> browser it fails at the write with "General error: 14 unable to open
> database file" (having done the read OK
> first).
>
> The database has permissions ugo+rwx which ought to mean anyone can read or
> write it. This is under OS X 10.5.4.
>
> Suggestions welcome - thanks,
>
> -- Tim
>

what about the directory the database is in? sqlite needs to write journal
files


>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users