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 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
> .
>
> --- Markus Wolff <[EMAIL PROTECTED]> wrote:
> > I'm trying to open an SQLite3 database from a PHP very simple PHP
> > script:
> >
> > $db = dirname(__FILE__).'/frontend.db';
> > $pdo = new PDO('sqlite:'.$db);
> > $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
> > $pdo->query("SELECT * FROM page LIMIT 1");
> > echo "Deleting pages\n";
> > $pdo->query("DELETE FROM page");
> > echo "Deleting websites\n";
> > $pdo->query("DELETE FROM website");
> >
> > The database file contains no data whatsoever, just the table
> > definitions (in case you were wondering, this is a stripped-down version
> > of a larger script for debugging purposes, hence the seemingly idiotic
> > DELETE statements that won't do any good in an empty database anyway,
> > but I digress...).
> >
> > When executed on the command line, this works perfectly. When I execute
> > the same script via Apache and mod_php, I'm getting this exception:
> >
> > PDOException: SQLSTATE[HY000]: General error: 1 SQL logic error or
> > missing database in /home/mwolff/webs/markus/cms/test.php on line 8
>
>
>
> ____________________________________________________________________________________
> Shape Yahoo! in your own image. Join our Network Research Panel today!
> http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
>
>
>
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
> -----------------------------------------------------------------------------
>
--
Mit freundlichen Grüßen
Markus Wolff
Development
NorthClick GmbH
Gasstr. 10 - 22761 Hamburg
Tel.: 040 8 22 44 999 - Fax: 040 8 22 44 998
Internet: http://www.northclick.de/
Geschäftsführer: F. Detzner | M. Henze | C. Springub
Amtsgericht Hamburg, HRB 94459
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
