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)

This entry was posted in General and tagged , . Bookmark the permalink.

7 Responses to Zend framework Quickstart and SQLite

  1. Peter says:

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

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

  2. Dumitru says:

    Thanks a lot! You saved my life..

  3. Esteban says:

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

  4. David Vogt says:

    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 says:

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

  6. pete says:

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

  7. luckyantoxa says:

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

Leave a Reply