note 41141 added to ref.sqlite

From: Date: Wed, 31 Mar 2004 14:30:13 +0000
Subject: note 41141 added to ref.sqlite
Groups: php.notes 
Request: Send a blank email to php-notes+get-67419@lists.php.net to get a copy of this message
To elaborate on vpupkin at comcast dot net's post about the INSERT query problem, you will be unable to execute any manipulation queries (INSERT/UPDATE/DELETE/ect) on the SQLite database file unless the directory the SQLite database file resides in is writable by the webserver. The reason for this is because SQLite needs to write a lock file to the hard drive. After a processes finishes writting, it deletes the lock file. Other processes check for the lock file before writting to the SQLite database file and if present, delay writting until the lock file is no longer present. ---- Manual Page -- http://www.php.net/manual/en/ref.sqlite.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+41141 Delete -- http://master.php.net/manage/user-notes.php?action=delete+41141&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+41141&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#67419) next »