title: SQLite, PDO, and PHP: New inserts not being saved
body: <p>I have a few PHP (version 5.1.6) scripts and an sqlite3 database. For a while, everything was working fine, including inserts, updates, selects, and deletes. </p>
  
  <p>Now:</p>
  
  <ul>
  <li>Select statements still work fine</li>
  <li>Inserts, deletes, and updates all fail without an error that I can see. A <code>-journal</code> file is created in the same directory as the database, but it later disappears. The sqlite file remains unmodified.</li>
  </ul>
  
  <p>I can't really figure out what, if anything, has changed. Permissions are the same. I've been able to open and save the database in another program, and replaced it with that version, but I still have the same problem. The scripts originally were all in autocommit mode; using explicit commits does not fix the problem either.</p>
  
  <p>If I replace the database file with an older backup, everything works just fine.</p>
  
  <p>I'd appreciate any ideas for troubleshooting. Thank you!</p>