#34699 [NEW]: PDO's sqlite driver unable to write to database

From: aidan@php.net Operating system: Linux PHP version: 6CVS-2005-10-01 (CVS) PHP Bug Type: PDO related Bug description: PDO's sqlite driver unable to write to database Description: ------------ In PHP6, PDO seems unable to write to a sqlite database. However, just to make it interesting, it's only a problem when the script is executed by the webserver (in my case apache). Initially I thought it was a permissions issue, but the database file was 666. Running the script from CLI worked as expected, running it from the webserver produced the error: Warning: PDO::query() [function.query]: SQLSTATE[HY000]: General error: 1 unable to open database file Confusing, because the database file is already open as demonstrated by the successful query of the same table in the previous line. Reproduce code: --------------- <?php $db = new PDO('sqlite:repository.db'); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $res = $db->query('SELECT visits from pages where id=1'); $tml = $res->fetchAll(); echo $tml[0][0], "\n"; $db->query('UPDATE pages SET visits = visits+1 WHERE id =1'); Expected result: ---------------- 23324 Actual result: -------------- 23324 Warning: PDO::query() [function.query]: SQLSTATE[HY000]: General error: 1 unable to open database file in /home/aidan/public_html/repos/database/test.php on line 10 -- Edit bug report at http://bugs.php.net/?id=34699&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=34699&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=34699&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=34699&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=34699&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=34699&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=34699&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=34699&r=needscript Try newer version: http://bugs.php.net/fix.php?id=34699&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=34699&r=support Expected behavior: http://bugs.php.net/fix.php?id=34699&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=34699&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=34699&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=34699&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=34699&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=34699&r=dst IIS Stability: http://bugs.php.net/fix.php?id=34699&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=34699&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=34699&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=34699&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=34699&r=mysqlcfg