Zend framework Quickstart and SQLite

I was building the Zend Framework quick start tutorial example but I kept getting the following error:

Message: SQLSTATE[HY000]: General error: 14 unable to open database file

This was despite the fact that I had correct privileges on the database file.

However it turns out you seem to need write and execute privileges for Apache on the directory that contains your sqlite database (not just the database file itself).

I added them to the containing directory and everything seems to work now. 🙂

[Link] (Nabble.com and the original source of this solution)

Comments

7 responses to “Zend framework Quickstart and SQLite”

  1. Peter Avatar
    Peter

    Thank you, this helped me! I had the same problem.

    I wonder why Apache needs execute (!) privileges for the containing directory. #strange

  2. Dumitru Avatar
    Dumitru

    Thanks a lot! You saved my life..

  3. Esteban Avatar
    Esteban

    Thanks for the tip. You solved the last of many problems that I had getting this tutorial site up and running.

  4. David Vogt Avatar

    Thanks a lot!

    BTW: It’s not apache’s fault. I have a setup running under cherokee and had the exact same problem – with the same solution. So this really is a sqlite issue.

  5. aurorius Avatar

    Aah, so that’s why I got those errors. Thanks dude

  6. pete Avatar
    pete

    Nope,
    I have rwx permissions recursively through out the application directory but still getting the same error
    Must be something else

  7. luckyantoxa Avatar

    Thanks a lot!!!!! Спасибо, долго не мог понять в чем дело!