Zend framework Quickstart and SQLite

Posted on 19 November 2008 by Angus Hardie

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:
    24 March 2009 at 12:01 pm

    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:
    15 April 2009 at 10:08 pm

    Thanks a lot! You saved my life..

  3. Esteban says:
    12 January 2010 at 5:52 pm

    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:
    11 February 2010 at 2:08 pm

    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:
    12 May 2010 at 10:33 am

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

  6. pete says:
    15 June 2010 at 1:25 am

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

  7. luckyantoxa says:
    22 March 2011 at 11:42 am

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

Leave a Reply