Bug #51733 [NEW]: SQLite3::exec() fails with disk I/O error

From: Operating system: Ubuntu 10.04, FreeBSD 8 PHP version: 5.3.2 Package: SQLite related Bug Type: Bug Bug description:SQLite3::exec() fails with disk I/O error Description: ------------ I've tested this problem and it is duplicable on Ubuntu 10.04 and FreeBSD 8, both with 5.3.2 installed (from apt-get/ports). I also did a build of 5.3.2 from source to test this and it failed in the same way. The problem comes when you try to create a table in a newly created database when using the SQLite3 class. The empty db is created without error and when you then try to create a table, you get the following error: PHP Warning: SQLite3::exec(): disk I/O error in php shell code on line 1 This is the same error in all builds on all OSes. Test script: --------------- $ php -a php > $s = new SQLite3('/home/jdeiman/tmp/php.db', SQLITE3_OPEN_CREATE); php > $ret = $s->exec('CREATE table testing (id integer)'); PHP Warning: SQLite3::exec(): disk I/O error in php shell code on line 1 -- Edit bug report at http://bugs.php.net/bug.php?id=51733&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=51733&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=51733&r=trysnapshot53 Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=51733&r=trysnapshot60 Fixed in SVN: http://bugs.php.net/fix.php?id=51733&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=51733&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=51733&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=51733&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=51733&r=needscript Try newer version: http://bugs.php.net/fix.php?id=51733&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=51733&r=support Expected behavior: http://bugs.php.net/fix.php?id=51733&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=51733&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=51733&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=51733&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=51733&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=51733&r=dst IIS Stability: http://bugs.php.net/fix.php?id=51733&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=51733&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=51733&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=51733&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=51733&r=mysqlcfg