Re: [sqlite] Problems with SQLite and PHP

2007-10-08 Thread Trevor Talbot
On 10/8/07, Markus Wolff - NorthClick <[EMAIL PROTECTED]> wrote: > I find this to be a bit irritating - shouldn't it be enough that the > server can dive into that subdir and find a file it can actually write > to within the dir? How does it make sense that the entire directory > containing the

Re: [sqlite] Problems with SQLite and PHP

2007-10-08 Thread Andy Goth
On Mon, 08 Oct 2007 13:12:08 +0200, Markus Wolff - NorthClick wrote > How does it make sense that the entire directory containing the > directory must be writeable? Sounds like a temporary file or lock file is being created. Somebody who knows more about PHP or SQLite can tell you which is

Re: [sqlite] Problems with SQLite and PHP

2007-10-08 Thread Markus Wolff - NorthClick
I have found the problem. PHP was happily reporting that the frontend.db file itself is writeable (which was true all the time), but the directory containing the database was not writeable by the webserver. I find this to be a bit irritating - shouldn't it be enough that the server can dive into

Re: [sqlite] Problems with SQLite and PHP

2007-10-08 Thread Markus Wolff - NorthClick
Am Freitag, den 05.10.2007, 01:03 +0200 schrieb Kees Nuyt: > I can't reproduce the exception (the PDO->query > version) on an environment I happened to have > available. > > - MS Windows XP Professional (5.2 build 2600) > - Apache 2.2.4 > - PHP 5.2.2 > - PDO SQLite 1.0.1 2007/03/23 > - SQLite

Re: [sqlite] Problems with SQLite and PHP

2007-10-08 Thread Markus Wolff - NorthClick
Hi Joe, standard temp directory in my setup is /tmp, which is both readable and writeable by Apache. Available space is 21GB, which should be more than sufficient for the task at hand :-) CU Markus Am Donnerstag, den 04.10.2007, 16:13 -0700 schrieb Joe Wilson: > See if the apache/mod_php

Re: [sqlite] Problems with SQLite and PHP

2007-10-04 Thread Joe Wilson
See if the apache/mod_php process' unix account can read/write to at least one of the following directories and there is sufficient disk space in the first such directory that is r/w. pragma temp_store_directory; -- if present. As run in apache. /var/tmp /usr/tmp /tmp

Re: [sqlite] Problems with SQLite and PHP

2007-10-04 Thread Kees Nuyt
Hi Markus, On Thu, 04 Oct 2007 23:37:33 +0200, you wrote: >Hello everone, > >I'm having a really weird problem with SQLite when used with PHP - I'm >pretty sure it's not SQLite that's at fault here, but since in the >PHP-DB mailingliste nobody seemed to be able to help me, I'm hoping to >get